bytebase-check-release.yml

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

jobs:
  bytebase-cicd:
    runs-on: ubuntu-latest
    env:
      BYTEBASE_URL: 'https://6ef3-62-192-175-167.ngrok-free.app'
      BYTEBASE_PROJECT: 'projects/db333'
      BYTEBASE_SERVICE_ACCOUNT: 'cicd_srv@service.bytebase.com'
      BYTEBASE_TARGETS: 'instances/dbdbdb/databases/db_1,instances/dbdbdb/databases/db_101,instances/dbdbdb/databases/db_103'
      FILE_PATTERN: 'migrations/*.sql'
    name: Bytebase cicd
    steps:
      - name: Checkout
        uses: actions/checkout@v4
      - name: Login to Bytebase
        id: login
        uses: bytebase/login-action@main
        with:
          bytebase-url: ${{ env.BYTEBASE_URL }}
          service-key: ${{ env.BYTEBASE_SERVICE_ACCOUNT }}
          service-secret: ${{ secrets.BYTEBASE_PASSWORD }}
      - name: sql review
        id: sql_review
        uses: bytebase/create-release-action@v1
        with:
          url: ${{ env.BYTEBASE_URL }}
          token: ${{ steps.login.outputs.token }}
          project: ${{ env.BYTEBASE_PROJECT }}
          file-pattern: ${{ env.FILE_PATTERN }}
          # fail the action if release checks report any error.
          check-release: 'FAIL_ON_ERROR'
          targets: ${{ env.BYTEBASE_TARGETS }}
          validate-only: true