//go:build mssql package repositories_test import ( "testing" "git.eugenetriguba.com/bolt/cli/internal/bolttest" "git.eugenetriguba.com/bolt/cli/internal/repositories" "git.eugenetriguba.com/checkmate/assert" ) func TestNewMigrationDBRepo_CreatesTableInSchema_MSSQL(t *testing.T) { testdb := bolttest.NewTestDB(t) schemaName := "custom_schema" tableName := schemaName + ".bolt_migrations" t.Cleanup(func() { _, err := testdb.Exec("IF OBJECT_ID('" + tableName + "', 'U') IS NOT NULL DROP TABLE " + tableName) assert.Nil(t, err) _, err = testdb.Exec("IF SCHEMA_ID('" + schemaName + "') IS NOT NULL DROP SCHEMA " + schemaName) assert.Nil(t, err) }) _, err := testdb.Exec("IF SCHEMA_ID('" + schemaName + "') IS NOT NULL DROP SCHEMA " + schemaName) assert.Nil(t, err) _, err = testdb.Exec("CREATE SCHEMA " + schemaName) assert.Nil(t, err) exists, err := testdb.TableExists(tableName) assert.Nil(t, err) assert.False(t, exists) _, err = repositories.NewMigrationDBRepo(tableName, testdb) assert.Nil(t, err) exists, err = testdb.TableExists(tableName) assert.Nil(t, err) assert.True(t, exists) }