aboutsummaryrefslogtreecommitdiffstats
path: root/internal/storage/mssql.go
diff options
context:
space:
mode:
authorEugene Triguba <eugenetriguba@gmail.com>2024-03-11 18:56:21 -0400
committerEugene Triguba <eugenetriguba@gmail.com>2024-03-11 18:56:21 -0400
commit58cc6cdbe0a0553a8e4319de12132e82d8bb85df (patch)
treea17b8cdbaf74797dc4f52e006635e4f5c9a210c2 /internal/storage/mssql.go
parentTweak tests (diff)
downloadcli-58cc6cdbe0a0553a8e4319de12132e82d8bb85df.zip
Add support for sql server
Diffstat (limited to 'internal/storage/mssql.go')
-rw-r--r--internal/storage/mssql.go78
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()
+}