8if59fPH

1require 'mysql2'
2require 'parallel'
3
4
5start = Time.now
6puts "#{start} start"
7# (1...10000).each do |i|
8Parallel.each(1..10000) do |i|
9  client = Mysql2::Client.new(host: ENV['DB_HOST'],
10                              username: ENV['DB_USER'],
11                              password: ENV['DB_PASSWORD'],
12                              database: ENV['DB_NAME']
13                             )
14  client.query "drop database if exists test_#{i}"
15  client.query "create database if not exists test_#{i}"
16  client.query "drop table if exists test_#{i}.users"
17  client.query "create table if not exists test_#{i}.users (id int primary key,login_id varchar(100), keycode int(3), name varchar(2000), create_at datetime)"
18  client.query "create index idx_keycode on test_#{i}.users (keycode) "
19  client.close
20  puts "execute test_#{i} database"
21end
22# results = client.query('select * from test')
23
24end_time = Time.now
25puts "#{Time.now} finished. spend time #{end_time - start}sec."