Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update DB Schema for Gains #1524

Open
Tracked by #1508
manasaV3 opened this issue Jan 24, 2025 · 0 comments
Open
Tracked by #1508

Update DB Schema for Gains #1524

manasaV3 opened this issue Jan 24, 2025 · 0 comments
Labels
backend P1 Should have

Comments

@manasaV3
Copy link
Contributor

manasaV3 commented Jan 24, 2025

Blocked by: #1516

Task

We should add the checksum field to gains table

DB schema

Name Status Data type Nullable Defaults
checksum New string true  
id   int false Auto Increment
https_file_path   string false  
run_id   int false  
s3_file_path   string false  

Metadata mapping

The checksum value should be pulled from the s3 checksum tag for the file

What done looks like?

The api has been updated to reflect the gain checksum, and data can be populated for all the gains.checksum field.

Notes

  1. https://github.com/chanzuckerberg/cryoet-data-portal-backend/tree/main/apiv2
  2. https://docs.aws.amazon.com/AmazonS3/latest/API/API_Checksum.html
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
backend P1 Should have
Projects
None yet
Development

No branches or pull requests

1 participant