aboutsummaryrefslogtreecommitdiffstats
path: root/internal/repositories/migration_db_repo_postgresql_test.go
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)
}