-
Notifications
You must be signed in to change notification settings - Fork 0
/
postgres_test.go
109 lines (85 loc) · 4.13 KB
/
postgres_test.go
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
package sqlassert_test
import (
"fmt"
"testing"
"github.com/pengux/sqlassert"
"github.com/DATA-DOG/go-sqlmock"
)
func TestPostgresAsserter(t *testing.T) {
pgasserter := sqlassert.NewPostgresAsserter(getPostgresDB())
table := "sqlassert_test"
column := "sku"
dataType := "text"
constraint := "sqlassert_test_pkey"
row := map[string]interface{}{"sku": "sku1", "name": "name1"}
index := "sqlassert_test_name_idx"
nonExisting := "non_existing"
pgasserter.TableExists(t, table)
pgasserter.ColumnExists(t, table, column)
pgasserter.ColumnOfType(t, table, column, dataType)
pgasserter.ConstraintExists(t, table, constraint)
pgasserter.RowExists(t, table, row)
pgasserter.IndexExists(t, table, index)
pgasserter.TableNotExists(t, nonExisting)
pgasserter.ColumnNotExists(t, table, nonExisting)
pgasserter.ConstraintNotExists(t, table, nonExisting)
pgasserter.RowNotExists(t, table, map[string]interface{}{"sku": nonExisting})
pgasserter.IndexNotExists(t, table, nonExisting)
}
func TestPostgresAsserterError(t *testing.T) {
pgasserter := sqlassert.NewPostgresAsserter(getPostgresDB())
mockT := new(mockT)
table := "sqlassert_test"
column := "sku"
constraint := "sqlassert_test_pkey"
row := map[string]interface{}{"sku": "sku1", "name": "name1"}
index := "sqlassert_test_name_idx"
nonExisting := "non_existing"
pgasserter.TableExists(mockT, nonExisting)
mockT.expectLastError(t, "table '"+nonExisting+"' does not exist")
pgasserter.ColumnExists(mockT, table, nonExisting)
mockT.expectLastError(t, "column '"+nonExisting+"' does not exist in table '"+table+"'")
pgasserter.ColumnOfType(mockT, table, column, nonExisting)
mockT.expectLastError(t, "column '"+column+"' in table '"+table+"' is not of type '"+nonExisting+"'")
pgasserter.ConstraintExists(mockT, table, nonExisting)
mockT.expectLastError(t, "constraint '"+nonExisting+"' does not exist in table '"+table+"'")
pgasserter.RowExists(mockT, table, map[string]interface{}{"sku": nonExisting})
mockT.expectLastError(t, "row with criteria map[sku:"+nonExisting+"] does not exist in table '"+table+"'")
pgasserter.IndexExists(mockT, table, nonExisting)
mockT.expectLastError(t, "index '"+nonExisting+"' does not exist in table '"+table+"'")
pgasserter.TableNotExists(mockT, table)
mockT.expectLastError(t, "table '"+table+"' exists")
pgasserter.ColumnNotExists(mockT, table, column)
mockT.expectLastError(t, "column '"+column+"' exists in table '"+table+"'")
pgasserter.ConstraintNotExists(mockT, table, constraint)
mockT.expectLastError(t, "constraint '"+constraint+"' exists in table '"+table+"'")
pgasserter.RowNotExists(mockT, table, row)
mockT.expectLastError(t, "row with criteria map[name:name1 sku:sku1] exists in table '"+table+"'")
pgasserter.IndexNotExists(mockT, table, index)
mockT.expectLastError(t, "index '"+index+"' exists in table '"+table+"'")
}
func TestPostgresAsserterPanic(t *testing.T) {
db, mock, err := sqlmock.New()
if err != nil {
t.Fatalf("an error '%s' was not expected when opening a stub database connection", err)
}
mock.ExpectQuery("SELECT EXISTS").WillReturnError(fmt.Errorf("error"))
mock.ExpectQuery("SELECT EXISTS").WillReturnError(fmt.Errorf("error"))
mock.ExpectQuery("SELECT EXISTS").WillReturnError(fmt.Errorf("error"))
mock.ExpectQuery("SELECT EXISTS").WillReturnError(fmt.Errorf("error"))
mock.ExpectQuery("SELECT EXISTS").WillReturnError(fmt.Errorf("error"))
mock.ExpectQuery("SELECT EXISTS").WillReturnError(fmt.Errorf("error"))
pgasserter := sqlassert.NewPostgresAsserter(db)
table := "sqlassert_test"
column := "sku"
dataType := "text"
constraint := "sqlassert_test_pkey"
row := map[string]interface{}{"sku": "sku1", "name": "name1"}
index := "sqlassert_test_name_idx"
assertPanic(t, "error", func() { pgasserter.TableExists(t, table) })
assertPanic(t, "error", func() { pgasserter.ColumnExists(t, table, column) })
assertPanic(t, "error", func() { pgasserter.ColumnOfType(t, table, column, dataType) })
assertPanic(t, "error", func() { pgasserter.ConstraintExists(t, table, constraint) })
assertPanic(t, "error", func() { pgasserter.RowExists(t, table, row) })
assertPanic(t, "error", func() { pgasserter.IndexExists(t, table, index) })
}