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

DB update workflow change PROD DB schema from main branch #703

Open
davidgamez opened this issue Aug 20, 2024 · 1 comment
Open

DB update workflow change PROD DB schema from main branch #703

davidgamez opened this issue Aug 20, 2024 · 1 comment
Assignees
Labels
bug Something isn't working

Comments

@davidgamez
Copy link
Member

Description

Currently, the DB update workflow get dispatched by add feeds operations on the catalog repository. This action updates the DB schema to the latest main schema. The side effect is that we release DB changes without its Python-supported code. Luckily, there hasn't been any issue until now, as we have been making backward-compatible changes. However, this is a high-risk situation that can lead to PROD issues.

Proposed solution

Migrate the DB update workflow to a cloud function. The cloud function can be triggered by an event or direct call from a workflow.

@davidgamez davidgamez changed the title DB update workflow update PROD DB schema from main branch DB update workflow change PROD DB schema from main branch Aug 20, 2024
@davidgamez davidgamez added the bug Something isn't working label Aug 20, 2024
@jcpitre
Copy link
Contributor

jcpitre commented Sep 3, 2024

Tasks:

  • Create cloud functions with the populate script GBFS and GTFS
  • Unit tests for cloud function
  • Update or create terraform script for deployment
  • Update the Github action to call the function

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants