Auto updated backup.sql. #578
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: CI | |
on: | |
push: | |
branches: | |
- main | |
pull_request: | |
branches: | |
- main | |
jobs: | |
shellcheck: | |
name: Run shellcheck | |
runs-on: ubuntu-latest | |
steps: | |
- name: Checkout | |
uses: actions/checkout@v4 | |
- name: shellcheck | |
uses: reviewdog/[email protected] | |
test-postgresql: | |
name: Test pg_dump with PostgreSQL version | |
runs-on: ubuntu-latest | |
strategy: | |
fail-fast: false | |
matrix: | |
postgresql_version: [12, 14, 15] | |
services: | |
postgres: | |
image: postgres:${{ matrix.postgresql_version }} | |
env: | |
POSTGRES_USER: test_user | |
POSTGRES_PASSWORD: test_user_password | |
POSTGRES_DB: testdb | |
ports: | |
- 5432:5432 | |
# needed because the postgres container does not provide a healthcheck | |
options: --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5 | |
steps: | |
- name: Checkout | |
uses: actions/checkout@v4 | |
with: | |
fetch-depth: 0 | |
persist-credentials: false # otherwise, the token used is the GITHUB_TOKEN, instead of your personal token | |
- name: Run pg_dump | |
uses: ./ | |
with: | |
database_url: "postgres://test_user:test_user_password@localhost:5432/testdb" | |
postgresql_version: ${{ matrix.postgresql_version }} | |
path: "backups/${{ matrix.postgresql_version }}/backup.sql" | |
- name: Check changes to the backup file. | |
id: changed_backup | |
if: matrix.platform == 'ubuntu-latest' | |
uses: tj-actions/verify-changed-files@v20 | |
with: | |
files: backups/${{ matrix.postgresql_version }}/backup.sql | |
- name: Commit changes to backup file. | |
if: steps.changed_backup.outputs.files_changed == 'true' && matrix.platform == 'ubuntu-latest' | |
run: | | |
git config --local user.email "github-actions[bot]@users.noreply.github.com" | |
git config --local user.name "github-actions[bot]" | |
git add backups/${{ matrix.postgresql_version }}/backup.sql | |
git commit -m "Auto updated backup.sql." | |
- name: Push changes | |
if: steps.changed_backup.outputs.files_changed == 'true' && matrix.platform == 'ubuntu-latest' | |
uses: ad-m/github-push-action@master | |
with: | |
github_token: ${{ secrets.PAT_TOKEN }} | |
branch: ${{ github.head_ref }} | |
test: | |
runs-on: ubuntu-latest | |
name: Test pg_dump | |
services: | |
postgres: | |
image: postgres:9.6.24 | |
env: | |
POSTGRES_USER: test_user | |
POSTGRES_PASSWORD: test_user_password | |
POSTGRES_DB: testdb | |
ports: | |
- 5432:5432 | |
# needed because the postgres container does not provide a healthcheck | |
options: --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5 | |
steps: | |
- name: Checkout | |
uses: actions/checkout@v4 | |
with: | |
fetch-depth: 0 # otherwise, you will failed to push refs to dest repo | |
persist-credentials: false # otherwise, the token used is the GITHUB_TOKEN, instead of your personal token | |
- name: Run pg_dump | |
uses: ./ | |
with: | |
database_url: "postgres://test_user:test_user_password@localhost:5432/testdb" | |
path: "backups/backup.sql" | |
- name: Check changes to backup file. | |
id: changed_backup | |
uses: tj-actions/verify-changed-files@v20 | |
with: | |
files: backups/backup.sql | |
- name: Commit changes to backup file. | |
if: steps.changed_backup.outputs.files_changed == 'true' | |
run: | | |
git config --local user.email "github-actions[bot]@users.noreply.github.com" | |
git config --local user.name "github-actions[bot]" | |
git add backups/backup.sql | |
git commit -m "Auto updated backup.sql." | |
- name: Push changes | |
if: steps.changed_backup.outputs.files_changed == 'true' | |
uses: ad-m/github-push-action@master | |
with: | |
github_token: ${{ secrets.PAT_TOKEN }} | |
branch: ${{ github.head_ref }} |