aboutsummaryrefslogtreecommitdiffstats
path: root/internal/storage/postgresql_test.go
diff options
context:
space:
mode:
authorEugene Triguba <eugenetriguba@gmail.com>2024-03-10 20:03:50 -0400
committerEugene Triguba <eugenetriguba@gmail.com>2024-03-10 20:03:50 -0400
commitf0ee4ba310f7034f549570a0833ac7ba41e9ab7f (patch)
tree8791281d7c144209d2d3dd1b99e785f294dcdeab /internal/storage/postgresql_test.go
parentUse pgx v5 and update changelog (diff)
downloadcli-f0ee4ba310f7034f549570a0833ac7ba41e9ab7f.zip
Add adapter tests
Diffstat (limited to 'internal/storage/postgresql_test.go')
-rw-r--r--internal/storage/postgresql_test.go103
1 files changed, 103 insertions, 0 deletions
diff --git a/internal/storage/postgresql_test.go b/internal/storage/postgresql_test.go
new file mode 100644
index 0000000..8218cc1
--- /dev/null
+++ b/internal/storage/postgresql_test.go
@@ -0,0 +1,103 @@
+//go:build postgresql
+
+package storage_test
+
+import (
+ "database/sql"
+ "fmt"
+ "testing"
+
+ "github.com/eugenetriguba/bolt/internal/bolttest"
+ "github.com/eugenetriguba/bolt/internal/configloader"
+ "github.com/eugenetriguba/bolt/internal/storage"
+ "github.com/eugenetriguba/checkmate/assert"
+)
+
+func TestConvertGenericPlaceholders(t *testing.T) {
+ type test struct {
+ query string
+ argCount int
+ expectedQuery string
+ }
+
+ testCases := []test{
+ {
+ query: "SELECT id, name FROM some_table;",
+ argCount: 0,
+ expectedQuery: "SELECT id, name FROM some_table;",
+ },
+ {
+ query: "SELECT id, name FROM some_table WHERE id = ?;",
+ argCount: 1,
+ expectedQuery: "SELECT id, name FROM some_table WHERE id = $1;",
+ },
+ {
+ query: "SELECT id, name FROM some_table WHERE id = ? AND name = ?;",
+ argCount: 2,
+ expectedQuery: "SELECT id, name FROM some_table WHERE id = $1 AND name = $2;",
+ },
+ }
+ for _, tc := range testCases {
+ adapter := storage.PostgresqlAdapter{}
+ newQuery := adapter.ConvertGenericPlaceholders(tc.query, tc.argCount)
+ assert.Equal(t, newQuery, tc.expectedQuery)
+ }
+}
+
+func TestTableExists(t *testing.T) {
+ cfg := bolttest.NewTestConnectionConfig()
+ adapter := storage.PostgresqlAdapter{}
+ db, err := sql.Open("pgx", adapter.CreateDSN(cfg))
+ assert.Nil(t, err)
+ t.Cleanup(func() {
+ _, err = db.Exec("DROP TABLE IF EXISTS tmp;")
+ assert.Nil(t, err)
+ assert.Nil(t, db.Close())
+ })
+
+ exists, err := adapter.TableExists(db, "tmp")
+ assert.Nil(t, err)
+ assert.False(t, exists)
+
+ _, err = db.Exec("CREATE TABLE tmp(id INT PRIMARY KEY);")
+ assert.Nil(t, err)
+
+ exists, err = adapter.TableExists(db, "tmp")
+ assert.Nil(t, err)
+ assert.True(t, exists)
+}
+
+func TestDatabaseName(t *testing.T) {
+ cfg := bolttest.NewTestConnectionConfig()
+ adapter := storage.PostgresqlAdapter{}
+ db, err := sql.Open("pgx", adapter.CreateDSN(cfg))
+ assert.Nil(t, err)
+ t.Cleanup(func() {
+ assert.Nil(t, db.Close())
+ })
+
+ name, err := adapter.DatabaseName(db)
+ assert.Nil(t, err)
+
+ assert.Equal(t, name, cfg.DBName)
+}
+
+func TestCreateDSN(t *testing.T) {
+ cfg := configloader.ConnectionConfig{
+ Driver: "postgres",
+ Host: "db1",
+ Port: "5432",
+ User: "testuser",
+ Password: "supersecretpassword",
+ DBName: "testdb",
+ }
+ adapter := storage.PostgresqlAdapter{}
+
+ cs := adapter.CreateDSN(cfg)
+
+ expectedConnectionString := fmt.Sprintf(
+ "host=%s port=%s user=%s password=%s dbname=%s sslmode=disable",
+ cfg.Host, cfg.Port, cfg.User, cfg.Password, cfg.DBName,
+ )
+ assert.Equal(t, cs, expectedConnectionString)
+}