public static splitStatements(script as String) as ArrayList<String>
Splits a multi-statement SQL script into trimmed, non-empty SQL statements.
| Parameter | Description |
|---|---|
script | Complete SQL script text. |
Ordered list of executable SQL statement strings.
import klyn.code.sql
stmts = SqlScriptSplitter.splitStatements("SELECT 1;\nSELECT 'x;y';")
assert stmts.size == 2
assert stmts[0] == "SELECT 1"
assert stmts[1] == "SELECT 'x;y'"