summaryrefslogtreecommitdiffstats
path: root/tests/restore-lock.smack
blob: a591ab2d383e744aeb8636c823a827d373bc78fe (plain)
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
#! /usr/local/bin/mysql-super-smack

query "select"
 {
   type "select";
   query "select count(*) from w";
   has_result_set "y";
   parsed "n";
 }

query "restore"
 {
   type "restore";
   query "restore table w from '/tmp'";
   has_result_set "y";
   parsed "n";
 }

query "drop"
 {
   type "drop";
   query "drop table if exists w";
   has_result_set "n";
   parsed "n";
 }



client "restorer"
 {
  user "root";
  pass "";
  host "localhost";
  db "test";
  query_barrel "1 drop 1 restore";
 }

client "selector"
 {
  user "root";
  pass "";
  host "localhost";
  db "test";
  query_barrel "-3 1 select";
 }

main
 {
   selector.init();
   restorer.init();
   selector.create_threads(1);
   restorer.create_threads(1);
   selector.set_num_rounds(1);
   restorer.set_num_rounds(1);
   selector.connect();
   restorer.connect();
   restorer.unload_query_barrel();
   selector.unload_query_barrel();
   restorer.collect_threads();
   selector.collect_threads();
   selector.disconnect();
   restorer.disconnect();
 }