diff options
Diffstat (limited to 'internal/repositories')
| -rw-r--r-- | internal/repositories/migration_db_repo_mssql_test.go | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/internal/repositories/migration_db_repo_mssql_test.go b/internal/repositories/migration_db_repo_mssql_test.go index bbcb4cf..d1d03f4 100644 --- a/internal/repositories/migration_db_repo_mssql_test.go +++ b/internal/repositories/migration_db_repo_mssql_test.go @@ -16,13 +16,16 @@ func TestNewMigrationDBRepo_CreatesTableInSchema_MSSQL(t *testing.T) { tableName := schemaName + ".bolt_migrations" t.Cleanup(func() { - _, err := testdb.Exec("DROP TABLE IF EXISTS " + tableName) + _, err := testdb.Exec("IF OBJECT_ID('" + tableName + "', 'U') IS NOT NULL DROP TABLE " + tableName) assert.Nil(t, err) - _, err = testdb.Exec("DROP SCHEMA IF EXISTS " + schemaName) + _, err = testdb.Exec("IF SCHEMA_ID('" + schemaName + "') IS NOT NULL DROP SCHEMA " + schemaName) assert.Nil(t, err) }) - _, err := testdb.Exec("CREATE SCHEMA " + schemaName) + _, 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) |