-
Notifications
You must be signed in to change notification settings - Fork 28
/
delete_test.go
33 lines (28 loc) · 886 Bytes
/
delete_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
package sqlingo
import (
"errors"
"testing"
)
func TestDelete(t *testing.T) {
errorExpression := expression{
builder: func(scope scope) (string, error) {
return "", errors.New("error")
},
}
db := newMockDatabase()
if _, err := db.DeleteFrom(Table1).Where(staticExpression("##", 1, false)).Execute(); err != nil {
t.Error(err)
}
assertLastSql(t, "DELETE FROM `table1` WHERE ##")
if _, err := db.DeleteFrom(Table1).Where(errorExpression).Execute(); err == nil {
t.Error("should get error here")
}
if _, err := db.DeleteFrom(Table1).Where(Raw("#1#")).Limit(3).Execute(); err != nil {
t.Error(err)
}
assertLastSql(t, "DELETE FROM `table1` WHERE #1# LIMIT 3")
if _, err := db.DeleteFrom(Table1).Where(Raw("#1#")).OrderBy(Raw("#2#")).Limit(3).Execute(); err != nil {
t.Error(err)
}
assertLastSql(t, "DELETE FROM `table1` WHERE #1# ORDER BY #2# LIMIT 3")
}