aboutsummaryrefslogtreecommitdiffstats
path: root/internal/storage/postgresql_test.go
blob: d244646c7265eaf69e236ba7cbb6356c488c732f (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
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
//go:build postgresql

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 TestPostgresql_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 = $1;",
		},
		{
			query:         "SELECT id, name FROM some_table WHERE id = ? AND name = ?;",
			argCount:      2,
			expectedQuery: "SELECT id, name FROM some_table WHERE id = $1 AND name = $2;",
		},
	}
	for _, tc := range testCases {
		adapter := storage.PostgresqlAdapter{}
		newQuery := adapter.ConvertGenericPlaceholders(tc.query, tc.argCount)
		assert.Equal(t, newQuery, tc.expectedQuery)
	}
}

func TestPostgresql_TableExistsDefaultSchema(t *testing.T) {
	cfg := bolttest.NewTestConnectionConfig()
	adapter := storage.PostgresqlAdapter{}
	db, err := sql.Open("pgx", 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 TestPostgresql_TableExistsCustomSchema(t *testing.T) {
	cfg := bolttest.NewTestConnectionConfig()
	adapter := storage.PostgresqlAdapter{}
	db, err := sql.Open("pgx", adapter.CreateDSN(cfg))
	assert.Nil(t, err)
	t.Cleanup(func() {
		_, err = db.Exec("DROP SCHEMA IF EXISTS custom_schema CASCADE;")
		assert.Nil(t, err)
		assert.Nil(t, db.Close())
	})

	exists, err := adapter.TableExists(db, "custom_table.tmp")
	assert.Nil(t, err)
	assert.False(t, exists)

	_, err = db.Exec("CREATE SCHEMA custom_schema;")
	assert.Nil(t, err)

	_, err = db.Exec("CREATE TABLE custom_schema.tmp(id INT PRIMARY KEY);")
	assert.Nil(t, err)

	exists, err = adapter.TableExists(db, "custom_schema.tmp")
	assert.Nil(t, err)
	assert.True(t, exists)
}

func TestPostgresql_DatabaseName(t *testing.T) {
	cfg := bolttest.NewTestConnectionConfig()
	adapter := storage.PostgresqlAdapter{}
	db, err := sql.Open("pgx", 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 TestPostgresql_CreateDSN(t *testing.T) {
	cfg := configloader.ConnectionConfig{
		Driver:   "postgres",
		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)
}