plsql-intelligence/.github/workflows/plsql-gate.yml at main · MuhDur/plsql-intelligence · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
# Reference `.github/workflows/plsql-gate.yml` for the release-0.5.0
# change-impact Action.
#
# Unlike `ci.yml` (which gates the *plsql-intelligence repository itself*),
# this file is the canonical GitHub Actions reference workflow that a
# downstream PL/SQL consumer copies into their own repository to comment
# on PRs touching PL/SQL with the `plsql predict --robot-json` blast radius.
#
# Maintenance note: this file is NOT enabled in this repo (we have no
# PL/SQL code of our own to gate). It exists at this path so a Dependabot-
# style integration can mirror it. Use `examples/ci/github-actions.yml`
# for the annotated walkthrough version.

name: plsql-gate

on:
  pull_request:
    paths:
      - "**/*.sql"
      - "**/*.pks"
      - "**/*.pkb"
      - "**/*.tps"
      - "**/*.tpb"
      - "**/*.trg"
      - "**/*.vw"

permissions:
  contents: read
  issues: write
  pull-requests: read

jobs:
  change-impact:
    name: PL/SQL change impact
    runs-on: ubuntu-latest
    if: ${{ false }}   # reference-only — flip to `true` after dropping
                       # into a downstream repository.
    steps:
      - uses: actions/checkout@v4
        with:
          fetch-depth: 0

      - name: Install plsql CLI (released)
        run: curl -fsSL https://example.invalid/install.sh | bash -s -- --version 0.x

      - name: Predict and comment on PL/SQL blast radius
        id: impact
        uses: ./.github/actions/plsql-change-impact
        with:
          plsql-bin: plsql
          git-range: ${{ github.event.pull_request.base.sha }}..${{ github.sha }}
          mode: catalog-aware
          github-token: ${{ secrets.GITHUB_TOKEN }}

      - name: Upload reports
        if: always()
        uses: actions/upload-artifact@v4
        with:
          name: plsql-cicd-reports
          path: |
            ${{ steps.impact.outputs.predict-json }}
            ${{ steps.impact.outputs.comment-body }}
          if-no-files-found: error