Idea #6257
open
Add public facing database dump, cron job and Arvados upload
Added by Abram Connelly over 9 years ago.
Updated over 9 years ago.
Description
There is code to do a dump of the public facing data. Merge it into Tapestry, create a cron job to automatically run on a daily basis and have it upload to an Arvados project.
- Status changed from New to In Progress
After speaking with Tom, the first step in this is to create a RESTful API interface for access points to the various tables for download. For example, something like:
my.pgp-hms.org/download/user.tsv
my.pgp-hms.org/download/user_files.tsv
my.pgp-hms.org/download/medications.tsv
Once that API is in place, a script can remotely download the relevant tables, collect results and create a stand alone SQLite database, say.
Also available in: Atom
PDF