Function TestComputeDiff_AddColumn

core/schema_diff_test.go:228–273

(t *testing.T)

}

func TestComputeDiff_AddColumn(t *testing.T) {
	current := &sdata.DBInfo{
		Type: "postgres",
		Tables: []sdata.DBTable{
			{
				Name: "users",
				Columns: []sdata.DBColumn{
					{Name: "id", Type: "bigint", PrimaryKey: true},
				},
			},
		},
	}

	expected := &sdata.DBInfo{
		Type: "postgres",
		Tables: []sdata.DBTable{
			{
				Name: "users",
				Columns: []sdata.DBColumn{
					{Name: "id", Type: "bigint", PrimaryKey: true},
					{Name: "email", Type: "text", NotNull: true},
				},
			},
		},
	}

	ops := computeDiff(current, expected, DiffOptions{Destructive: false})

	if len(ops) == 0 {
		t.Fatal("expected at least one operation")
	}

	found := false
	for _, op := range ops {
		if op.Type == "add_column" && op.Column == "email" {
			found = true
			if !strings.Contains(op.SQL, "ADD COLUMN") {
				t.Errorf("expected ADD COLUMN in SQL, got: %s", op.SQL)
			}
		}
	}

	if !found {
		t.Error("expected add_column operation for email column")
	}
}

func TestComputeDiff_DropColumn_NotDestructive(t *testing.T) {
	current := &sdata.DBInfo{