added migration logic in cd workflow #7
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: build-and-deployment | |
| on: | |
| push: | |
| branches: | |
| - feature/10-continuous-deployment-for-gen2-function | |
| # - main | |
| jobs: | |
| deploy-staging: | |
| runs-on: ubuntu-latest | |
| if: github.ref == 'refs/heads/feature/10-continuous-deployment-for-gen2-function' | |
| steps: | |
| - uses: 'actions/checkout@v3' | |
| - run: ls | |
| - id: 'auth' | |
| name: 'Authenticate to Google Cloud' | |
| uses: 'google-github-actions/auth@v1' | |
| with: | |
| credentials_json: '${{ secrets.GCP_CREDENTIALS }}' | |
| - name: Debug GCP credentials | |
| env: | |
| GOOGLE_APPLICATION_CREDENTIALS: ${{ secrets.GCP_CREDENTIALS }} | |
| run: | | |
| echo "$GOOGLE_APPLICATION_CREDENTIALS" > credentials.json | |
| - name: 'Set up Cloud SDK' | |
| uses: 'google-github-actions/setup-gcloud@v1' | |
| with: | |
| version: '>= 363.0.0' | |
| - name: 'Use gcloud CLI' | |
| run: 'gcloud info' | |
| - name: Install Python dependencies | |
| run: | | |
| pip install -r requirements.txt | |
| - name: Set up Cloud SQL Proxy | |
| run: | | |
| wget https://dl.google.com/cloudsql/cloud_sql_proxy.linux.amd64 -O cloud_sql_proxy | |
| chmod +x cloud_sql_proxy | |
| - name: Start Cloud SQL Proxy | |
| env: | |
| GOOGLE_APPLICATION_CREDENTIALS: ${{ secrets.GCP_CREDENTIALS }} | |
| run: | | |
| echo "$GOOGLE_APPLICATION_CREDENTIALS" > credentials.json | |
| ./cloud_sql_proxy -instances=${{ secrets.CONNECTION_NAME_GITHUB_ACTION }}=tcp:5432 -credential_file=credentials.json & | |
| - name: Run Flask Migration | |
| env: | |
| SQLALCHEMY_DATABASE_URI_GITHUB_ACTION: ${{ secrets.SQLALCHEMY_DATABASE_URI }} | |
| FLASK_APP: ${{ secrets.FLASK_APP }} | |
| FLASK_ENV: ${{ secrets.FLASK_APP_STAGING }} | |
| run: | | |
| flask db upgrade | |
| - name: Stop Cloud SQL Proxy | |
| run: | | |
| pkill cloud_sql_proxy | |
| - name: 'Deploy a gen 2 cloud function' | |
| run: | | |
| gcloud functions deploy whatsapp-webhook-analytics-staging \ | |
| --gen2 \ | |
| --runtime=python312 \ | |
| --region=asia-south1 \ | |
| --trigger-http \ | |
| --entry-point=handle_payload \ | |
| --memory=256MB \ | |
| --timeout=30s \ | |
| --set-env-vars=FLASK_APP=${{ secrets.FLASK_APP_STAGING }},DB_USER=${{ secrets.DB_USER }},DB_PASSWORD=${{ secrets.DB_PASSWORD }},DB_NAME=${{ secrets.DB_NAME }},DB_PORT=${{ secrets.DB_PORT }},CONNECTION_NAME=${{ secrets.CONNECTION_NAME }},LOGGING_LEVEL=${{ secrets.LOGGING_LEVEL }} | |
| # deploy-production: | |
| # runs-on: ubuntu-latest | |
| # if: github.ref == 'refs/heads/main' | |
| # steps: | |
| # - uses: 'actions/checkout@v3' | |
| # - run: ls | |
| # - id: 'auth' | |
| # name: 'Authenticate to Google Cloud' | |
| # uses: 'google-github-actions/auth@v1' | |
| # with: | |
| # credentials_json: '${{ secrets.GCP_CREDENTIALS }}' | |
| # - name: Debug GCP credentials | |
| # env: | |
| # GOOGLE_APPLICATION_CREDENTIALS: ${{ secrets.GCP_CREDENTIALS }} | |
| # run: | | |
| # echo "$GOOGLE_APPLICATION_CREDENTIALS" > credentials.json | |
| # - name: 'Set up Cloud SDK' | |
| # uses: 'google-github-actions/setup-gcloud@v1' | |
| # with: | |
| # version: '>= 363.0.0' | |
| # - name: 'Use gcloud CLI' | |
| # run: 'gcloud info' | |
| # - name: Install Python dependencies | |
| # run: | | |
| # pip install -r requirements.txt | |
| # - name: 'Deploy a gen 2 cloud function' | |
| # run: | | |
| # gcloud functions deploy admindashboard-webhook-queue-service-prod \ | |
| # --gen2 \ | |
| # --runtime=python312 \ | |
| # --region=asia-south1 \ | |
| # --trigger-http \ | |
| # --entry-point=handle_payload \ | |
| # --memory=256MB \ | |
| # --timeout=30s \ | |
| # --set-env-vars=FLASK_APP=${{ secrets.FLASK_APP_STAGING }},DB_USER=${{ secrets.DB_USER }},DB_PASSWORD=${{ secrets.DB_PASSWORD }},DB_NAME=${{ secrets.DB_NAME }},DB_PORT=${{ secrets.DB_PORT }},CONNECTION_NAME=${{ secrets.CONNECTION_NAME }},LOGGING_LEVEL=${{ secrets.LOGGING_LEVEL }} |