autoformatter.yml

name: SQL Formatting

on:
  push:
    branches:
      - main  # Adjust the branch name as needed
      
permissions:
   contents: write

jobs:
  format:
    runs-on: ubuntu-latest

    steps:
      - name: Checkout repository
        uses: actions/checkout@v4

      - name: Install Node.js
        uses: actions/setup-node@v4
        with:
          node-version: 14

      - name: Install dependencies
        run: npm install sql-formatter prettier

      - name: Format SQL files
        run: npx sql-formatter --overwrite '**/*.sql' && npx prettier --write '**/*.sql'


# name: "Formatting queries"
# on: # rebuild any PRs and master branch changes
#     pull_request:
#     push:
#         branches:
#             - master
            
# permissions:
#   contents: write


# jobs:
#   format:
#     name: Format SQL Queries
#     runs-on: ubuntu-latest

#     steps:
#         - name: checkout repo
#           uses: actions/checkout@v3.5.2
#         - name: Testing
#           uses: erevear/snowsql-formatter-action@main

# #       - name: Checkout code
# #         uses: actions/checkout@v4
      
# #       - name: Format SQL
# #         uses: sqltools/formatter-action@v1
# #         with:
# #           path: /
# #           args: --indent-type=space --indent-size=2 --keyword-case=upper


# #       - name: Install zetasql
# #         run: |
# #           wget https://github.com/Matts966/zetasql-formatter/releases/download/v1.6.5/zetasql-formatter_linux_x86_64.zip
# #           sudo unzip zetasql-formatter_linux_x86_64.zip -d /usr/local/bin
# #           rm zetasql-formatter_linux_x86_64.zip

# #       - name: Format SQL Queries
# #         uses: yoheikikuta/sql-autoformat-action@v1.0.2
# #         with:
# #           args: --indent_size=4 # customize the formatting options as needed
# #           path: / # specify the path to the SQL files