-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdelete_test.go
More file actions
139 lines (135 loc) · 3.65 KB
/
delete_test.go
File metadata and controls
139 lines (135 loc) · 3.65 KB
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
130
131
132
133
134
135
136
137
138
139
package querybuilder
import (
"errors"
"testing"
"time"
"github.com/stretchr/testify/require"
)
func TestDeleteQuery_Build(t *testing.T) {
tests := []struct {
name string
query *DeleteQuery
wantQuery string
wantArgs []interface{}
wantErr error
}{
{
name: "test1",
query: Delete(""),
wantQuery: "",
wantArgs: []interface{}(nil),
wantErr: errors.New(ErrTableIsEmpty),
},
{
name: "test2",
query: Delete("table1").Where("id=?", 5000),
wantQuery: "DELETE FROM table1 WHERE (id=?)",
wantArgs: []interface{}{5000},
wantErr: nil,
},
{
name: "test3 - wrong number of arguments",
query: Delete("table1").Where("id=?", 5000, 10),
wantQuery: "",
wantArgs: []interface{}(nil),
wantErr: errors.New(ErrWrongNumberOfArgs),
},
}
for _, tt := range tests {
t.Run(tt.name, func(t *testing.T) {
t1 := time.Now()
gotQuery, gotArgs, err := tt.query.Build()
t.Logf("duration: %s", time.Since(t1))
require.Equal(t, tt.wantQuery, gotQuery, "Build() gotQuery = %v, wantQuery %v", gotQuery, tt.wantQuery)
require.Equal(t, tt.wantArgs, gotArgs, "Build() gotArgs = %v, wantQuery %v", gotArgs, tt.wantArgs)
require.Equal(t, tt.wantErr, err)
})
}
}
func TestDeleteQuery_Rebind(t *testing.T) {
tests := []struct {
name string
driver DriverName
deleteQuery *DeleteQuery
want string
}{
{
name: "test Postgres",
driver: DriverPostgres,
deleteQuery: Delete("table1").Where("id=?", 5000),
want: "DELETE FROM table1 WHERE (id=$1)",
},
{
name: "test PGX",
driver: DriverPGX,
deleteQuery: Delete("table1").Where("id=?", 5000),
want: "DELETE FROM table1 WHERE (id=$1)",
},
{
name: "test pq-timeouts",
driver: DriverPqTimeout,
deleteQuery: Delete("table1").Where("id=?", 5000),
want: "DELETE FROM table1 WHERE (id=$1)",
},
{
name: "test CloudSqlPostgres",
driver: DriverCloudSqlPostgres,
deleteQuery: Delete("table1").Where("id=?", 5000),
want: "DELETE FROM table1 WHERE (id=$1)",
},
{
name: "test MySQL",
driver: DriverMySQL,
deleteQuery: Delete("table1").Where("id=?", 5000),
want: "DELETE FROM table1 WHERE (id=?)",
},
{
name: "test Sqlite3",
driver: DriverSqlite3,
deleteQuery: Delete("table1").Where("id=?", 5000),
want: "DELETE FROM table1 WHERE (id=?)",
},
{
name: "test oci8",
driver: DriverOCI8,
deleteQuery: Delete("table1").Where("id=?", 5000),
want: "DELETE FROM table1 WHERE (id=:arg1)",
},
{
name: "test ora",
driver: DriverORA,
deleteQuery: Delete("table1").Where("id=?", 5000),
want: "DELETE FROM table1 WHERE (id=:arg1)",
},
{
name: "test goracle",
driver: DriverGORACLE,
deleteQuery: Delete("table1").Where("id=?", 5000),
want: "DELETE FROM table1 WHERE (id=:arg1)",
},
{
name: "test SqlServer",
driver: DriverSqlServer,
deleteQuery: Delete("table1").Where("id=?", 5000),
want: "DELETE FROM table1 WHERE (id=@p1)",
},
{
name: "test unknown",
driver: "abcdefg",
deleteQuery: Delete("table1").Where("id=?", 5000),
want: "DELETE FROM table1 WHERE (id=?)",
},
}
for _, tt := range tests {
t.Run(tt.name, func(t *testing.T) {
query, _, err := tt.deleteQuery.Build()
if err != nil {
t.Errorf("can't build the query: %s", err)
}
Driver = tt.driver
if got := Rebind(query); got != tt.want {
require.Equal(t, tt.want, got, "Rebind() got = %v, want %v", got, tt.want)
}
})
}
}