fix(ci): ci configuration #11
This file contains hidden or 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
| name: SQL Formatter CI | |
| on: | |
| push: | |
| branches: [main, develop] | |
| pull_request: | |
| branches: [main] | |
| jobs: | |
| test: | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| nvim-version: ["0.8.0", "0.9.0"] | |
| sql-dialect: ["postgresql", "mysql", "sqlite"] | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Setup Neovim | |
| run: | | |
| curl -LO https://github.com/neovim/neovim/releases/download/v${{ matrix.nvim-version }}/nvim-linux64.tar.gz | |
| tar xzf nvim-linux64.tar.gz | |
| sudo mv nvim-linux64/bin/nvim /usr/local/bin/ | |
| sudo mv nvim-linux64/lib/nvim /usr/local/lib/ | |
| sudo mv nvim-linux64/share/nvim /usr/local/share/ | |
| nvim --version | |
| - name: Setup Python | |
| uses: actions/setup-python@v4 | |
| with: | |
| python-version: "3.x" | |
| - name: Install dependencies | |
| run: | | |
| # Install sqlparse | |
| pip install sqlparse | |
| # Install Lua dependencies | |
| sudo apt-get update | |
| sudo apt-get install -y luarocks | |
| sudo luarocks install luacheck | |
| # Install stylua for formatting | |
| cargo install stylua | |
| - name: Lint Lua code | |
| run: | | |
| luacheck lua/ --globals vim | |
| stylua --check lua/ | |
| - name: Test plugin loading | |
| run: | | |
| nvim --headless -c "lua require('sql-formatter').setup({dialect = '${{ matrix.sql-dialect }}'})" -c "qa!" | |
| - name: Test SQL formatting | |
| run: | | |
| # Test basic SQL formatting | |
| echo "SELECT * FROM users WHERE active=1;" | sqlformat --reindent --keywords upper --identifiers lower - | |
| # Test complex SQL formatting | |
| echo "WITH RECURSIVE cte AS (SELECT id, name, parent_id FROM categories WHERE parent_id IS NULL UNION ALL SELECT c.id, c.name, c.parent_id FROM categories c INNER JOIN cte ON c.parent_id = cte.id) SELECT * FROM cte;" | sqlformat --reindent --keywords upper --identifiers lower - | |
| - name: Test file type detection | |
| run: | | |
| # Create test SQL files | |
| echo "SELECT * FROM test;" > test.sql | |
| echo "SELECT * FROM test;" > test.mysql | |
| echo "SELECT * FROM test;" > test.pgsql | |
| # Test formatting for each file type | |
| for file in test.*; do | |
| nvim --headless -c "e $file" -c "lua require('sql-formatter').setup({dialect = '${{ matrix.sql-dialect }}'})" -c "wq" | |
| done | |
| release: | |
| needs: test | |
| runs-on: ubuntu-latest | |
| if: github.ref == 'refs/heads/main' && github.event_name == 'push' | |
| steps: | |
| - uses: actions/checkout@v3 | |
| with: | |
| fetch-depth: 0 | |
| - name: Generate changelog | |
| id: changelog | |
| run: | | |
| echo "## Changes" > CHANGELOG.tmp | |
| git log --oneline --since="$(git describe --tags --abbrev=0 2>/dev/null || echo '1970-01-01')" >> CHANGELOG.tmp | |
| - name: Create Release | |
| uses: actions/create-release@v1 | |
| if: contains(github.event.head_commit.message, '[release]') | |
| env: | |
| GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }} | |
| with: | |
| tag_name: v${{ github.run_number }} | |
| release_name: Release v${{ github.run_number }} | |
| body_path: CHANGELOG.tmp | |
| draft: false | |
| prerelease: false |