// ---------------------------------------------------------------
//	maria_update.ts
//
//					Jan/09/2022
//
// ---------------------------------------------------------------
var mysql = require('mysql2')
var sql_manipulate= require ('/var/www/data_base/common/node_common/sql_manipulate')

// ---------------------------------------------------------------
console.log ("*** 開始 ***")

var id_in:string = process.argv[2]
var population_in:number = parseInt(process.argv[3])

console.log (id_in + "\t" + population_in)

var connection = mysql.createConnection ({
	host: 'localhost',
	user: 'scott',
	password: 'tiger123'
	})

connection.query ('Use city')

var command: string = sql_manipulate.update_command_gen (id_in,population_in)

connection.query(command, function (err, rows)
	{
  	if (err) throw err
	console.log ("*** 終了 ***")
	})

connection.end()

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