Python3: MariaDB のデータを更新 (Update)

プログラム

フォルダー構造

$ tree -a
.
├── .env
├── config_mariadb.py
└── maria_update.py

.env
config_mariadb.py
はこちら
Python3: MariaDB のバージョンを表示

maria_update.py

#! /usr/bin/python
#
#	maria_update.py
#
#					Feb/22/2023
#
# --------------------------------------------------------
import	sys
import	string
import	mariadb
from time import localtime,strftime
#
from config_mariadb import config_mariadb_proc
# --------------------------------------------------------
def	sql_update_proc(cursor_aa,id_in,ipop_in):
#
	sql_str = sql_update_string_gen_proc(id_in,ipop_in)
	cursor_aa.execute(sql_str)
# --------------------------------------------------------
def	sql_update_string_gen_proc(id_in,ipop_in):
	date_mod = strftime("%Y-%m-%d",localtime ())
	ft_aa=u"update cities set population = %d, " % ipop_in
	ft_bb=u"date_mod='%s' " % date_mod
	ft_cc=u"where id = '%s'" % id_in
	sql_str=ft_aa + ft_bb + ft_cc
	print(sql_str)
#
	return	sql_str
# --------------------------------------------------------
sys.stderr.write("*** 開始 ***\n")
#
key_in = sys.argv[1]
population_in = int(sys.argv[2])
print("%s\t%d" % (key_in, population_in))
#
host,user,password,data_base = config_mariadb_proc()
conn = mariadb.connect(user=user, password=password, \
                              host=host,database=data_base)
#
cursor = conn.cursor()
#
sql_update_proc(cursor,key_in,population_in)
conn.commit()
#
cursor.close()
conn.close()
sys.stderr.write("*** 終了 ***\n")
#
# --------------------------------------------------------

実行結果

$ ./maria_update.py t3321 64592700
*** 開始 ***
t3321	64592700
update cities set population = 64592700, date_mod='2023-02-22' where id = 't3321'
*** 終了 ***