Function TestBuildExportTableDDLCanonicalPrimaryKey

database/mssql/database_test.go:24–53

(t *testing.T)

}

func TestBuildExportTableDDLCanonicalPrimaryKey(t *testing.T) {
	db := &MssqlDatabase{}
	db.SetGeneratorConfig(database.GeneratorConfig{LegacyIgnoreQuotes: false})

	ddl := db.buildExportTableDDL(
		"dbo.SystemUser",
		[]column{
			{Name: "SystemUserId", dataType: "int", Nullable: false},
			{Name: "Date", dataType: "date", Nullable: false},
		},
		[]*indexDef{
			{
				name:       "PK_SystemUser",
				columns:    []string{"[SystemUserId]"},
				primary:    true,
				constraint: true,
				indexType:  "CLUSTERED",
			},
		},
		nil,
		nil,
	)

	if !strings.Contains(ddl, "CONSTRAINT [PK_SystemUser] PRIMARY KEY CLUSTERED ([SystemUserId])") {
		t.Fatalf("expected canonical bracketed PK constraint and column in export, got:\n%s", ddl)
	}
	if !strings.Contains(ddl, "[Date] date NOT NULL") {
		t.Fatalf("expected reserved identifier to remain bracketed in export, got:\n%s", ddl)
	}
}