aboutsummaryrefslogtreecommitdiffstats
path: root/internal/repositories/migration_db_repo_postgresql_test.go
blob: 243370c1d29e9ae4a796c09a81c29a2158b4ea60 (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.eugenetriguba.com/bolt/cli/internal/bolttest"
	"git.eugenetriguba.com/bolt/cli/internal/repositories"
	"git.eugenetriguba.com/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)
}