Function TestGitOpsCheckVersionedDependency

backend/tests/gitops_test.go:1621–1800

TestGitOpsCheckVersionedDependency tests that CheckRelease SQL review handles dependencies between migration files correctly. Test case 1: Create table t1, then alter table t1 - should pass with no SQL review errors Test case 2: Create table t1, then alter table t2 - should have SQL review error (t2

(t *testing.T)

// Test case 1: Create table t1, then alter table t1 - should pass with no SQL review errors
// Test case 2: Create table t1, then alter table t2 - should have SQL review error (t2 doesn't exist)
func TestGitOpsCheckVersionedDependency(t *testing.T) {
	t.Parallel()

	testCases := []struct {
		name        string
		files       []*v1pb.Release_File
		expectError bool
	}{
		{
			name: "alter_same_table_should_pass",
			files: []*v1pb.Release_File{
				{
					Path:    "migrations/001__create_t1.sql",
					Version: "001",
					Statement: []byte(`CREATE TABLE t1 (
	id SERIAL PRIMARY KEY,
	name VARCHAR(255) NOT NULL
);`),
				},
				{
					Path:      "migrations/002__alter_t1.sql",
					Version:   "002",
					Statement: []byte(`ALTER TABLE t1 ADD COLUMN email VARCHAR(255);`),
				},
			},
			expectError: false,
		},
		{
			name: "alter_nonexistent_table_should_error",
			files: []*v1pb.Release_File{
				{
					Path:    "migrations/001__create_t1.sql",
					Version: "001",
					Statement: []byte(`CREATE TABLE t1 (
	id SERIAL PRIMARY KEY,
	name VARCHAR(255) NOT NULL
);`),
				},
				{
					Path:      "migrations/002__alter_t2.sql",
					Version:   "002",
					Statement: []byte(`ALTER TABLE t2 ADD COLUMN email VARCHAR(255);`),
				},
			},
			expectError: true,
		},
	}

	for _, tc := range testCases {
		tc := tc
		t.Run(tc.name, func(t *testing.T) {
			t.Parallel()
			a := require.New(t)
			ctx := context.Background()
			ctl := &controller{}
			ctx, err := ctl.StartServerWithExternalPg(ctx)
			a.NoError(err)
			defer ctl.Close(ctx)