aboutsummaryrefslogtreecommitdiffstats
path: root/internal/bolttest/db.go
blob: bde519baf6b61a20167ff1d8ed44f540e8878b56 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
package bolttest

import (
	"database/sql"
	"os"
	"strconv"
	"testing"

	"github.com/eugenetriguba/bolt/internal/configloader"
	"github.com/eugenetriguba/bolt/internal/storage"
	"github.com/eugenetriguba/checkmate/assert"
)

func NewTestConnectionConfig(t *testing.T, driver string) *configloader.ConnectionConfig {
	port, err := strconv.Atoi(os.Getenv("DB_PORT"))
	assert.Nil(t, err)

	return &configloader.ConnectionConfig{
		Driver:   driver,
		DBName:   os.Getenv("DB_NAME"),
		Host:     os.Getenv("DB_HOST"),
		Port:     port,
		User:     os.Getenv("DB_USERNAME"),
		Password: os.Getenv("DB_PASSWORD"),
	}
}

func NewTestDB(t *testing.T, driver string) *sql.DB {
	connectionConfig := NewTestConnectionConfig(t, driver)
	connInfo := storage.DBConnectionString(connectionConfig)
	db, err := storage.DBConnect(driver, connInfo)
	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
}