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)
}
|