#! /usr/bin/python3
# -*- coding: utf-8 -*-
#
#	mysql_delete.py
#
#					Jul/25/2014
#
# --------------------------------------------------------
import	sys
import	mysql.connector
#
sys.path.append ('/var/www/data_base/common/python_common')
from sql_manipulate import sql_display_proc,sql_delete_proc
#
# --------------------------------------------------------
print ("*** 開始 ***")
#
id_in = sys.argv[1]
print ("%s" % id_in)
#
conn = mysql.connector.connect (host="host_mysql",db="city", \
			user="scott", passwd="<PASSWORD>")
#
cursor = conn.cursor ()
#
sql_delete_proc	(cursor,id_in)
conn.commit ()
#
sql_display_proc (cursor)
#
cursor.close ()
conn.close ()
print ("*** 終了 ***")
#
# --------------------------------------------------------

#! /usr/bin/python3
# -*- coding: utf-8 -*-
#
#	mysql_delete.py
#
#					Jul/25/2014
#
# --------------------------------------------------------
import	sys
import	mysql.connector
#
sys.path.append ('/var/www/data_base/common/python_common')
from sql_manipulate import sql_display_proc,sql_delete_proc
#
# --------------------------------------------------------
print ("*** 開始 ***")
#
id_in = sys.argv[1]
print ("%s" % id_in)
#
conn = mysql.connector.connect (host="host_mysql",db="city", \
			user="scott", passwd="<PASSWORD>")
#
cursor = conn.cursor ()
#
sql_delete_proc	(cursor,id_in)
conn.commit ()
#
sql_display_proc (cursor)
#
cursor.close ()
conn.close ()
print ("*** 終了 ***")
#
# --------------------------------------------------------

#! /usr/bin/python3 # -*- coding: utf-8 -*- # #	mysql_delete.py # #					Jul/25/2014 # # -------------------------------------------------------- # # # -------------------------------------------------------- # # # # # # # # --------------------------------------------------------