diff options
| author | Eugene Triguba <eugenetriguba@gmail.com> | 2024-08-18 17:46:39 -0400 |
|---|---|---|
| committer | Eugene Triguba <eugenetriguba@gmail.com> | 2024-08-18 17:46:39 -0400 |
| commit | 598d18b2c83dd4644d788669642ffec4efec155f (patch) | |
| tree | 327a0737141fd1f99ffa2e325383aa3495cc6356 /internal | |
| parent | Release v0.10.1 (diff) | |
| download | cli-598d18b2c83dd4644d788669642ffec4efec155f.zip | |
Add test around schema scenario with mssql
Diffstat (limited to 'internal')
| -rw-r--r-- | internal/storage/mssql_test.go | 30 |
1 files changed, 29 insertions, 1 deletions
diff --git a/internal/storage/mssql_test.go b/internal/storage/mssql_test.go index 2232860..48a1679 100644 --- a/internal/storage/mssql_test.go +++ b/internal/storage/mssql_test.go @@ -44,7 +44,7 @@ func TestMSSQL_ConvertGenericPlaceholders(t *testing.T) { } } -func TestMSSQL_TableExists(t *testing.T) { +func TestMSSQL_TableExistsDefaultSchema(t *testing.T) { cfg := bolttest.NewTestConnectionConfig() adapter := storage.MSSQLAdapter{} db, err := sql.Open("sqlserver", adapter.CreateDSN(cfg)) @@ -69,6 +69,34 @@ func TestMSSQL_TableExists(t *testing.T) { assert.True(t, exists) } +func TestMSSQL_TableExistsCustomSchema(t *testing.T) { + cfg := bolttest.NewTestConnectionConfig() + adapter := storage.MSSQLAdapter{} + db, err := sql.Open("sqlserver", adapter.CreateDSN(cfg)) + assert.Nil(t, err) + + t.Cleanup(func() { + _, err := db.Exec("DROP TABLE IF EXISTS custom_schema.tmp;") + assert.Nil(t, err) + _, err = db.Exec("DROP SCHEMA IF EXISTS custom_schema;") + assert.Nil(t, err) + assert.Nil(t, db.Close()) + }) + + exists, err := adapter.TableExists(db, "custom_schema.tmp") + assert.Nil(t, err) + assert.False(t, exists) + + _, err = db.Exec("CREATE SCHEMA custom_schema;") + assert.Nil(t, err) + + _, err = db.Exec("CREATE TABLE custom_schema.tmp(id INT PRIMARY KEY);") + assert.Nil(t, err) + + exists, err = adapter.TableExists(db, "custom_schema.tmp") + assert.Nil(t, err) + assert.True(t, exists) +} func TestMSSQL_DatabaseName(t *testing.T) { cfg := bolttest.NewTestConnectionConfig() adapter := storage.MSSQLAdapter{} |