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
|
// +build all cassandra
package gocql
import (
"strings"
"testing"
)
func TestProto1BatchInsert(t *testing.T) {
session := createSession(t)
defer session.Close()
if err := createTable(session, "CREATE TABLE gocql_test.large (id int primary key)"); err != nil {
t.Fatal(err)
}
begin := "BEGIN BATCH"
end := "APPLY BATCH"
query := "INSERT INTO large (id) VALUES (?)"
fullQuery := strings.Join([]string{begin, query, end}, "\n")
args := []interface{}{5}
if err := session.Query(fullQuery, args...).Consistency(Quorum).Exec(); err != nil {
t.Fatal(err)
}
}
func TestShouldPrepareFunction(t *testing.T) {
var shouldPrepareTests = []struct {
Stmt string
Result bool
}{
{`
BEGIN BATCH
INSERT INTO users (userID, password)
VALUES ('smith', 'secret')
APPLY BATCH
;
`, true},
{`INSERT INTO users (userID, password, name) VALUES ('user2', 'ch@ngem3b', 'second user')`, true},
{`BEGIN COUNTER BATCH UPDATE stats SET views = views + 1 WHERE pageid = 1 APPLY BATCH`, true},
{`delete name from users where userID = 'smith';`, true},
{` UPDATE users SET password = 'secret' WHERE userID = 'smith' `, true},
{`CREATE TABLE users (
user_name varchar PRIMARY KEY,
password varchar,
gender varchar,
session_token varchar,
state varchar,
birth_year bigint
);`, false},
}
for _, test := range shouldPrepareTests {
q := &Query{stmt: test.Stmt}
if got := q.shouldPrepare(); got != test.Result {
t.Fatalf("%q: got %v, expected %v\n", test.Stmt, got, test.Result)
}
}
}
|
