[Actions] Updated .github/workflows/reformat-sql.yml #30
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--- # Reformatting MSSQL | |
name: "Standardise: MSSQL Format" | |
on: | |
push: | |
branches-ignore: | |
- "release/*" | |
- "hotfix/*" | |
paths: | |
- '**.sql' | |
- '.github/workflows/reformat-sql.yml' | |
concurrency: | |
group: ${{github.workflow}}-${{github.ref}} | |
cancel-in-progress: true | |
permissions: | |
contents: write | |
jobs: | |
standardise-tsql-files: | |
if: |- | |
github.event.pull_request.draft == false | |
&& ( !startsWith(github.head_ref, 'release/') | |
&& !startsWith(github.head_ref, 'hotfix/') ) | |
&& github.actor != 'dependabot[bot]' | |
runs-on: [self-hosted, linux] | |
steps: | |
- name: "Initialise Workspace" | |
if: startsWith(runner.name, 'buildagent-') | |
shell: bash | |
run: sudo chown -R "$USER:$USER" "$GITHUB_WORKSPACE" | |
- name: "Harden Security" | |
uses: step-security/[email protected] | |
with: | |
egress-policy: audit | |
disable-sudo: true | |
allowed-endpoints: > | |
api.github.com:443 | |
api.osv.dev:443 | |
api.securityscorecards.dev:443 | |
codeload.github.com:443 | |
fulcio.sigstore.dev:443 | |
github.com:443 | |
oss-fuzz-build-logs.storage.googleapis.com:443 | |
rekor.sigstore.dev:443 | |
tuf-repo-cdn.sigstore.dev:443 | |
www.bestpractices.dev:443 | |
- name: "Checkout Source" | |
uses: actions/[email protected] | |
with: | |
fetch-depth: 0 | |
fetch-tags: true | |
token: ${{secrets.SOURCE_PUSH_TOKEN}} | |
- name: "Reformat" | |
uses: credfeto/[email protected] | |
- name: "Commit Changes" | |
uses: stefanzweifel/[email protected] | |
with: | |
commit_message: "[Reformat] SQL Files to common format" | |
file_pattern: "*.sql" | |
commit_user_name: "fun-sqlfmt[bot]" | |
commit_user_email: "[email protected]" | |
commit_author: "fun-sqlfmt[bot] <[email protected]>" | |
skip_dirty_check: false |