1
by brian
clean slate |
1 |
#! /usr/local/bin/mysql-super-smack
|
2 |
||
3 |
query "select" |
|
4 |
{
|
|
5 |
type "select"; |
|
6 |
query "select count(*) from w"; |
|
7 |
has_result_set "y"; |
|
8 |
parsed "n"; |
|
9 |
}
|
|
10 |
||
11 |
query "restore" |
|
12 |
{
|
|
13 |
type "restore"; |
|
14 |
query "restore table w from '/tmp'"; |
|
15 |
has_result_set "y"; |
|
16 |
parsed "n"; |
|
17 |
}
|
|
18 |
||
19 |
query "drop" |
|
20 |
{
|
|
21 |
type "drop"; |
|
22 |
query "drop table if exists w"; |
|
23 |
has_result_set "n"; |
|
24 |
parsed "n"; |
|
25 |
}
|
|
26 |
||
27 |
||
28 |
||
29 |
client "restorer" |
|
30 |
{
|
|
31 |
user "root"; |
|
32 |
pass ""; |
|
33 |
host "localhost"; |
|
34 |
db "test"; |
|
35 |
query_barrel "1 drop 1 restore"; |
|
36 |
}
|
|
37 |
||
38 |
client "selector" |
|
39 |
{
|
|
40 |
user "root"; |
|
41 |
pass ""; |
|
42 |
host "localhost"; |
|
43 |
db "test"; |
|
44 |
query_barrel "-3 1 select"; |
|
45 |
}
|
|
46 |
||
47 |
main
|
|
48 |
{
|
|
49 |
selector.init(); |
|
50 |
restorer.init(); |
|
51 |
selector.create_threads(1); |
|
52 |
restorer.create_threads(1); |
|
53 |
selector.set_num_rounds(1); |
|
54 |
restorer.set_num_rounds(1); |
|
55 |
selector.connect(); |
|
56 |
restorer.connect(); |
|
57 |
restorer.unload_query_barrel(); |
|
58 |
selector.unload_query_barrel(); |
|
59 |
restorer.collect_threads(); |
|
60 |
selector.collect_threads(); |
|
61 |
selector.disconnect(); |
|
62 |
restorer.disconnect(); |
|
63 |
}
|