aboutsummaryrefslogtreecommitdiffstats
path: root/internal/storage/postgresql.go
diff options
context:
space:
mode:
Diffstat (limited to 'internal/storage/postgresql.go')
-rw-r--r--internal/storage/postgresql.go71
1 files changed, 71 insertions, 0 deletions
diff --git a/internal/storage/postgresql.go b/internal/storage/postgresql.go
new file mode 100644
index 0000000..f728514
--- /dev/null
+++ b/internal/storage/postgresql.go
@@ -0,0 +1,71 @@
+package storage
+
+import (
+ "fmt"
+ "strings"
+
+ "github.com/eugenetriguba/bolt/internal/configloader"
+)
+
+type PostgresqlAdapter struct{}
+
+func (p PostgresqlAdapter) ConvertGenericPlaceholders(
+ query string,
+ argsCount int,
+) string {
+ for i := 0; i <= argsCount; i++ {
+ placeholder := p.createPlaceholder(i + 1)
+ query = strings.Replace(query, "?", placeholder, 1)
+ }
+ return query
+}
+
+func (p PostgresqlAdapter) createPlaceholder(index int) string {
+ return fmt.Sprintf("$%d", index)
+}
+
+func (p PostgresqlAdapter) TableExists(
+ executor sqlExecutor,
+ tableName string,
+) (bool, error) {
+ var exists bool
+ // Assumption: Anytime we check if a table exists, it will be
+ // for the 'public' schema. If someone wants to have bolt_migrations
+ // table outside of the 'public' schema on postgresql, this would be
+ // an issue.
+ err := executor.QueryRow(`
+ SELECT EXISTS (
+ SELECT FROM pg_catalog.pg_class c
+ JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
+ WHERE n.nspname = 'public'
+ AND c.relname = $1
+ AND c.relkind = 'r' -- Only tables
+ );
+ `, tableName).Scan(&exists)
+ if err != nil {
+ return false, fmt.Errorf(
+ "unable to check if %s exists: %w",
+ tableName,
+ err,
+ )
+ }
+
+ return exists, nil
+}
+
+func (p PostgresqlAdapter) DatabaseName(executor sqlExecutor) (string, error) {
+ var name string
+ err := executor.QueryRow("SELECT database_name();").Scan(&name)
+ if err != nil {
+ return "", fmt.Errorf("unable to retrieve database name: %w", err)
+ }
+
+ return name, nil
+}
+
+func (p PostgresqlAdapter) CreateDSN(cfg configloader.ConnectionConfig) string {
+ return fmt.Sprintf(
+ "host=%s port=%s user=%s password=%s dbname=%s sslmode=disable",
+ cfg.Host, cfg.Port, cfg.User, cfg.Password, cfg.DBName,
+ )
+}