blob: a4fe576a47e1dc5b2d491f111c6ad3a654bfbfea (
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
|
//go:build postgresql
package repositories_test
import (
"testing"
"git.sr.ht/~eugenetriguba/bolt/internal/bolttest"
"git.sr.ht/~eugenetriguba/bolt/internal/repositories"
"git.sr.ht/~eugenetriguba/checkmate/assert"
)
func TestNewMigrationDBRepo_CreatesTableInSchema_Postgresql(t *testing.T) {
testdb := bolttest.NewTestDB(t)
schemaName := "custom_schema"
tableName := schemaName + ".bolt_migrations"
t.Cleanup(func() {
_, err := testdb.Exec("DROP SCHEMA IF EXISTS " + schemaName + " CASCADE;")
assert.Nil(t, err)
})
_, err := testdb.Exec("CREATE SCHEMA IF NOT EXISTS " + schemaName)
assert.Nil(t, err)
exists, err := testdb.TableExists(tableName)
assert.Nil(t, err)
assert.False(t, exists)
_, err = repositories.NewMigrationDBRepo(tableName, testdb)
assert.Nil(t, err)
exists, err = testdb.TableExists(tableName)
assert.Nil(t, err)
assert.True(t, exists)
}
|