//go:build mssql package storage_test import ( "database/sql" "testing" "git.eugenetriguba.com/bolt/cli/internal/bolttest" "git.eugenetriguba.com/bolt/cli/internal/storage" "git.eugenetriguba.com/checkmate/assert" ) func TestMSSQL_ConvertGenericPlaceholders(t *testing.T) { type test struct { query string argCount int expectedQuery string } testCases := []test{ { query: "SELECT id, name FROM some_table;", argCount: 0, expectedQuery: "SELECT id, name FROM some_table;", }, { query: "SELECT id, name FROM some_table WHERE id = ?;", argCount: 1, expectedQuery: "SELECT id, name FROM some_table WHERE id = @p1;", }, { query: "SELECT id, name FROM some_table WHERE id = ? AND name = ?;", argCount: 2, expectedQuery: "SELECT id, name FROM some_table WHERE id = @p1 AND name = @p2;", }, } for _, tc := range testCases { adapter := storage.MSSQLAdapter{} newQuery := adapter.ConvertGenericPlaceholders(tc.query, tc.argCount) assert.Equal(t, newQuery, tc.expectedQuery) } } func TestMSSQL_TableExistsDefaultSchema(t *testing.T) { cfg := bolttest.NewTestConnectionConfig() adapter := storage.MSSQLAdapter{} db, err := sql.Open("sqlserver", cfg.DSN) assert.Nil(t, err) t.Cleanup(func() { _, err = db.Exec("DROP TABLE IF EXISTS tmp;") assert.Nil(t, err) assert.Nil(t, db.Close()) }) exists, err := adapter.TableExists(db, "tmp") assert.Nil(t, err) assert.False(t, exists) _, err = db.Exec("CREATE TABLE tmp(id INT PRIMARY KEY);") assert.Nil(t, err) exists, err = adapter.TableExists(db, "tmp") assert.Nil(t, err) assert.True(t, exists) } func TestMSSQL_TableExistsCustomSchema(t *testing.T) { cfg := bolttest.NewTestConnectionConfig() adapter := storage.MSSQLAdapter{} db, err := sql.Open("sqlserver", cfg.DSN) assert.Nil(t, err) t.Cleanup(func() { _, err = db.Exec("IF OBJECT_ID('custom_schema.tmp', 'U') IS NOT NULL DROP TABLE custom_schema.tmp;") assert.Nil(t, err) _, err = db.Exec("IF SCHEMA_ID('custom_schema') IS NOT NULL DROP SCHEMA custom_schema;") assert.Nil(t, err) assert.Nil(t, db.Close()) }) _, err = db.Exec("IF SCHEMA_ID('custom_schema') IS NOT NULL DROP SCHEMA custom_schema;") assert.Nil(t, err) 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{} db, err := sql.Open("sqlserver", cfg.DSN) assert.Nil(t, err) t.Cleanup(func() { assert.Nil(t, db.Close()) }) name, err := adapter.DatabaseName(db) assert.Nil(t, err) // The database name should be extracted from the DSN // For now, we'll just check that we get a non-empty name assert.NotEqual(t, name, "") }