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/db_test.go | |
| parent | Use pgx v5 and update changelog (diff) | |
| download | cli-f0ee4ba310f7034f549570a0833ac7ba41e9ab7f.zip | |
Add adapter tests
Diffstat (limited to 'internal/storage/db_test.go')
| -rw-r--r-- | internal/storage/db_test.go | 133 |
1 files changed, 127 insertions, 6 deletions
diff --git a/internal/storage/db_test.go b/internal/storage/db_test.go index 0eacd23..6dc1e14 100644 --- a/internal/storage/db_test.go +++ b/internal/storage/db_test.go @@ -1,6 +1,8 @@ package storage_test import ( + "database/sql" + "errors" "testing" "github.com/eugenetriguba/bolt/internal/bolttest" @@ -9,21 +11,140 @@ import ( ) func TestNewDB_Success(t *testing.T) { + db, err := storage.NewDB(bolttest.NewTestConnectionConfig()) + assert.Nil(t, err) + t.Cleanup(func() { + assert.Nil(t, db.Close()) + }) + _, err = db.Exec("SELECT 1;") + assert.Nil(t, err) +} + +func TestNewDB_UnsupportedDriver(t *testing.T) { + t.Setenv("BOLT_DB_CONN_DRIVER", "abc123") + _, err := storage.NewDB(bolttest.NewTestConnectionConfig()) + assert.ErrorIs(t, err, storage.ErrUnsupportedDriver) +} + +func TestNewDB_UnableToConnect(t *testing.T) { + t.Setenv("BOLT_DB_CONN_HOST", "") + t.Setenv("BOLT_DB_CONN_PORT", "") + _, err := storage.NewDB(bolttest.NewTestConnectionConfig()) + assert.ErrorIs(t, err, storage.ErrUnableToConnect) +} + +func TestClose_IsClosed(t *testing.T) { + db, err := storage.NewDB(bolttest.NewTestConnectionConfig()) + assert.Nil(t, err) + + err = db.Close() + assert.Nil(t, err) + + _, err = db.Exec("SELECT 1;") + assert.ErrorContains(t, err, "sql: database is closed") +} + +func TestTableExists_DoesExist(t *testing.T) { + db, err := storage.NewDB(bolttest.NewTestConnectionConfig()) + assert.Nil(t, err) + t.Cleanup(func() { + bolttest.DropTable(t, db, "tmp") + assert.Nil(t, db.Close()) + }) + _, err = db.Exec("CREATE TABLE tmp(id int primary key);") + assert.Nil(t, err) + + exists, err := db.TableExists("tmp") + + assert.Nil(t, err) + assert.True(t, exists) +} + +func TestTableExists_DoesNotExist(t *testing.T) { cfg := bolttest.NewTestConnectionConfig() + db, err := storage.NewDB(cfg) + assert.Nil(t, err) + t.Cleanup(func() { + assert.Nil(t, db.Close()) + }) + exists, err := db.TableExists("tmp") + + assert.Nil(t, err) + assert.False(t, exists) +} + +func TestQueryPlaceholders(t *testing.T) { + cfg := bolttest.NewTestConnectionConfig() db, err := storage.NewDB(cfg) + assert.Nil(t, err) + t.Cleanup(func() { + bolttest.DropTable(t, db, "tmp") + assert.Nil(t, db.Close()) + }) + _, err = db.Exec(`CREATE TABLE tmp(id int primary key);`) + assert.Nil(t, err) + _, err = db.Exec(`INSERT INTO tmp(id) VALUES(1);`) + assert.Nil(t, err) + _, err = db.Exec(`INSERT INTO tmp(id) VALUES(2);`) + assert.Nil(t, err) + var queryRowId int + err = db.QueryRow("SELECT id FROM tmp WHERE id = ?", 1).Scan(&queryRowId) assert.Nil(t, err) - defer db.Close() - _, err = db.Exec("SELECT 1;") + assert.Equal(t, queryRowId, 1) + + rows, err := db.Query("SELECT id FROM tmp WHERE id = ?", 1) assert.Nil(t, err) + assert.True(t, rows.Next()) + var queryId int + err = rows.Scan(&queryId) + assert.Nil(t, err) + assert.Equal(t, queryId, 1) + assert.False(t, rows.Next()) } -func TestNewDB_UnsupportedDriver(t *testing.T) { - t.Setenv("BOLT_DB_CONN_DRIVER", "abc123") +func TestTx_Commit(t *testing.T) { cfg := bolttest.NewTestConnectionConfig() + db, err := storage.NewDB(cfg) + assert.Nil(t, err) + t.Cleanup(func() { + bolttest.DropTable(t, db, "tmp") + assert.Nil(t, db.Close()) + }) - _, err := storage.NewDB(cfg) + err = db.Tx(func(db storage.DB) error { + _, err = db.Exec(`CREATE TABLE tmp(id int primary key);`) + assert.Nil(t, err) + return nil + }) + assert.Nil(t, err) - assert.ErrorIs(t, err, storage.ErrUnsupportedDriver) + exists, err := db.TableExists("tmp") + assert.Nil(t, err) + assert.True(t, exists) +} + +func TestTx_Rollback(t *testing.T) { + cfg := bolttest.NewTestConnectionConfig() + db, err := storage.NewDB(cfg) + assert.Nil(t, err) + t.Cleanup(func() { + bolttest.DropTable(t, db, "tmp") + assert.Nil(t, db.Close()) + }) + _, err = db.Exec(`CREATE TABLE tmp(id INT PRIMARY KEY);`) + assert.Nil(t, err) + expectedErr := errors.New("error!") + + err = db.Tx(func(db storage.DB) error { + _, err = db.Exec(`INSERT INTO tmp(id) VALUES(1)`) + assert.Nil(t, err) + return expectedErr + }) + assert.ErrorIs(t, err, expectedErr) + + var id int + err = db.QueryRow("SELECT id FROM tmp WHERE id = 1;").Scan(&id) + assert.ErrorIs(t, err, sql.ErrNoRows) } |