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
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
//go:build mysql
package storage_test
import (
"database/sql"
"fmt"
"testing"
"github.com/eugenetriguba/bolt/internal/bolttest"
"github.com/eugenetriguba/bolt/internal/configloader"
"github.com/eugenetriguba/bolt/internal/storage"
"github.com/eugenetriguba/checkmate/assert"
)
func TestMySQL_ConvertGenericPlaceholders(t *testing.T) {
type test struct {
query string
argCount int
expectedQuery string
}
testCases := []test{
{
query: "SELECT id, name FROM some_table;",
argCount: 0,
expectedQuery: "SELECT id, name FROM some_table;",
},
{
query: "SELECT id, name FROM some_table WHERE id = ?;",
argCount: 1,
expectedQuery: "SELECT id, name FROM some_table WHERE id = ?;",
},
{
query: "SELECT id, name FROM some_table WHERE id = ? AND name = ?;",
argCount: 2,
expectedQuery: "SELECT id, name FROM some_table WHERE id = ? AND name = ?;",
},
}
for _, tc := range testCases {
adapter := storage.MySQLAdapter{}
newQuery := adapter.ConvertGenericPlaceholders(tc.query, tc.argCount)
assert.Equal(t, newQuery, tc.expectedQuery)
}
}
func TestMySQL_TableExists(t *testing.T) {
cfg := bolttest.NewTestConnectionConfig()
adapter := storage.MySQLAdapter{}
db, err := sql.Open("mysql", adapter.CreateDSN(cfg))
assert.Nil(t, err)
t.Cleanup(func() {
_, err = db.Exec("DROP TABLE IF EXISTS tmp;")
assert.Nil(t, err)
assert.Nil(t, db.Close())
})
exists, err := adapter.TableExists(db, "tmp")
assert.Nil(t, err)
assert.False(t, exists)
_, err = db.Exec("CREATE TABLE tmp(id INT PRIMARY KEY);")
assert.Nil(t, err)
exists, err = adapter.TableExists(db, "tmp")
assert.Nil(t, err)
assert.True(t, exists)
}
func TestMySQL_DatabaseName(t *testing.T) {
cfg := bolttest.NewTestConnectionConfig()
adapter := storage.MySQLAdapter{}
db, err := sql.Open("mysql", adapter.CreateDSN(cfg))
assert.Nil(t, err)
t.Cleanup(func() {
assert.Nil(t, db.Close())
})
name, err := adapter.DatabaseName(db)
assert.Nil(t, err)
assert.Equal(t, name, cfg.DBName)
}
func TestMySQL_CreateDSN(t *testing.T) {
cfg := configloader.ConnectionConfig{
Driver: "mysql",
Host: "db1",
Port: "5432",
User: "testuser",
Password: "supersecretpassword",
DBName: "testdb",
}
adapter := storage.PostgresqlAdapter{}
cs := adapter.CreateDSN(cfg)
expectedConnectionString := fmt.Sprintf(
"host=%s port=%s user=%s password=%s dbname=%s sslmode=disable",
cfg.Host, cfg.Port, cfg.User, cfg.Password, cfg.DBName,
)
assert.Equal(t, cs, expectedConnectionString)
}
|