// -------------------------------------------------------------------
/*
	mysql_create.cs

					Sep/17/2013


*/
// -------------------------------------------------------------------
using	System;
using	System.Collections.Generic;
using	System.Data;
using	System.Text;
using	MySql.Data.MySqlClient;

// -------------------------------------------------------------------
class mysql_create
{
// -------------------------------------------------------------------
static void Main (string[] args)
{
	Console.WriteLine ("*** 開始 ***");

	Dictionary <string,Object> dict_aa = data_prepare_proc ();

	string server="host_mysql";
	string str_db="city";

	string str_connect = "Server=" + server + 
	";User Id=scott;Password=tiger;" +
		"Database=" + str_db + ";";

	MySqlConnection connection = new MySqlConnection (str_connect);
	connection.Open ();

	mysql_manipulate.table_drop_proc (connection);

	mysql_manipulate.table_create_proc (connection);

	mysql_manipulate.dict_to_db_proc (dict_aa,connection);

	connection.Close ();

	Console.WriteLine ("*** 終了 ***");
}

// -------------------------------------------------------------------
static Dictionary <string,Object> data_prepare_proc ()
{
	Dictionary <string,Object> dict_aa
			= new Dictionary <string,Object> ();

	dict_aa = text_manipulate.dict_append_proc (dict_aa,"t3321","岡山",47125,"2009-8-4");
	dict_aa = text_manipulate.dict_append_proc (dict_aa,"t3322","倉敷",29687,"2009-9-2");
	dict_aa = text_manipulate.dict_append_proc (dict_aa,"t3323","津山",81392,"2009-10-8");
	dict_aa = text_manipulate.dict_append_proc (dict_aa,"t3324","玉野",93187,"2009-5-9");

	dict_aa = text_manipulate.dict_append_proc (dict_aa,"t3325","笠岡",61978,"2009-1-5");
	dict_aa = text_manipulate.dict_append_proc (dict_aa,"t3326","井原",35647,"2009-5-22");
	dict_aa = text_manipulate.dict_append_proc (dict_aa,"t3327","総社",42786,"2009-7-17");
	dict_aa = text_manipulate.dict_append_proc (dict_aa,"t3328","高梁",14835,"2009-3-4");
	dict_aa = text_manipulate.dict_append_proc (dict_aa,"t3329","新見",71324,"2009-10-12");

	return	dict_aa;
}

// -------------------------------------------------------------------
}

// -------------------------------------------------------------------