xzsRk8Y6

1#!/bin/bash
2
3DB_ROOT_USER=root
4DB_ROOT_PASS=root
5
6set -e
7set -x
8
9cat - <<EOF > /tmp/db_test0.sql
10DROP DATABASE IF EXISTS vim_test0;
11CREATE DATABASE vim_test0;
12USE vim_test0;
13
14DROP TABLE IF EXISTS testtabint;
15CREATE TABLE testtabint (
16  id smallint(5) NOT NULL,
17  name varchar(10),
18  PRIMARY KEY (id)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='testing it';
20
21GRANT ALL PRIVILEGES ON vim_test0.* TO 'vim'@'localhost' IDENTIFIED BY 'vimpw';
22EOF
23
24cat - <<EOF > /tmp/insert_test0.sql
25INSERT INTO testtabint (id, name) VALUES (12, 'ciao');
26EOF
27
28cat - <<EOF > /tmp/delete_test0.sql
29DELETE FROM testtabint WHERE name = 'ciao';
30EOF
31
32
33mysql -u${DB_ROOT_USER} -p${DB_ROOT_PASS} < /tmp/db_test0.sql
34
35sleep 1
36
37while [ 1 ]; do
38        echo "insert"
39        time mysql -uvim -pvimpw vim_test0 < /tmp/insert_test0.sql 
40        sleep 5
41        echo "delete"
42        time mysql -uvim -pvimpw vim_test0 < /tmp/delete_test0.sql
43        sleep 5
44done