diff options
| author | Eugene Triguba <hello@eugenetriguba.com> | 2025-10-18 10:43:39 -0400 |
|---|---|---|
| committer | Eugene Triguba <hello@eugenetriguba.com> | 2025-11-26 11:46:57 -0500 |
| commit | e5658d1f61415054029b66cd2f703f1f40138460 (patch) | |
| tree | c609e209f4cebc62dd985d1b773558f47eb73bf6 /internal/sqlparse/sqlparse_test.go | |
| parent | Add is-branch main check for docs deployment (diff) | |
| download | cli-e5658d1f61415054029b66cd2f703f1f40138460.zip | |
Add support for migration dependencies
Diffstat (limited to '')
| -rw-r--r-- | internal/sqlparse/sqlparse_test.go | 105 |
1 files changed, 101 insertions, 4 deletions
diff --git a/internal/sqlparse/sqlparse_test.go b/internal/sqlparse/sqlparse_test.go index 5cbbc07..20ba72f 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() - upgradeScript, downgradeScript, err := sqlParser.Parse( + migration, err := sqlParser.Parse( strings.NewReader(tc.migration), ) assert.Nil(t, err) - check.DeepEqual(t, upgradeScript, tc.expectedUpgradeScript) - check.DeepEqual(t, downgradeScript, tc.expectedDowngradeScript) + check.DeepEqual(t, migration.UpgradeScript, tc.expectedUpgradeScript) + check.DeepEqual(t, migration.DowngradeScript, tc.expectedDowngradeScript) } } @@ -215,7 +215,104 @@ 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) + }) + } +} |