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()