Skip to content

Merge pull request #573 from PAWECOGmbH/staging #7

Merge pull request #573 from PAWECOGmbH/staging

Merge pull request #573 from PAWECOGmbH/staging #7

name: Deploy and Run Flyway Migrations production
on:
push:
branches:
- production
jobs:
deploy_and_migrate:
runs-on: ubuntu-22.04
steps:
- name: Checkout the repository
uses: actions/checkout@v4
- name: Deploy to server via rsync
uses: Burnett01/[email protected]
with:
switches: -avzr --delete --exclude-from='.gitignore' --exclude='/config/nginx/conf.d/custom.conf'
path: ./
remote_path: ${{ secrets.PROD_REMOTE_PATH }}
remote_host: ${{ secrets.PROD_HOST }}
remote_user: ${{ secrets.PROD_USER }}
remote_key: ${{ secrets.PROD_KEY }}
remote_key_pass: ${{ secrets.PROD_KEY_PASS }}
- name: Run Flyway Migrations core
uses: appleboy/[email protected]
with:
host: ${{ secrets.PROD_HOST }}
username: ${{ secrets.PROD_USER }}
key: ${{ secrets.PROD_KEY }}
passphrase: ${{ secrets.PROD_KEY_PASS }}
script: |
docker run --rm \
--network npm_network \
--volume ${{ secrets.PROD_REMOTE_PATH }}/config/db/core:/flyway/core:ro \
-e FLYWAY_URL="${{ secrets.PROD_DB_URL }}" \
-e FLYWAY_USER="${{ secrets.PROD_DB_USER }}" \
-e FLYWAY_PASSWORD="${{ secrets.PROD_DB_PASSWORD }}" \
flyway/flyway -locations=filesystem:/flyway/core -table=flyway_core migrate
- name: Run Flyway Migrations myapp
uses: appleboy/[email protected]
with:
host: ${{ secrets.PROD_HOST }}
username: ${{ secrets.PROD_USER }}
key: ${{ secrets.PROD_KEY }}
passphrase: ${{ secrets.PROD_KEY_PASS }}
script: |
docker run --rm \
--network npm_network \
--volume ${{ secrets.PROD_REMOTE_PATH }}/config/db/myapp:/flyway/myapp:ro \
-e FLYWAY_URL="${{ secrets.PROD_DB_URL }}" \
-e FLYWAY_USER="${{ secrets.PROD_DB_USER }}" \
-e FLYWAY_PASSWORD="${{ secrets.PROD_DB_PASSWORD }}" \
flyway/flyway -locations=filesystem:/flyway/myapp -table=flyway_myapp migrate