Sql Script Runner for JdbcTemplate

SqlScriptRunner.kt

import org.springframework.jdbc.core.JdbcTemplate
import org.springframework.jdbc.support.rowset.SqlRowSet

class SqlScriptRunner(private val jdbcTemplate: JdbcTemplate) {

    fun executeSqlScriptAndGetLastResult(sqlScript: String): SqlRowSet? {
        // Split script into individual statements by ";", ignoring line comments "--" and block comments "/* */"
        val statements = sqlScript.split("(?<!;)\\s*;\\s*(?=(?:[^']*'[^']*')*[^']*$)".toRegex())
            .map { it.trim() }
            .filter { it.isNotEmpty() }

        // Execute each statement in sequence, capturing the result of the last statement only
        var resultSet: SqlRowSet? = null
        statements.forEachIndexed { index, statement ->
            if (index < statements.size - 1) {
                jdbcTemplate.execute(statement)
            } else {
                // For the last statement, use queryForRowSet to get the result
                resultSet = jdbcTemplate.queryForRowSet(statement)
            }
        }
        return resultSet // Result set from the last statement
    }
}