aboutsummaryrefslogtreecommitdiffstats
path: root/internal/sqlparse/sqlparse_test.go
diff options
context:
space:
mode:
Diffstat (limited to 'internal/sqlparse/sqlparse_test.go')
-rw-r--r--internal/sqlparse/sqlparse_test.go105
1 files changed, 4 insertions, 101 deletions
diff --git a/internal/sqlparse/sqlparse_test.go b/internal/sqlparse/sqlparse_test.go
index 20ba72f..5cbbc07 100644
--- a/internal/sqlparse/sqlparse_test.go
+++ b/internal/sqlparse/sqlparse_test.go
@@ -182,12 +182,12 @@ func TestSqlParser_Parse(t *testing.T) {
for _, tc := range testCases {
sqlParser := sqlparse.NewSqlParser()
- migration, err := sqlParser.Parse(
+ upgradeScript, downgradeScript, 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)
+ check.DeepEqual(t, upgradeScript, tc.expectedUpgradeScript)
+ check.DeepEqual(t, downgradeScript, tc.expectedDowngradeScript)
}
}
@@ -215,104 +215,7 @@ func TestSqlParserParseError(t *testing.T) {
ErrCond: " ",
}
sqlParser := sqlparse.NewSqlParser()
- _, err := sqlParser.Parse(reader)
+ _, _, 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)
- })
- }
-}