diff options
| author | Eugene Triguba <eugenetriguba@gmail.com> | 2024-03-11 18:56:21 -0400 |
|---|---|---|
| committer | Eugene Triguba <eugenetriguba@gmail.com> | 2024-03-11 18:56:21 -0400 |
| commit | 58cc6cdbe0a0553a8e4319de12132e82d8bb85df (patch) | |
| tree | a17b8cdbaf74797dc4f52e006635e4f5c9a210c2 /internal/storage/mssql.go | |
| parent | Tweak tests (diff) | |
| download | cli-58cc6cdbe0a0553a8e4319de12132e82d8bb85df.zip | |
Add support for sql server
Diffstat (limited to 'internal/storage/mssql.go')
| -rw-r--r-- | internal/storage/mssql.go | 78 |
1 files changed, 78 insertions, 0 deletions
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() +} |