pierangelo1982 / covid19-grafana Goto Github PK

when i run python3 store_data.py

I got an error
Traceback (most recent call last):
File "/usr/local/lib/python3.6/dist-packages/mysql/connector/connection_cext.py", line 489, in cmd_query
raw_as_string=raw_as_string)
_mysql_connector.MySQLInterfaceError: Table 'covid19.corona' doesn't exist

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "store_data.py", line 22, in
last_cursor.execute(last_sql)
File "/usr/local/lib/python3.6/dist-packages/mysql/connector/cursor_cext.py", line 266, in execute
raw_as_string=self._raw_as_string)
File "/usr/local/lib/python3.6/dist-packages/mysql/connector/connection_cext.py", line 492, in cmd_query
sqlstate=exc.sqlstate)
mysql.connector.errors.ProgrammingError: 1146 (42S02): Table 'covid19.corona' doesn't exist

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "store_data.py", line 27, in
last_data = datetime.datetime.strptime("1900-01-01", "%Y-%m-%d %H:%M:%S").date()
File "/usr/lib/python3.6/_strptime.py", line 565, in _strptime_datetime
tt, fraction = _strptime(data_string, format)
File "/usr/lib/python3.6/_strptime.py", line 362, in _strptime
(data_string, format))
ValueError: time data '1900-01-01' does not match format '%Y-%m-%d %H:%M:%S'