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()
else:
resolution = resolutions['year']
# TODO: filter out samples from 'result'
- # something like
+ # something like
# select to_seconds(datetime) DIV (60*60*24) as interval_id, min(datetime), max(datetime), min(temp), avg(temp), max(temp), count(temp) from openweathermap group by interval_id order by interval_id;
return query.all()