aboutsummaryrefslogtreecommitdiffstats
path: root/internal/bolttest
diff options
context:
space:
mode:
authorEugene Triguba <eugenetriguba@gmail.com>2024-01-10 22:01:56 -0500
committerEugene Triguba <eugenetriguba@gmail.com>2024-01-10 22:01:56 -0500
commit0a0b911a15202214ee0421a6d71ed6a84f1461c9 (patch)
tree4e7d7e534ecd3ddff13bfee5c702dc6c1703d7db /internal/bolttest
parentFix fs repo create and tweak tests (diff)
downloadcli-0a0b911a15202214ee0421a6d71ed6a84f1461c9.zip
Tweak tests
Diffstat (limited to 'internal/bolttest')
-rw-r--r--internal/bolttest/db.go35
1 files changed, 30 insertions, 5 deletions
diff --git a/internal/bolttest/db.go b/internal/bolttest/db.go
index 191605b..de2dcfa 100644
--- a/internal/bolttest/db.go
+++ b/internal/bolttest/db.go
@@ -1,17 +1,19 @@
package bolttest
import (
+ "database/sql"
"os"
"strconv"
+ "testing"
"github.com/eugenetriguba/bolt/internal/configloader"
+ "github.com/eugenetriguba/bolt/internal/storage"
+ "gotest.tools/v3/assert"
)
-func NewTestConnectionConfig(driver string) (*configloader.ConnectionConfig, error) {
+func NewTestConnectionConfig(t *testing.T, driver string) *configloader.ConnectionConfig {
port, err := strconv.Atoi(os.Getenv("DB_PORT"))
- if err != nil {
- return nil, err
- }
+ assert.NilError(t, err)
return &configloader.ConnectionConfig{
Driver: driver,
@@ -20,5 +22,28 @@ func NewTestConnectionConfig(driver string) (*configloader.ConnectionConfig, err
Port: port,
User: os.Getenv("DB_USERNAME"),
Password: os.Getenv("DB_PASSWORD"),
- }, nil
+ }
+}
+
+func NewTestDB(t *testing.T, driver string) *sql.DB {
+ connectionConfig := NewTestConnectionConfig(t, driver)
+ connInfo := storage.DBConnectionString(connectionConfig)
+ db, err := storage.DBConnect(driver, connInfo)
+ assert.NilError(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.NilError(t, err)
+ err = db.Close()
+ assert.NilError(t, err)
+ })
+ return db
}