Import event and alert metadata into ligo_waves database

thespacedoctor / psat-ligo-resources

Planning and issues related to QUB/Oxford LVK Observing

1 stars 0 forks source link

Import event and alert metadata into ligo_waves database #7

Closed thespacedoctor closed 1 year ago

thespacedoctor commented 1 year ago

Use the alert data downloaded by gocart to populate event and alert tables in ligo_wave database. Event map data will be matched against the PanSTARRS skycellls and ATLAS footprints.

thespacedoctor commented 1 year ago

The plugin interface is now complete so I am going to write a plugin script gp_alerts_to_db.py to record all incoming alerts into a MySQL DB table (naming the gravity_events table).

thespacedoctor commented 1 year ago

I have changed the name of the ligo_waves database to lvk.
gravity_events table has been replace with and events (a view on alerts) and an alerts table.
Redundant tables that are no longer required have been removed.
Alerts are being imported using the new gp_alerts_to_db.py plugin added the db3 gocart instance.