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

SPIKE: FTA to RST schema import - rework to update rows in existing database #325

Open
3 tasks
BAAlexK opened this issue Feb 4, 2025 · 0 comments
Open
3 tasks
Assignees

Comments

@BAAlexK
Copy link
Contributor

BAAlexK commented Feb 4, 2025

Describe the task
We want to avoid the PROD database being shut down when we update data. Investigate how we can do this, and how we can avoid wiping test every time we deploy to PROD.

There may be an overlap with people using both systems and data being updated in our system and FTA as we transition away from FTA being source of truth.

Acceptance Criteria

Additional context

  • can maybe do automation on migration - need to research and do some testing
  • consider switching to prisma (not currently using for migrations) from flyaway
  • Looking for UPSERT functionality, SQL has INSERT ... ON CONFLICT
  • want to update the rows that have had changes
@BAAlexK BAAlexK changed the title SPIKE: SPIKE: FTA to RST schema import - rework to update rows in existing database Feb 4, 2025
@BAAlexK BAAlexK assigned imsunchips and unassigned imsunchips Feb 6, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: Todo
Development

No branches or pull requests

4 participants