Skip to content

Instantly share code, notes, and snippets.

@blacklight
Created May 3, 2020 17:13
Show Gist options
  • Save blacklight/0d5de39d99ef0c9d989f369385a7a1fd to your computer and use it in GitHub Desktop.
Save blacklight/0d5de39d99ef0c9d989f369385a7a1fd to your computer and use it in GitHub Desktop.
from platypush.event.hook import hook
from platypush.message.event.covid19 import Covid19UpdateEvent
from platypush.utils import run
@hook(Covid19UpdateEvent)
def on_covid19_update(event, **context):
db_engine = 'postgresql+pg8000://user:password@db_ip_address/covid19'
run('db.insert', table='tmp_covid19_data', engine=db_engine, records=[
{
'country': event.args['country'],
'confirmed': event.args['confirmed'] or 0,
'deaths': event.args['deaths'] or 0,
'recovered': event.args['recovered'] or 0,
'report_date': event.args['update_time'],
}
])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment