ci(migration-sql): checkout base commit to figure out the base revision #33
Workflow file for this run
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: Migration as SQL | |
| on: | |
| pull_request: | |
| paths: | |
| - alembic/versions/** | |
| permissions: | |
| # To post the migration SQL as a PR comment | |
| pull-requests: write | |
| defaults: | |
| run: | |
| shell: bash | |
| jobs: | |
| comment: | |
| permissions: | |
| pull-requests: write | |
| runs-on: ubuntu-24.04 | |
| steps: | |
| - name: Checkout (base) | |
| uses: actions/checkout@692973e3d937129bcbf40652eb9f2f61becf3332 # v4.1.7 | |
| with: | |
| ref: ${{ github.event.pull_request.base.sha }} | |
| - name: Setup PDM | |
| uses: pdm-project/setup-pdm@568ddd69406b30de1774ec0044b73ae06e716aa4 # v4 | |
| with: | |
| python-version: '3.12' | |
| cache: true | |
| - name: Install dependencies (base) | |
| run: pdm install --dev | |
| - name: Get the base migration revision | |
| run: | | |
| #!/usr/bin/env bash | |
| set -euo pipefail | |
| base_head="$(pdm run alembic heads | awk '{printf $1}')" | |
| if [ "$(echo base_head | wc -l)" -gt 1 ]; then | |
| echo >&2 'Multiple heads are not supported' | |
| exit 1 | |
| fi | |
| echo "Base migration revision: ${base_head}" | |
| echo "BASE_MIGRATION_REVISION=${base_head}" >>"${GITHUB_ENV}" | |
| - name: Checkout (head) | |
| uses: actions/checkout@692973e3d937129bcbf40652eb9f2f61becf3332 # v4.1.7 | |
| with: | |
| ref: ${{ github.event.pull_request.head.sha }} | |
| - name: Install dependencies (head) | |
| run: pdm install --dev | |
| - name: Generate SQL | |
| id: sql | |
| run: | | |
| #!/usr/bin/env bash | |
| set -euo pipefail | |
| base="${BASE_MIGRATION_REVISION}" | |
| # `alembic upgrade --sql` outputs the SQL to stdout, and the logs to stderr | |
| pdm run alembic upgrade --sql "${base}:head" >up.sql 2>up.log | |
| EOF="$(dd if=/dev/urandom bs=15 count=1 status=none | base64)" | |
| echo UP_MIGRATION<<${EOF} >>"${GITHUB_ENV}" | |
| $(cat up.log up.sql) | |
| ${EOF} | |
| # `alembic downgrade --sql` outputs the SQL to stdout, and the logs to stderr | |
| pdm run alembic downgrade --sql "head:${base}" >down.sql 2>down.log | |
| EOF="$(dd if=/dev/urandom bs=15 count=1 status=none | base64)" | |
| echo DOWN_MIGRATION<<${EOF} >>"${GITHUB_ENV}" | |
| $(cat down.log down.sql) | |
| ${EOF} | |
| - name: Comment on PR | |
| uses: actions/github-script@60a0d83039c74a4aee543508d2ffcb1c3799cdea # 7.0.1 | |
| with: | |
| script: |- | |
| "use strict"; | |
| const up_migration = process.env.UP_MIGRATION; | |
| const down_migration = process.env.DOWN_MIGRATION; | |
| const comment = ` | |
| ### \`alembic upgrade --sql $base:head\` | |
| \`\`\`sql | |
| ${up_migration} | |
| \`\`\` | |
| ### \`alembic downgrade --sql head:$base\` | |
| \`\`\`sql | |
| ${down_migration} | |
| \`\`\` | |
| `; | |
| github.rest.issues.createComment({ | |
| issue_number: context.issue.number, | |
| owner: context.repo.owner, | |
| repo: context.repo.repo, | |
| body: comment, | |
| }); |