Skip to content

Update to latest sql_saga with schema support #1

Update to latest sql_saga with schema support

Update to latest sql_saga with schema support #1

name: Release Migrations
on:
push:
branches:
- develop
jobs:
build:
runs-on: [self-hosted, linux]
timeout-minutes: 15
permissions:
id-token: write
contents: read
steps:
- name: Checkout Repo
uses: actions/checkout@v2
- name: Merging migration files
run: cat $(ls -1) > ../migration-output.sql
working-directory: ${{ github.workspace }}/migrations/db/migrations
- name: configure aws credentials - staging
uses: aws-actions/configure-aws-credentials@v1
with:
role-to-assume: ${{ secrets.DEV_AWS_ROLE }}
aws-region: "ap-southeast-1"
- name: Deploy to S3 staging
shell: bash
run: aws s3 sync migrations/db s3://$AWS_S3_BUCKET/migrations/db --delete
env:
AWS_S3_BUCKET: ${{ secrets.PG_INIT_SCRIPT_S3_BUCKET_STAGING }}
- name: configure aws credentials - prod
uses: aws-actions/configure-aws-credentials@v1
with:
role-to-assume: ${{ secrets.PROD_AWS_ROLE }}
aws-region: "ap-southeast-1"
- name: Deploy to S3 prod
shell: bash
run: aws s3 sync migrations/db s3://$AWS_S3_BUCKET/migrations/db --delete
env:
AWS_S3_BUCKET: ${{ secrets.PG_INIT_SCRIPT_S3_BUCKET_PROD }}