This action generates JSON diffs for Access Database (accdb) files within the pull request. These diffs can then be used in other steps of your workflow to generate comments, or send alerts, etc.
Here is an example workflow that integrates the access-database-file-diff-action to generate a diff comment for each Access Database file:
name: Generate Access Database diff comments on: pull_request: workflow_dispatch: jobs: process-access-files: runs-on: ubuntu-latest outputs: diffs: ${{ steps.accdb-diff.outputs.accdb-diffs }} steps: - name: Checkout code uses: actions/checkout@v2 with: fetch-depth: 0 - name: Generate Access Database file diffs id: accdb-diff uses: JacksonCougar/access-database-file-diff-action@main create-comments: needs: process-access-files runs-on: ubuntu-latest strategy: matrix: ${{ fromJson(needs.process-access-files.outputs.diffs) }} steps: - name: Generate comment id: add-comment env: comment: "```diff\n${{ matrix.files.text }}\n```" run: | curl -s -H "Authorization: token ${{ secrets.GITHUB_TOKEN }}" \ -X POST -d '{"path": ${{ toJson(matrix.files.name) }}, "position": 0, "body": ${{ toJson(env.comment) }}}' \ "https://api.github.com/repos/${{ github.repository }}/issues/${{ github.event.number }}/comments"There are two outputs returned by access-database-file-diff-action:
has-accdb-files:trueif Access Database files were found.accdb-diffs: a json object that contains the diff information of each Access Database file.
The schema of the json object looks like this:
{ "files": [ { "name": "the filename of the access database file", "text": "the git diff-tool output" }, ] }
