#! /usr/bin/ruby
#
#	ruby/create/maria_create.rb
#
#					Feb/23/2023
# ---------------------------------------------------------------------
require 'mysql2'
#
load '/var/www/data_base/common/ruby_common/text_manipulate.rb'
# ---------------------------------------------------------------------
def prepare_data_proc ()
dict_aa = {}
dict_aa=dict_append_proc(dict_aa,'t3321',"岡山",729638,"2006-9-14")
dict_aa=dict_append_proc(dict_aa,'t3322',"倉敷",318475,"2006-2-27")
dict_aa=dict_append_proc(dict_aa,'t3323',"津山",182564,"2006-8-8")
dict_aa=dict_append_proc(dict_aa,'t3324',"玉野",572948,"2006-11-15")
dict_aa=dict_append_proc(dict_aa,'t3325',"笠岡",893257,"2006-7-21")
dict_aa=dict_append_proc(dict_aa,'t3326',"井原",167589,"2006-9-7")
dict_aa=dict_append_proc(dict_aa,'t3327',"総社",241637,"2006-4-8")
dict_aa=dict_append_proc(dict_aa,'t3328',"高梁",438129,"2006-10-12")
dict_aa=dict_append_proc(dict_aa,'t3329',"新見",519472,"2006-6-9")
	return	dict_aa
end
# ---------------------------------------------------------------------
def	create_proc (client)
	sql_str="create TABLE cities (" \
		+ "id varchar(10) NOT NULL PRIMARY KEY," \
		+ "name varchar(20)," \
		+ "population int," \
		+ "date_mod varchar(40))"
	client.query(sql_str)
end
# ------------------------------------------------------------
def	drop_proc (client)
	sql_str="drop table cities"
	client.query(sql_str)
end
# ---------------------------------------------------------------------
def	insert_proc (client,id,name,population,date_mod)
	sql_str="INSERT into cities " \
		+ "(id, Name, Population, date_mod) values \
		('#{id}', '#{name}',#{population},'#{date_mod}')"
	client.query(sql_str)
end
# ---------------------------------------------------------------------
STDERR.puts	"*** 開始 ***"
#
host = "localhost"
user = "scott"
password = "tiger123"
data_base = 'city'
client = Mysql2::Client.new(host: host, username: user, password: password, database: data_base)
#
dict_aa=prepare_data_proc()
#
drop_proc(client)
create_proc(client)
dict_aa.each {|key,value |
	insert_proc(client,key,value['name'], \
		value['population'],value['date_mod'])
	}
#
client.close
#
STDERR.puts	"*** 終了 ***"
#
# ---------------------------------------------------------------------