mariadb/tests/restore-lock.smack

#! /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();
 }