sql-review-action.yml

name: SQL review on pull request using bytebase-action image

on:
  pull_request:
    branches:
      - main
    paths:
      - "migrations-semver/*.sql"

jobs:
  check-release-on-prod:
    permissions:
        pull-requests: write # write permission required to allow the action writes the check results to the comment.
    runs-on: [self-hosted, k8s, bytebase]
    container:
      image: docker://bytebase/bytebase-action:latest
    steps:
      - name: Checkout
        uses: actions/checkout@v4
      - name: Check release
        env:
            G_TOKEN: ${{ secrets.G_TOKEN }}
            BYTEBASE_URL: ${{ secrets.BYTEBASE_URL }}
            BYTEBASE_SERVICE_ACCOUNT: ${{ secrets.BYTEBASE_SERVICE_ACCOUNT }}
            BYTEBASE_SERVICE_ACCOUNT_SECRET: ${{ secrets.BYTEBASE_SERVICE_ACCOUNT_SECRET }}
            BYTEBASE_PROJECT: "projects/bcas-dev"
            BYTEBASE_TARGETS: "instances/dbdev-1b-bcas/databases/dbdev-vkyc-1b-bcas"
            FILE_PATTERN: "migrations-semver/*.sql"
        run: |
          bytebase-action check --url=${{ env.BYTEBASE_URL }} --project=${{ env.BYTEBASE_PROJECT }} --targets=${{ env.BYTEBASE_TARGETS }} --file-pattern=${{ env.FILE_PATTERN }}