diff options
| author | Eugene Triguba <eugenetriguba@gmail.com> | 2024-03-10 20:03:50 -0400 |
|---|---|---|
| committer | Eugene Triguba <eugenetriguba@gmail.com> | 2024-03-10 20:03:50 -0400 |
| commit | f0ee4ba310f7034f549570a0833ac7ba41e9ab7f (patch) | |
| tree | 8791281d7c144209d2d3dd1b99e785f294dcdeab /internal/storage/postgresql_test.go | |
| parent | Use pgx v5 and update changelog (diff) | |
| download | cli-f0ee4ba310f7034f549570a0833ac7ba41e9ab7f.zip | |
Add adapter tests
Diffstat (limited to 'internal/storage/postgresql_test.go')
| -rw-r--r-- | internal/storage/postgresql_test.go | 103 |
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) +} |