aboutsummaryrefslogtreecommitdiffstats
path: root/internal/bolttest/db.go
blob: 6159cacc3e4e575e5ae8964f352974ec8300c385 (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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
package bolttest

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

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

func NewTestDB(t *testing.T) storage.DB {
	connectionConfig := NewTestConnectionConfig()
	db, err := storage.NewDB(connectionConfig)
	assert.Nil(t, err)

	DropTable(t, db, connectionConfig.MigrationsTable)
	DropTable(t, db, "tmp")
	t.Cleanup(func() {
		DropTable(t, db, connectionConfig.MigrationsTable)
		DropTable(t, db, "tmp")
		assert.Nil(t, db.Close())
	})

	return db
}

func NewTestConnectionConfig() configloader.ConnectionConfig {
	return configloader.ConnectionConfig{
		DSN:             os.Getenv("BOLT_DB_DSN"),
		Driver:          os.Getenv("BOLT_DB_DRIVER"),
		MigrationsTable: os.Getenv("BOLT_DB_MIGRATIONS_TABLE"),
	}
}

func DropTable(t *testing.T, db storage.DB, tableName string) {
	_, err := db.Exec(fmt.Sprintf("DROP TABLE IF EXISTS %s;", tableName))
	assert.Nil(t, err)
}

type MockDB struct {
	ExecFunc        func(query string, args ...interface{}) (sql.Result, error)
	QueryFunc       func(query string, args ...interface{}) (*sql.Rows, error)
	QueryRowFunc    func(query string, args ...interface{}) *sql.Row
	TxFunc          func(fn storage.TxFunc) error
	CloseFunc       func() error
	TableExistsFunc func(tableName string) (bool, error)
}

func (m *MockDB) Exec(query string, args ...interface{}) (sql.Result, error) {
	return m.ExecFunc(query, args...)
}

func (m *MockDB) Query(query string, args ...interface{}) (*sql.Rows, error) {
	return m.QueryFunc(query, args...)
}

func (m *MockDB) QueryRow(query string, args ...interface{}) *sql.Row {
	return m.QueryRowFunc(query, args...)
}

func (m *MockDB) Tx(fn storage.TxFunc) error {
	return m.TxFunc(fn)
}

func (m *MockDB) Close() error {
	return m.CloseFunc()
}

func (m *MockDB) TableExists(tableName string) (bool, error) {
	return m.TableExistsFunc(tableName)
}