From f0ee4ba310f7034f549570a0833ac7ba41e9ab7f Mon Sep 17 00:00:00 2001 From: Eugene Triguba Date: Sun, 10 Mar 2024 20:03:50 -0400 Subject: Add adapter tests --- internal/storage/postgresql_test.go | 103 ++++++++++++++++++++++++++++++++++++ 1 file changed, 103 insertions(+) create mode 100644 internal/storage/postgresql_test.go (limited to 'internal/storage/postgresql_test.go') 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) +} -- cgit v1.2.3