Story #6257

Add public facing database dump, cron job and Arvados upload

Added by Abram Connelly over 6 years ago. Updated about 6 years ago.

Status:
In Progress
Priority:
Normal
Assigned To:
Category:
-
Target version:
-
Start date:
06/29/2015
Due date:
% Done:

100%

Estimated time:
(Total: 0.00 h)
Story points:
-

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.


Subtasks


Related issues

Related to Tapestry - Story #6319: Add API endpoint for backend tablesResolved06/12/2015

History

#1 Updated by Abram Connelly over 6 years ago

  • Status changed from New to In Progress

#2 Updated by Abram Connelly over 6 years ago

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.

#3 Updated by Abram Connelly over 6 years ago

blocks on #6319

Also available in: Atom PDF