aboutsummaryrefslogtreecommitdiffstats
path: root/internal/storage/mysql.go
diff options
context:
space:
mode:
authorEugene Triguba <eugenetriguba@gmail.com>2024-03-10 15:54:35 -0400
committerEugene Triguba <eugenetriguba@gmail.com>2024-03-10 15:54:35 -0400
commit57689dfd7dfe2e3c6efea53b67ad57820683b3b9 (patch)
tree3e008fc4c0a0baa5d1c44ced357110be223de82a /internal/storage/mysql.go
parentUpdate readme (diff)
downloadcli-57689dfd7dfe2e3c6efea53b67ad57820683b3b9.zip
Add adapters and remove upperdb
Diffstat (limited to 'internal/storage/mysql.go')
-rw-r--r--internal/storage/mysql.go77
1 files changed, 77 insertions, 0 deletions
diff --git a/internal/storage/mysql.go b/internal/storage/mysql.go
new file mode 100644
index 0000000..19514fb
--- /dev/null
+++ b/internal/storage/mysql.go
@@ -0,0 +1,77 @@
+package storage
+
+import (
+ "fmt"
+
+ "github.com/eugenetriguba/bolt/internal/configloader"
+ "github.com/go-sql-driver/mysql"
+)
+
+type MySQLAdapter struct{}
+
+func (m MySQLAdapter) ConvertGenericPlaceholders(query string, argsCount int) string {
+ // MySQL uses ? as its query argument placeholder, which we're using
+ // as our generic placeholder so no transformation is necessary.
+ return query
+}
+
+func (m MySQLAdapter) TableExists(
+ executor sqlExecutor,
+ tableName string,
+) (bool, error) {
+ // Note: MySQL doesn't have schemas. So the "table_schema"
+ // should be the currently selected database.
+ databaseName, err := m.DatabaseName(executor)
+ if err != nil {
+ return false, fmt.Errorf("unable to retrieve database name: %w", err)
+ }
+
+ var exists bool
+ err = executor.QueryRow(`
+ SELECT EXISTS (
+ SELECT 1
+ FROM INFORMATION_SCHEMA.TABLES
+ WHERE TABLE_SCHEMA = ?
+ AND TABLE_NAME = ?
+ );
+ `, databaseName, tableName).Scan(&exists)
+ if err != nil {
+ return false, fmt.Errorf(
+ "unable to check if %s exists: %w",
+ tableName,
+ err,
+ )
+ }
+
+ return exists, nil
+}
+
+func (m MySQLAdapter) DatabaseName(executor sqlExecutor) (string, error) {
+ var name string
+ err := executor.QueryRow("SELECT DATABASE();").Scan(&name)
+ if err != nil {
+ return "", fmt.Errorf("unable to retrieve database name: %w", err)
+ }
+
+ // MySQL allows connecting without a database selected.
+ if name == "" {
+ return "", fmt.Errorf("no database is currently selected")
+ }
+
+ return name, nil
+}
+
+func (m MySQLAdapter) CreateDSN(cfg configloader.ConnectionConfig) string {
+ addr := cfg.Host
+ if cfg.Port != "" {
+ addr += fmt.Sprintf(":%s", cfg.Port)
+ }
+ dsnCfg := mysql.Config{
+ Net: "tcp",
+ Addr: addr,
+ User: cfg.User,
+ Passwd: cfg.Password,
+ DBName: cfg.DBName,
+ }
+ return dsnCfg.FormatDSN()
+}