acceptance-to-test.yaml

name: Copy CMS content from acceptance to test

on:
    workflow_dispatch:

jobs:
    copy-db:
        environment: copy
        runs-on: ubuntu-latest
        container:
            image: postgres:16
        steps:
            -   name: pg_dump
                env:
                    PGPASSWORD: ${{ secrets.DB_PASSWORD_ACCEPTANCE }}
                run: >
                    pg_dump
                    --username=holon-acceptance
                    --no-privileges
                    --no-owner
                    --host=postgres.zenmo.com
                    --exclude-table=holon_cache
                    --dbname=holon-acceptance
                    --format=custom
                    --file=acceptance.pg_dump
            -   name: pg_restore
                env:
                    PGPASSWORD: ${{ secrets.DB_PASSWORD_TEST }}
                run: >
                    pg_restore
                    --username=holon-test
                    --clean
                    --no-owner
                    --no-privileges
                    --host=postgres.zenmo.com
                    --dbname=holon-test
                    acceptance.pg_dump