# cityid=..
# 3319578 for Obsteig, AT
+# needed packaes: python3-mysqldb python3-sqlalchemy
+
from pprint import pprint
import argparse
import configparser
sql = 'insert ignore into openweathermap ({}) values ({})'.format(', '.join(sql_columns), ','.join(['%s'] * len(sql_columns)))
with warnings.catch_warnings():
# ignore _mysql_exceptions.Warning: Duplicate entry '3319578-2018-08-01 20:50:00' for key 'cityid_datetime'
- warnings.simplefilter("ignore", category=MySQLdb.cursors.Warning)
+ warnings.simplefilter("ignore", category=MySQLdb.cursors.Warning)
conn.execute(sql, *sql_values)
conn.close()