Repository navigation
Expand file tree
/
Copy pathpostgres_test.go
More file actions
137 lines (113 loc) · 3.58 KB
/
Copy pathpostgres_test.go
File metadata and controls
137 lines (113 loc) · 3.58 KB
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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
package dbtestutil_test
import (
"database/sql"
"testing"
"time"
_ "github.com/lib/pq"
"github.com/stretchr/testify/require"
"go.uber.org/goleak"
"github.com/coder/coder/v2/coderd/database/dbtestutil"
"github.com/coder/coder/v2/coderd/database/migrations"
"github.com/coder/coder/v2/testutil"
)
func TestMain(m *testing.M) {
goleak.VerifyTestMain(m, testutil.GoleakOptions...)
}
func TestOpen(t *testing.T) {
t.Parallel()
if !dbtestutil.WillUsePostgres() {
t.Skip("this test requires postgres")
}
connect, err := dbtestutil.Open(t)
require.NoError(t, err)
db, err := sql.Open("postgres", connect)
require.NoError(t, err)
err = db.Ping()
require.NoError(t, err)
err = db.Close()
require.NoError(t, err)
}
func TestOpen_InvalidDBFrom(t *testing.T) {
t.Parallel()
if !dbtestutil.WillUsePostgres() {
t.Skip("this test requires postgres")
}
_, err := dbtestutil.Open(t, dbtestutil.WithDBFrom("__invalid__"))
require.Error(t, err)
require.ErrorContains(t, err, "template database")
require.ErrorContains(t, err, "does not exist")
}
func TestOpen_ValidDBFrom(t *testing.T) {
t.Parallel()
if !dbtestutil.WillUsePostgres() {
t.Skip("this test requires postgres")
}
// first check if we can create a new template db
dsn, err := dbtestutil.Open(t, dbtestutil.WithDBFrom(""))
require.NoError(t, err)
db, err := sql.Open("postgres", dsn)
require.NoError(t, err)
t.Cleanup(func() {
require.NoError(t, db.Close())
})
err = db.Ping()
require.NoError(t, err)
templateDBName := "tpl_" + migrations.GetMigrationsHash()[:32]
tplDbExistsRes, err := db.Query("SELECT 1 FROM pg_database WHERE datname = $1", templateDBName)
if err != nil {
require.NoError(t, err)
}
require.True(t, tplDbExistsRes.Next())
require.NoError(t, tplDbExistsRes.Close())
// now populate the db with some data and use it as a new template db
// to verify that dbtestutil.Open respects WithDBFrom
_, err = db.Exec("CREATE TABLE my_wonderful_table (id serial PRIMARY KEY, name text)")
require.NoError(t, err)
_, err = db.Exec("INSERT INTO my_wonderful_table (name) VALUES ('test')")
require.NoError(t, err)
rows, err := db.Query("SELECT current_database()")
require.NoError(t, err)
require.True(t, rows.Next())
var freshTemplateDBName string
require.NoError(t, rows.Scan(&freshTemplateDBName))
require.NoError(t, rows.Close())
require.NoError(t, db.Close())
for i := 0; i < 10; i++ {
db, err := sql.Open("postgres", dsn)
require.NoError(t, err)
require.NoError(t, db.Ping())
require.NoError(t, db.Close())
}
// now create a new db from the template db
newDsn, err := dbtestutil.Open(t, dbtestutil.WithDBFrom(freshTemplateDBName))
require.NoError(t, err)
newDb, err := sql.Open("postgres", newDsn)
require.NoError(t, err)
t.Cleanup(func() {
require.NoError(t, newDb.Close())
})
rows, err = newDb.Query("SELECT 1 FROM my_wonderful_table WHERE name = 'test'")
require.NoError(t, err)
require.True(t, rows.Next())
require.NoError(t, rows.Close())
}
func TestOpen_Panic(t *testing.T) {
t.Skip("unskip this to manually test that we don't leak a database into postgres")
t.Parallel()
if !dbtestutil.WillUsePostgres() {
t.Skip("this test requires postgres")
}
_, err := dbtestutil.Open(t)
require.NoError(t, err)
panic("now check SELECT datname FROM pg_database;")
}
func TestOpen_Timeout(t *testing.T) {
t.Skip("unskip this and set a short timeout to manually test that we don't leak a database into postgres")
t.Parallel()
if !dbtestutil.WillUsePostgres() {
t.Skip("this test requires postgres")
}
_, err := dbtestutil.Open(t)
require.NoError(t, err)
time.Sleep(11 * time.Minute)
}