sqlparser

func ParseSQLMigration ¶

func ParseSQLMigration(r io.Reader, logger *slog.Logger) (*ParsedSQL, error)

Split given SQL script into individual statements and return SQL statements for given direction (up=true, down=false).

The base case is to simply split on semicolons, as these naturally terminate a statement.

However, more complex cases like pl/pgsql can have semicolons within a statement. For these cases, we provide the explicit annotations 'StatementBegin' and 'StatementEnd' to allow the script to tell us to ignore semicolons.

func ParseSQLMigrationFromFS ¶

func ParseSQLMigrationFromFS(logger *slog.Logger, fsys fs.FS, filename string) (*ParsedSQL, error)