README
¶
sqlss
Split SQL into statements.
Do not split within single quotes, double quotes, or back quotes. It also doesn't break at semicolons in comments.
Usage
package main
import (
"fmt"
"github.com/noborus/sqlss"
)
func main() {
queries := sqlss.SplitQueries("SELECT * FROM table1;SELECT * FROM table2;")
for _, query := range queries {
fmt.Println(query)
}
}
// Output:
// SELECT * FROM table1
// SELECT * FROM table2
Documentation
¶
Index ¶
Examples ¶
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
func SplitQueries ¶
SplitQueries splits a string of semicolon-separated SQL queries into individual queries. It does not split semicolons that are within single quotes, double quotes, back quotes or escaped by two single quotes.
Example ¶
package main
import (
"fmt"
"github.com/noborus/sqlss"
)
func main() {
sql := `UPDATE users SET name='Bob' WHERE id=1;SELECT * FROM users;`
queries := sqlss.SplitQueries(sql)
for _, query := range queries {
fmt.Println(query)
}
}
Output: UPDATE users SET name='Bob' WHERE id=1 SELECT * FROM users
Example (Second) ¶
package main
import (
"fmt"
"github.com/noborus/sqlss"
)
func main() {
sql := `SELECT 'O''Reilly' ; SELECT 2;`
queries := sqlss.SplitQueries(sql)
for _, query := range queries {
fmt.Println(query)
}
}
Output: SELECT 'O''Reilly' SELECT 2
Types ¶
This section is empty.
Source Files
Directories
Click to show internal directories.
Click to hide internal directories.