aboutsummaryrefslogtreecommitdiffstats
path: root/internal/bolttest
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/bolttest
parentuse docker compose to start database in workflow (diff)
downloadcli-9d2abbe510d1719bcfe31db901423376f79b7894.zip
Add MySQL support
Diffstat (limited to 'internal/bolttest')
-rw-r--r--internal/bolttest/db.go42
1 files changed, 15 insertions, 27 deletions
diff --git a/internal/bolttest/db.go b/internal/bolttest/db.go
index 6ebbabf..a4e1115 100644
--- a/internal/bolttest/db.go
+++ b/internal/bolttest/db.go
@@ -1,9 +1,8 @@
package bolttest
import (
- "database/sql"
+ "fmt"
"os"
- "strconv"
"testing"
"github.com/eugenetriguba/bolt/internal/configloader"
@@ -11,39 +10,28 @@ import (
"github.com/eugenetriguba/checkmate/assert"
)
-func NewTestConnectionConfig(t *testing.T, driver string) *configloader.ConnectionConfig {
- port, err := strconv.Atoi(os.Getenv("BOLT_DB_CONN_PORT"))
+func NewTestDB(t *testing.T) storage.DB {
+ connectionConfig := NewTestConnectionConfig()
+ testdb, err := storage.DBConnect(connectionConfig)
assert.Nil(t, err)
+ t.Cleanup(func() {
+ DropTable(t, testdb, "bolt_migrations")
+ assert.Nil(t, testdb.Session.Close())
+ })
+ return testdb
+}
- return &configloader.ConnectionConfig{
- Driver: driver,
+func NewTestConnectionConfig() configloader.ConnectionConfig {
+ return configloader.ConnectionConfig{
+ Driver: os.Getenv("BOLT_DB_CONN_DRIVER"),
DBName: os.Getenv("BOLT_DB_CONN_DBNAME"),
Host: os.Getenv("BOLT_DB_CONN_HOST"),
- Port: port,
User: os.Getenv("BOLT_DB_CONN_USER"),
Password: os.Getenv("BOLT_DB_CONN_PASSWORD"),
}
}
-func NewTestDB(t *testing.T, driver string) *sql.DB {
- connectionConfig := NewTestConnectionConfig(t, driver)
- connInfo := storage.DBConnectionString(connectionConfig)
- db, err := storage.DBConnect(driver, connInfo)
+func DropTable(t *testing.T, testdb storage.DB, tableName string) {
+ _, err := testdb.Session.SQL().Exec(fmt.Sprintf(`DROP TABLE IF EXISTS %s;`, tableName))
assert.Nil(t, err)
- t.Cleanup(func() {
- _, err = db.Exec(`
- DO $$ DECLARE rec RECORD;
- BEGIN FOR rec IN (
- SELECT table_name
- FROM information_schema.tables
- WHERE table_schema = 'public'
- ) LOOP EXECUTE 'DROP TABLE IF EXISTS ' || rec.table_name || ' CASCADE';
- END LOOP;
- END $$;
- `)
- assert.Nil(t, err)
- err = db.Close()
- assert.Nil(t, err)
- })
- return db
}