Seed v2 database #3
Workflow file for this run
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Seed v2 database | |
| on: | |
| workflow_call: | |
| inputs: | |
| deployment_environment: | |
| description: GitHub environment containing one v2 database target | |
| required: true | |
| type: string | |
| workflow_dispatch: | |
| inputs: | |
| deployment_environment: | |
| description: GitHub environment containing one v2 database target | |
| required: true | |
| type: environment | |
| jobs: | |
| seed: | |
| name: Upgrade schema and seed v2 database | |
| runs-on: ubuntu-latest | |
| timeout-minutes: 30 | |
| environment: ${{ inputs.deployment_environment }} | |
| env: | |
| DEPLOYMENT_ENVIRONMENT: ${{ inputs.deployment_environment }} | |
| V2_SUPABASE_PROJECT_REF: ${{ vars.V2_SUPABASE_PROJECT_REF }} | |
| V2_SUPABASE_ENVIRONMENT: ${{ vars.V2_SUPABASE_ENVIRONMENT }} | |
| PRODUCTION_V2_SUPABASE_PROJECT_REF: ${{ vars.PRODUCTION_V2_SUPABASE_PROJECT_REF }} | |
| steps: | |
| - name: Checkout repo | |
| uses: actions/checkout@v4 | |
| - name: Setup Python | |
| uses: actions/setup-python@v5 | |
| with: | |
| python-version: "3.12" | |
| - name: Setup uv | |
| uses: astral-sh/setup-uv@v6 | |
| - name: Install locked dependencies | |
| run: uv sync --frozen | |
| - name: Verify the database environment is isolated | |
| run: bash .github/scripts/validate_database_environment.sh supabase | |
| - name: Qualify the pending policy migration | |
| run: uv run python scripts/qualify_v2_policy_migration.py | |
| env: | |
| V2_MIGRATION_DATABASE_URL: ${{ secrets.V2_MIGRATION_DATABASE_URL }} | |
| - name: Qualify the pending household migration | |
| run: uv run python scripts/qualify_v2_household_migration.py | |
| env: | |
| V2_MIGRATION_DATABASE_URL: ${{ secrets.V2_MIGRATION_DATABASE_URL }} | |
| - name: Upgrade and verify the v2 schema | |
| run: bash .github/scripts/migrate_v2_metadata_schema.sh | |
| env: | |
| V2_MIGRATION_DATABASE_URL: ${{ secrets.V2_MIGRATION_DATABASE_URL }} | |
| - name: Seed and validate the v2 metadata catalog | |
| run: uv run python scripts/publish_v2_metadata_catalog.py | |
| env: | |
| V2_DATA_WRITE_DATABASE_URL: ${{ secrets.V2_DATA_WRITE_DATABASE_URL }} |