Skip to content

Merge pull request #577 from PAWECOGmbH/staging #9

Merge pull request #577 from PAWECOGmbH/staging

Merge pull request #577 from PAWECOGmbH/staging #9

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 --checksum --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: Generate version and minify on server
uses: appleboy/[email protected]
with:
host: ${{ secrets.PROD_HOST }}
username: ${{ secrets.PROD_USER }}
key: ${{ secrets.PROD_KEY }}
passphrase: ${{ secrets.PROD_KEY_PASS }}
script: |
TIMESTAMP=$(date +%Y%m%d%H%M)
echo "{\"version\":\"$TIMESTAMP\"}" > ${{ secrets.PROD_REMOTE_PATH }}/www/frontend/custom_theme/css/version.json
echo "{\"version\":\"$TIMESTAMP\"}" > ${{ secrets.PROD_REMOTE_PATH }}/www/frontend/custom_theme/js/version.json
docker run --rm \
-v ${{ secrets.PROD_REMOTE_PATH }}/www:/www \
node:18 sh -c "npm install -g csso-cli && \
csso /www/frontend/custom_theme/css/styles.css --output /www/frontend/custom_theme/css/styles.min.css"
docker run --rm \
-v ${{ secrets.PROD_REMOTE_PATH }}/www:/www \
node:18 sh -c "npm install -g terser && \
terser /www/frontend/custom_theme/js/scripts.js --compress --mangle --output /www/frontend/custom_theme/js/scripts.min.js"
- 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 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