aboutsummaryrefslogtreecommitdiffstats
path: root/internal/storage/db_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/db_test.go
parentUse pgx v5 and update changelog (diff)
downloadcli-f0ee4ba310f7034f549570a0833ac7ba41e9ab7f.zip
Add adapter tests
Diffstat (limited to 'internal/storage/db_test.go')
-rw-r--r--internal/storage/db_test.go133
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)
}