aboutsummaryrefslogtreecommitdiffstats
path: root/internal/storage/db_test.go
diff options
context:
space:
mode:
authorEugene Triguba <eugenetriguba@gmail.com>2024-03-09 15:50:21 -0500
committerEugene Triguba <eugenetriguba@gmail.com>2024-03-09 15:50:21 -0500
commit9d2abbe510d1719bcfe31db901423376f79b7894 (patch)
tree00f5a057571a3ca779e5bbe96655169c58a692f9 /internal/storage/db_test.go
parentuse docker compose to start database in workflow (diff)
downloadcli-9d2abbe510d1719bcfe31db901423376f79b7894.zip
Add MySQL support
Diffstat (limited to 'internal/storage/db_test.go')
-rw-r--r--internal/storage/db_test.go49
1 files changed, 16 insertions, 33 deletions
diff --git a/internal/storage/db_test.go b/internal/storage/db_test.go
index 9f87d4c..8162898 100644
--- a/internal/storage/db_test.go
+++ b/internal/storage/db_test.go
@@ -1,55 +1,38 @@
package storage_test
import (
- "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 TestDBConnect_Success(t *testing.T) {
- cfg := bolttest.NewTestConnectionConfig(t, "postgres")
- connParams := storage.DBConnectionString(cfg)
-
- conn, err := storage.DBConnect(cfg.Driver, connParams)
+ cfg := bolttest.NewTestConnectionConfig()
+ conn, err := storage.DBConnect(cfg)
assert.Nil(t, err)
- defer conn.Close()
+ defer conn.Session.Close()
- _, err = conn.Exec("SELECT 1;")
+ _, err = conn.Session.SQL().Exec("SELECT 1;")
assert.Nil(t, err)
}
-func TestDBConnect_BadConnectionString(t *testing.T) {
- _, err := storage.DBConnect("postgres", "pizza=123")
- assert.ErrorIs(t, err, storage.ErrUnableToConnect)
- assert.ErrorContains(t, err, "unable to open connection to database")
-}
-
func TestDBConnect_UnsupportedDriver(t *testing.T) {
- cfg := bolttest.NewTestConnectionConfig(t, "redis")
+ t.Setenv("BOLT_DB_CONN_DRIVER", "abc123")
+ cfg := bolttest.NewTestConnectionConfig()
- _, err := storage.DBConnect(cfg.Driver, storage.DBConnectionString(cfg))
+ _, err := storage.DBConnect(cfg)
assert.ErrorIs(t, err, storage.ErrUnsupportedDriver)
}
-func TestDBConnectionString(t *testing.T) {
- cfg := configloader.ConnectionConfig{
- Driver: "postgres",
- Host: "db1",
- Port: 5432,
- User: "testuser",
- Password: "supersecretpassword",
- DBName: "testdb",
- }
-
- cs := storage.DBConnectionString(&cfg)
-
- expectedConnectionString := fmt.Sprintf(
- "host=%s port=%d user=%s password=%s dbname=%s sslmode=disable",
- cfg.Host, cfg.Port, cfg.User, cfg.Password, cfg.DBName,
- )
- assert.Equal(t, cs, expectedConnectionString)
+func TestDBConnect_BadConnectionString(t *testing.T) {
+ t.Setenv("BOLT_DB_CONN_DRIVER", "mysql")
+ t.Setenv("BOLT_DB_CONN_HOST", "abc123")
+ cfg := bolttest.NewTestConnectionConfig()
+
+ _, err := storage.DBConnect(cfg)
+
+ assert.ErrorIs(t, err, storage.ErrUnableToConnect)
+ assert.ErrorContains(t, err, "unable to open connection to database")
}