From 58cc6cdbe0a0553a8e4319de12132e82d8bb85df Mon Sep 17 00:00:00 2001 From: Eugene Triguba Date: Mon, 11 Mar 2024 18:56:21 -0400 Subject: Add support for sql server --- internal/storage/mssql.go | 78 +++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 78 insertions(+) create mode 100644 internal/storage/mssql.go (limited to 'internal/storage/mssql.go') diff --git a/internal/storage/mssql.go b/internal/storage/mssql.go new file mode 100644 index 0000000..a7fbead --- /dev/null +++ b/internal/storage/mssql.go @@ -0,0 +1,78 @@ +package storage + +import ( + "fmt" + "strconv" + "strings" + + "github.com/eugenetriguba/bolt/internal/configloader" + "github.com/microsoft/go-mssqldb/msdsn" +) + +type MSSQLAdapter struct{} + +func (m MSSQLAdapter) ConvertGenericPlaceholders( + query string, + argsCount int, +) string { + for i := 0; i <= argsCount; i++ { + placeholder := m.createPlaceholder(i + 1) + query = strings.Replace(query, "?", placeholder, 1) + } + return query +} + +func (m MSSQLAdapter) createPlaceholder(index int) string { + return fmt.Sprintf("@p%d", index) +} + +func (m MSSQLAdapter) TableExists( + executor sqlExecutor, + tableName string, +) (bool, error) { + var exists bool + err := executor.QueryRow(` + SELECT CASE WHEN EXISTS ( + SELECT * + FROM INFORMATION_SCHEMA.TABLES + WHERE TABLE_SCHEMA = 'dbo' + AND TABLE_NAME = @p1 + ) THEN 1 ELSE 0 END + `, tableName).Scan(&exists) + if err != nil { + return false, fmt.Errorf( + "unable to check if dbo.%s exists: %w", + tableName, + err, + ) + } + + return exists, nil +} + +func (m MSSQLAdapter) DatabaseName(executor sqlExecutor) (string, error) { + var name string + err := executor.QueryRow("SELECT DB_NAME();").Scan(&name) + if err != nil { + return "", fmt.Errorf("unable to retrieve database name: %w", err) + } + + return name, nil +} + +func (m MSSQLAdapter) CreateDSN(cfg configloader.ConnectionConfig) string { + port, err := strconv.ParseUint(cfg.Port, 10, 64) + if err != nil { + // Use default port if we can't parse it out. + // The mssql driver requires an int port to be passed. + port = 1433 + } + dsnCfg := msdsn.Config{ + Host: cfg.Host, + Port: port, + User: cfg.User, + Password: cfg.Password, + Database: cfg.DBName, + } + return dsnCfg.URL().String() +} -- cgit v1.2.3