Create DBApps method to update the processing db works

buda-base / drs-deposit

Harvard DRS Deposit base

1 stars 0 forks source link

Create DBApps method to update the processing db works #98

Closed jimk-bdrc closed 3 years ago

jimk-bdrc commented 3 years ago

Add the sync date to the works table - existing works get an 'epoch start date' of 1/1/2020.

jimk-bdrc commented 3 years ago

subtask: create the 'processing'.'Works' table if not there. Columns: workId - auto increment in workName - text VolumeName-text size file_count sync_date: Date (don't bother with DATETIME)

jimk-bdrc commented 3 years ago

I wonder if you can reference tables in a different database?

TBRC-TimB commented 3 years ago

see https://github.com/buda-base/archive-ops/issues/221 related issue

TBRC-Travis commented 3 years ago

In terms of scope of what gets tracked it would be great if we could update the processing database for each step of our syncing/distribution process. This would include distinct updates for when a volume is synced to:

Amazon S3 (web images)
RS5 Archive
Internet Archive
DRS

This would make it easy to query which works have reached our various archival endpoints.

jimk-bdrc commented 3 years ago

Defer, but move this work into DRS, where the migration audit logs will be put.

TBRC-TimB commented 3 years ago

fixed in https://github.com/buda-base/archive-ops/pull/342