// ------------------------------------------------------------ // // sqlite3_create.ts // // May/02/2020 // // ------------------------------------------------------------ var sqlite3 = require("sqlite3"); var text_manipulate= require ('/var/www/data_base/common/node_common/text_manipulate'); // ------------------------------------------------------------ function data_prepare_proc () { var dict_aa = new Object (); dict_aa = text_manipulate.dict_append_proc (dict_aa,'t0711','郡山',73526,'2012-3-20'); dict_aa = text_manipulate.dict_append_proc (dict_aa,'t0712','会津若松',23157,'2012-8-15'); dict_aa = text_manipulate.dict_append_proc (dict_aa,'t0713','白河',62143,'2012-10-2'); dict_aa = text_manipulate.dict_append_proc (dict_aa,'t0714','福島',38764,'2012-6-22'); dict_aa = text_manipulate.dict_append_proc (dict_aa,'t0715','喜多方',46358,'2012-8-14'); dict_aa = text_manipulate.dict_append_proc (dict_aa,'t0716','二本松',65192,'2012-9-12'); dict_aa = text_manipulate.dict_append_proc (dict_aa,'t0717','いわき',38251,'2012-3-21'); dict_aa = text_manipulate.dict_append_proc (dict_aa,'t0718','相馬',52416,'2012-7-26'); dict_aa = text_manipulate.dict_append_proc (dict_aa,'t0719','須賀川',26357,'2012-10-2'); return dict_aa; } // ------------------------------------------------------------ function table_create_insert_proc (db,dict_aa) { db.serialize (function () { db.run ("drop table cities"); var command = "create table cities (id varchar(10), name varchar(20),"; command += " population int, date_mod date)"; db.run (command); for (var key in dict_aa) { var sql_str:string = "insert into cities (id,name,population,date_mod) values ("; var str_data: string = "'" + key + "','" + dict_aa[key].name + "'," + dict_aa[key].population + ",'" + dict_aa[key].date_mod + "')"; sql_str += str_data; db.run (sql_str); } }); } // ------------------------------------------------------------ console.log ("*** 開始 ***"); var file_sqlite3: string = process.argv[2]; console.log (file_sqlite3); var dict_aa = data_prepare_proc (); var db = new sqlite3.Database (file_sqlite3); table_create_insert_proc (db,dict_aa); db.close (); console.log ("*** 終了 ***"); // ------------------------------------------------------------