build(database): deploy migrations in the ci #1
Workflow file for this run
This file contains 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: Deploy database migration | |
| on: | |
| pull_request: # TODO to be removed | |
| branches: | |
| - 'main' | |
| paths: | |
| - 'packages/domain/prisma/migrations/**' | |
| push: | |
| branches: | |
| - 'main' | |
| paths: | |
| - 'packages/domain/prisma/migrations/**' | |
| jobs: | |
| apply-migration: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Setup pscale | |
| uses: planetscale/setup-pscale-action@v1 | |
| - name: Set database branch name | |
| run: echo "PSCALE_BRANCH_NAME=$(echo ${{ github.head_ref }} | tr -cd '[:alnum:]-'| tr '[:upper:]' '[:lower:]')" >> $GITHUB_ENV | |
| - name: Get the deploy request number in development branch | |
| env: | |
| PLANETSCALE_SERVICE_TOKEN_ID: ${{ secrets.PLANETSCALE_SERVICE_TOKEN_ID }} | |
| PLANETSCALE_SERVICE_TOKEN: ${{ secrets.PLANETSCALE_SERVICE_TOKEN }} | |
| run: | | |
| DEV_DEPLOY_REQUEST_NUMBER=$(pscale deploy-request show ${{ secrets.PLANETSCALE_DATABASE_NAME }} ${{ env.PSCALE_BRANCH_NAME }} --org ${{ secrets.PLANETSCALE_ORG_NAME }} -f json | jq -r '.number') | |
| echo "DEV_DEPLOY_REQUEST_NUMBER=$DEV_DEPLOY_REQUEST_NUMBER" >> $GITHUB_ENV | |
| - name: Check deployment state | |
| continue-on-error: false | |
| env: | |
| PLANETSCALE_SERVICE_TOKEN_ID: ${{ secrets.PLANETSCALE_SERVICE_TOKEN_ID }} | |
| PLANETSCALE_SERVICE_TOKEN: ${{ secrets.PLANETSCALE_SERVICE_TOKEN }} | |
| run: | | |
| for i in {1..10}; do | |
| DEPLOYMENT_STATE=$(pscale deploy-request show ${{ secrets.PLANETSCALE_DATABASE_NAME }} ${{ env.DEV_DEPLOY_REQUEST_NUMBER }} --org ${{ secrets.PLANETSCALE_ORG_NAME }} -f json | jq -r '.deployment_state') | |
| echo "Deployment State: $DEPLOYMENT_STATE" | |
| if [ "$DEPLOYMENT_STATE" = "ready" ]; then | |
| echo "Deployment state is ready. Continuing." | |
| echo "DEPLOY_REQUEST_OPENED=true" >> $GITHUB_ENV | |
| break | |
| fi | |
| echo "Deployment state is not ready. Waiting 2 seconds before checking again." | |
| sleep 2 | |
| done | |
| - name: Deploy schema migration in the development branch | |
| continue-on-error: false | |
| env: | |
| PLANETSCALE_SERVICE_TOKEN_ID: ${{ secrets.PLANETSCALE_SERVICE_TOKEN_ID }} | |
| PLANETSCALE_SERVICE_TOKEN: ${{ secrets.PLANETSCALE_SERVICE_TOKEN }} | |
| run: | | |
| pscale deploy-request deploy ${{ secrets.PLANETSCALE_DATABASE_NAME }} ${{ env.DEV_DEPLOY_REQUEST_NUMBER }} --org ${{ secrets.PLANETSCALE_ORG_NAME }} --wait | |
| - name: Deploy schema migration in the production branch | |
| if: ${{ success() }} | |
| continue-on-error: false | |
| env: | |
| PLANETSCALE_SERVICE_TOKEN_ID: ${{ secrets.PLANETSCALE_SERVICE_TOKEN_ID }} | |
| PLANETSCALE_SERVICE_TOKEN: ${{ secrets.PLANETSCALE_SERVICE_TOKEN }} | |
| run: | | |
| pscale deploy-request create ${{ secrets.PLANETSCALE_DATABASE_NAME }} ${{ env.PSCALE_BRANCH_NAME }} \ | |
| --into main \ | |
| --notes "Apply changes to the production branch" | |
| PROD_DEPLOY_REQUEST_NUMBER=$(pscale deploy-request show ${{ secrets.PLANETSCALE_DATABASE_NAME }} ${{ env.PSCALE_BRANCH_NAME }} --org ${{ secrets.PLANETSCALE_ORG_NAME }} -f json | jq -r '.number') | |
| for i in {1..10}; do | |
| DEPLOYMENT_STATE=$(pscale deploy-request show ${{ secrets.PLANETSCALE_DATABASE_NAME }} $PROD_DEPLOY_REQUEST_NUMBER --org ${{ secrets.PLANETSCALE_ORG_NAME }} -f json | jq -r '.deployment_state') | |
| echo "Deployment State: $DEPLOYMENT_STATE" | |
| if [ "$DEPLOYMENT_STATE" = "ready" ]; then | |
| echo "Deployment state is ready. Continuing." | |
| break | |
| fi | |
| echo "Deployment state is not ready. Waiting 2 seconds before checking again." | |
| sleep 2 | |
| done | |
| pscale deploy-request deploy ${{ secrets.PLANETSCALE_DATABASE_NAME }} $PROD_DEPLOY_REQUEST_NUMBER --org ${{ secrets.PLANETSCALE_ORG_NAME }} --wait | |
| - name: Delete the database branch | |
| if: ${{ success() }} | |
| env: | |
| PLANETSCALE_SERVICE_TOKEN_ID: ${{ secrets.PLANETSCALE_SERVICE_TOKEN_ID }} | |
| PLANETSCALE_SERVICE_TOKEN: ${{ secrets.PLANETSCALE_SERVICE_TOKEN }} | |
| run: | | |
| pscale branch delete ${{ secrets.PLANETSCALE_DATABASE_NAME }} ${{ env.PSCALE_BRANCH_NAME }} --org ${{ secrets.PLANETSCALE_ORG_NAME }} --force | |
| echo "The branch \"${{ env.PSCALE_BRANCH_NAME }}\" has been successfully." |