package sqlparse_test import ( "bytes" "errors" "io" "strings" "testing" "git.sr.ht/~eugenetriguba/bolt/internal/sqlparse" "git.sr.ht/~eugenetriguba/checkmate/assert" "git.sr.ht/~eugenetriguba/checkmate/check" ) func TestSqlParser_Parse(t *testing.T) { testCases := []struct { migration string expectedUpgradeScript sqlparse.MigrationScript expectedDowngradeScript sqlparse.MigrationScript }{ { migration: "", expectedUpgradeScript: sqlparse.MigrationScript{ Contents: "", Options: sqlparse.ExecutionOptions{}, }, expectedDowngradeScript: sqlparse.MigrationScript{ Contents: "", Options: sqlparse.ExecutionOptions{}, }, }, { migration: ` -- migrate:up CREATE TABLE users(id int PRIMARY KEY);`, expectedUpgradeScript: sqlparse.MigrationScript{ Contents: "CREATE TABLE users(id int PRIMARY KEY);\n", Options: sqlparse.ExecutionOptions{UseTransaction: true}, }, expectedDowngradeScript: sqlparse.MigrationScript{ Contents: "", Options: sqlparse.ExecutionOptions{}, }, }, { migration: ` -- migrate:up transaction:false CREATE TABLE users(id int PRIMARY KEY);`, expectedUpgradeScript: sqlparse.MigrationScript{ Contents: "CREATE TABLE users(id int PRIMARY KEY);\n", Options: sqlparse.ExecutionOptions{UseTransaction: false}, }, expectedDowngradeScript: sqlparse.MigrationScript{ Contents: "", Options: sqlparse.ExecutionOptions{}, }, }, { migration: ` -- migrate:up transaction:true CREATE TABLE users(id int PRIMARY KEY);`, expectedUpgradeScript: sqlparse.MigrationScript{ Contents: "CREATE TABLE users(id int PRIMARY KEY);\n", Options: sqlparse.ExecutionOptions{UseTransaction: true}, }, expectedDowngradeScript: sqlparse.MigrationScript{ Contents: "", Options: sqlparse.ExecutionOptions{}, }, }, { migration: ` -- transaction:true migrate:up CREATE TABLE users(id int PRIMARY KEY);`, expectedUpgradeScript: sqlparse.MigrationScript{ Contents: "", Options: sqlparse.ExecutionOptions{}, }, expectedDowngradeScript: sqlparse.MigrationScript{ Contents: "", Options: sqlparse.ExecutionOptions{}, }, }, { migration: ` -- migrate:down DROP TABLE users;`, expectedUpgradeScript: sqlparse.MigrationScript{ Contents: "", Options: sqlparse.ExecutionOptions{}, }, expectedDowngradeScript: sqlparse.MigrationScript{ Contents: "DROP TABLE users;\n", Options: sqlparse.ExecutionOptions{UseTransaction: true}, }, }, { migration: ` -- migrate:down transaction:false DROP TABLE users;`, expectedUpgradeScript: sqlparse.MigrationScript{ Contents: "", Options: sqlparse.ExecutionOptions{}, }, expectedDowngradeScript: sqlparse.MigrationScript{ Contents: "DROP TABLE users;\n", Options: sqlparse.ExecutionOptions{UseTransaction: false}, }, }, { migration: ` -- migrate:down transaction:true DROP TABLE users;`, expectedUpgradeScript: sqlparse.MigrationScript{ Contents: "", Options: sqlparse.ExecutionOptions{}, }, expectedDowngradeScript: sqlparse.MigrationScript{ Contents: "DROP TABLE users;\n", Options: sqlparse.ExecutionOptions{UseTransaction: true}, }, }, { migration: ` -- transaction:true migrate:down DROP TABLE users;`, expectedUpgradeScript: sqlparse.MigrationScript{ Contents: "", Options: sqlparse.ExecutionOptions{}, }, expectedDowngradeScript: sqlparse.MigrationScript{ Contents: "", Options: sqlparse.ExecutionOptions{}, }, }, { migration: ` -- migrate:up CREATE TABLE users(id int PRIMARY KEY); -- migrate:down DROP TABLE users;`, expectedUpgradeScript: sqlparse.MigrationScript{ Contents: "CREATE TABLE users(id int PRIMARY KEY);\n", Options: sqlparse.ExecutionOptions{UseTransaction: true}, }, expectedDowngradeScript: sqlparse.MigrationScript{ Contents: "DROP TABLE users;\n", Options: sqlparse.ExecutionOptions{UseTransaction: true}, }, }, { migration: ` -- migrate:up transaction:false CREATE TABLE users(id int PRIMARY KEY); -- migrate:down transaction:false DROP TABLE users;`, expectedUpgradeScript: sqlparse.MigrationScript{ Contents: "CREATE TABLE users(id int PRIMARY KEY);\n", Options: sqlparse.ExecutionOptions{UseTransaction: false}, }, expectedDowngradeScript: sqlparse.MigrationScript{ Contents: "DROP TABLE users;\n", Options: sqlparse.ExecutionOptions{UseTransaction: false}, }, }, { migration: ` -- MIGRATE:UP TRANSACTION:FALSE CREATE TABLE users(id int PRIMARY KEY); -- MIGRATE:DOWN TRANSACTION:FALSE DROP TABLE users;`, expectedUpgradeScript: sqlparse.MigrationScript{ Contents: "CREATE TABLE users(id int PRIMARY KEY);\n", Options: sqlparse.ExecutionOptions{UseTransaction: false}, }, expectedDowngradeScript: sqlparse.MigrationScript{ Contents: "DROP TABLE users;\n", Options: sqlparse.ExecutionOptions{UseTransaction: false}, }, }, } for _, tc := range testCases { sqlParser := sqlparse.NewSqlParser() migration, err := sqlParser.Parse( strings.NewReader(tc.migration), ) assert.Nil(t, err) check.DeepEqual(t, migration.UpgradeScript, tc.expectedUpgradeScript) check.DeepEqual(t, migration.DowngradeScript, tc.expectedDowngradeScript) } } type ErrReader struct { Reader io.Reader ErrCond string } func (er *ErrReader) Read(p []byte) (int, error) { n, err := er.Reader.Read(p) if err != nil { return n, err } if bytes.Contains(p[:n], []byte(er.ErrCond)) { return n, errors.New("error: unwanted input encountered") } return n, nil } func TestSqlParserParseError(t *testing.T) { reader := &ErrReader{ Reader: strings.NewReader(" "), ErrCond: " ", } sqlParser := sqlparse.NewSqlParser() _, err := sqlParser.Parse(reader) assert.NotNil(t, err) assert.ErrorContains(t, err, "unwanted input encountered") } func TestSqlParser_ParseDependencies(t *testing.T) { testCases := []struct { name string migration string expectedDependencies []string }{ { name: "no dependencies", migration: "-- migrate:up\nCREATE TABLE users(id int);", expectedDependencies: []string{}, }, { name: "single dependency", migration: "-- depends: 001\n-- migrate:up\nCREATE TABLE users(id int);", expectedDependencies: []string{"001"}, }, { name: "multiple dependencies", migration: "-- depends: 001, 002, 003\n-- migrate:up\nCREATE TABLE users(id int);", expectedDependencies: []string{"001", "002", "003"}, }, { name: "multiple dependencies without spaces", migration: "-- depends: 001,002,003\n-- migrate:up\nCREATE TABLE users(id int);", expectedDependencies: []string{"001", "002", "003"}, }, { name: "case insensitive depends", migration: "-- DEPENDS: 001, 002\n-- migrate:up\nCREATE TABLE users(id int);", expectedDependencies: []string{"001", "002"}, }, { name: "mixed case depends", migration: "-- Depends: 001\n-- migrate:up\nCREATE TABLE users(id int);", expectedDependencies: []string{"001"}, }, { name: "empty depends directive", migration: "-- depends: \n-- migrate:up\nCREATE TABLE users(id int);", expectedDependencies: []string{}, }, { name: "depends with trailing comma", migration: "-- depends: 001, 002,\n-- migrate:up\nCREATE TABLE users(id int);", expectedDependencies: []string{"001", "002"}, }, { name: "depends with extra whitespace", migration: "-- depends: 001 , 002 , 003 \n-- migrate:up\nCREATE TABLE users(id int);", expectedDependencies: []string{"001", "002", "003"}, }, { name: "timestamp version dependencies", migration: "-- depends: 20240316145038, 20240317120000\n-- migrate:up\nCREATE TABLE posts(id int);", expectedDependencies: []string{"20240316145038", "20240317120000"}, }, { name: "multiple depends directives", migration: `-- depends: 001 -- depends: 002 -- migrate:up CREATE TABLE users(id int);`, expectedDependencies: []string{"001", "002"}, }, { name: "depends before up and down", migration: `-- depends: 001, 002 -- migrate:up CREATE TABLE users(id int); -- migrate:down DROP TABLE users;`, expectedDependencies: []string{"001", "002"}, }, { name: "depends anywhere in file", migration: `-- depends: 004 -- migrate:up -- depends: 003 CREATE TABLE users(id int); -- migrate:down -- depends: 002 DROP TABLE users; -- depends: 001`, expectedDependencies: []string{"004", "003", "002", "001"}, }, } for _, tc := range testCases { t.Run(tc.name, func(t *testing.T) { sqlParser := sqlparse.NewSqlParser() migration, err := sqlParser.Parse(strings.NewReader(tc.migration)) assert.Nil(t, err) check.DeepEqual(t, migration.Dependencies, tc.expectedDependencies) }) } }