require 'mysql2'

a = Mysql2::Client.new(:host => "localhost", :username => "root", :password => 'schakra', :database => 'oms_azure')

queries = ["show tables;",
"DROP TABLE IF EXISTS employee ;",
"create table employee ( id INT AUTO_INCREMENT PRIMARY KEY, name varchar(20), dept varchar(10), salary int(10) );",
"insert into employee values(100,'Thomas','Sales',5000);",
"insert into employee values(200,'Jason','Technology',5500);",
"insert into employee values(300,'Mayla','Technology',7000);",
"insert into employee values(400,'Nisha','Marketing',9500);",
"insert into employee values(500,'Randy','Technology',6000);",
"SELECT * FROM employee;",
"select name, dept from employee;",
"SELECT name, salary FROM employee;",
"SELECT * FROM employee WHERE salary > 6000;",
"SELECT * FROM employee WHERE salary = 6000;",
"SELECT * FROM employee WHERE salary != 6000;",
"SELECT * FROM employee WHERE dept = 'Technology';",
"SELECT * FROM employee WHERE dept = 'TECHNOLOGY';",
"SELECT * FROM employee WHERE dept != 'TECHNOLOGY';",
"SELECT * FROM employee WHERE name LIKE 'JOHN%';",
"SELECT * FROM employee WHERE name LIKE '%SMITH';",
"SELECT * FROM employee WHERE dept = 'TECHNOLOGY' AND salary >= 6000;",
"SELECT * FROM employee WHERE dept = 'TECHNOLOGY' OR salary >= 6000;",
"SELECT COUNT(*) FROM employee;",
"SELECT DEPT, COUNT(*) FROM employee GROUP BY DEPT;",
"SELECT COUNT(*) AS CNT, DEPT FROM employee GROUP BY DEPT HAVING CNT > 1;",
"Alter table employee add column address varchar(45); ",
"Alter table employee modify column address int(10); ",
"DROP TABLE employee ;",
"show tables;"]

count = 500000

while count > 0
  queries.each do |q|
    a.query(q)
    sleep 5
  end
  count -= 1
  sleep 10
end