diff options
| author | Eugene Triguba <eugenetriguba@gmail.com> | 2024-01-10 22:01:56 -0500 |
|---|---|---|
| committer | Eugene Triguba <eugenetriguba@gmail.com> | 2024-01-10 22:01:56 -0500 |
| commit | 0a0b911a15202214ee0421a6d71ed6a84f1461c9 (patch) | |
| tree | 4e7d7e534ecd3ddff13bfee5c702dc6c1703d7db /internal/bolttest | |
| parent | Fix fs repo create and tweak tests (diff) | |
| download | cli-0a0b911a15202214ee0421a6d71ed6a84f1461c9.zip | |
Tweak tests
Diffstat (limited to 'internal/bolttest')
| -rw-r--r-- | internal/bolttest/db.go | 35 |
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 } |