Function TestComputeDiff_CreateTable

core/schema_diff_test.go:10–53

(t *testing.T)

)

func TestComputeDiff_CreateTable(t *testing.T) {
	current := &sdata.DBInfo{
		Type:   "postgres",
		Tables: []sdata.DBTable{},
	}

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

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

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

	// Should have a create_table operation
	found := false
	for _, op := range ops {
		if op.Type == "create_table" && op.Table == "users" {
			found = true
			if !strings.Contains(op.SQL, "CREATE TABLE") {
				t.Errorf("expected CREATE TABLE in SQL, got: %s", op.SQL)
			}
			if !strings.Contains(op.SQL, `"id"`) {
				t.Errorf("expected id column in SQL, got: %s", op.SQL)
			}
		}
	}

	if !found {
		t.Error("expected create_table operation for users table")
	}
}

func TestSupportsSchemaDDLBoundary(t *testing.T) {
	for _, dbType := range []string{"postgres", "mysql", "mariadb", "sqlite", "mssql", "oracle", "snowflake"} {