forked from vitessio/vitess
-
Notifications
You must be signed in to change notification settings - Fork 0
/
client.go
111 lines (100 loc) · 2.63 KB
/
client.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
110
111
// client.go is a sample for using the Vitess Go SQL driver.
//
// Before running this, start up a local example cluster as described in the
// README.md file.
//
// Then run:
// vitess$ . dev.env
// vitess$ cd examples/local
// vitess/examples/local$ go run client.go -server=localhost:15991
package main
import (
"flag"
"fmt"
"math/rand"
"os"
"time"
"github.com/youtube/vitess/go/vt/vitessdriver"
)
var (
server = flag.String("server", "", "vtgate server to connect to")
)
func main() {
flag.Parse()
rand.Seed(time.Now().UnixNano())
timeout := 10 * time.Second
// Connect to vtgate.
db, err := vitessdriver.Open(*server, "", "master", timeout)
if err != nil {
fmt.Printf("client error: %v\n", err)
os.Exit(1)
}
defer db.Close()
// Insert some messages on random pages.
fmt.Println("Inserting into master...")
for i := 0; i < 3; i++ {
tx, err := db.Begin()
if err != nil {
fmt.Printf("begin failed: %v\n", err)
os.Exit(1)
}
page := rand.Intn(100) + 1
timeCreated := time.Now().UnixNano()
if _, err := tx.Exec("INSERT INTO messages (page,time_created_ns,message) VALUES (?,?,?)",
page, timeCreated, "V is for speed"); err != nil {
fmt.Printf("exec failed: %v\n", err)
os.Exit(1)
}
if err := tx.Commit(); err != nil {
fmt.Printf("commit failed: %v\n", err)
os.Exit(1)
}
}
// Read it back from the master.
fmt.Println("Reading from master...")
rows, err := db.Query("SELECT page, time_created_ns, message FROM messages")
if err != nil {
fmt.Printf("query failed: %v\n", err)
os.Exit(1)
}
for rows.Next() {
var page, timeCreated uint64
var msg string
if err := rows.Scan(&page, &timeCreated, &msg); err != nil {
fmt.Printf("scan failed: %v\n", err)
os.Exit(1)
}
fmt.Printf("(%v, %v, %q)\n", page, timeCreated, msg)
}
if err := rows.Err(); err != nil {
fmt.Printf("row iteration failed: %v\n", err)
os.Exit(1)
}
// Read from a replica.
// Note that this may be behind master due to replication lag.
fmt.Println("Reading from replica...")
dbr, err := vitessdriver.Open(*server, "", "replica", timeout)
if err != nil {
fmt.Printf("client error: %v\n", err)
os.Exit(1)
}
defer dbr.Close()
rows, err = dbr.Query("SELECT page, time_created_ns, message FROM messages")
if err != nil {
fmt.Printf("query failed: %v\n", err)
os.Exit(1)
}
for rows.Next() {
var page, timeCreated uint64
var msg string
if err := rows.Scan(&page, &timeCreated, &msg); err != nil {
fmt.Printf("scan failed: %v\n", err)
os.Exit(1)
}
fmt.Printf("(%v, %v, %q)\n", page, timeCreated, msg)
}
if err := rows.Err(); err != nil {
fmt.Printf("row iteration failed: %v\n", err)
os.Exit(1)
}
}