Set entity columns to be 'timestamp with time zone' to avoid TZ-relat… #150
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: Build dbschema if needed | |
| on: | |
| workflow_dispatch: | |
| push: | |
| branches: | |
| - main | |
| paths: | |
| - "database/migrations/**" | |
| jobs: | |
| update-docs-dbschema: | |
| runs-on: ubuntu-latest | |
| permissions: write-all | |
| steps: | |
| # Checkout your project with git | |
| - name: Checkout | |
| uses: actions/checkout@eef61447b9ff4aafe5dcd4e0bbf5d482be7e7871 # v4.2.1 | |
| # generate db schema | |
| - name: Generate db schema | |
| run: make dbschema | |
| - name: Extract Commit SHA and Details | |
| id: extract_commit_details | |
| run: | | |
| COMMIT_SHA="${{ github.sha }}" | |
| COMMIT_DATE=$(git show -s --format=%cd --date=format:'%Y-%m-%d %H:%M:%S' $commit_sha) | |
| COMMIT_AUTHOR=$(git show -s --format='%an' $commit_sha) | |
| echo "commit_sha=$COMMIT_SHA" >> $GITHUB_OUTPUT | |
| echo "commit_date=$COMMIT_DATE" >> $GITHUB_OUTPUT | |
| echo "commit_author=$COMMIT_AUTHOR" >> $GITHUB_OUTPUT | |
| - name: Commit and push changes | |
| uses: peter-evans/create-pull-request@5e914681df9dc83aa4e4905692ca88beb2f9e91f # v7.0.5 | |
| with: | |
| commit-message: Update DB schema | |
| committer: GitHub <[email protected]> | |
| author: ${{ github.actor }} <${{ github.actor }}@users.noreply.github.com> | |
| signoff: false | |
| branch-suffix: timestamp | |
| delete-branch: true | |
| title: "Auto-generated DB schema update - ${{ steps.extract_commit_details.outputs.commit_date }}" | |
| body: | | |
| ** Source commit ** | |
| - Commit SHA: [${{ steps.extract_commit_details.outputs.commit_sha }}](${{ github.server_url }}/${{ github.repository }}/commit/${{ steps.extract_commit_details.outputs.commit_sha}}) | |
| - Date: ${{ steps.extract_commit_details.outputs.commit_date }} | |
| - Author: ${{ steps.extract_commit_details.outputs.commit_author }} | |
| labels: | | |
| docs | |
| automated pr | |
| draft: false |