generate.yaml

name: Generate PostgreSQL Error Codes

on:
  schedule:
    - cron:  '0 0 * * *'
  workflow_dispatch:

jobs:
  run:
    runs-on: ubuntu-latest

    steps:
      - name: Setup PHP
        uses: shivammathur/setup-php@v2
        with:
          php-version: '8.4'

      - name: Checkout
        uses: actions/checkout@v4

      - name: Generate PostgreSQL Error Codes
        uses: nick-fields/retry@v3
        with:
          timeout_seconds: 60
          max_attempts: 3
          command: make

      - name: Syntax check
        run: php -l -n -d error_reporting=E_ALL ./src/PostgresError.php

      - name: Create Pull Request
        uses: peter-evans/create-pull-request@v6
        with:
          commit-message: Update Error Code
          delete-branch: true
          title: Update Error Code
          body: |
            Error codes have been updated.

            - https://github.com/postgres/postgres/blob/master/src/backend/utils/errcodes.txt