tests.yml

name: Tests

on:
  push:
    branches:
      - master
  pull_request:

permissions:
  contents: read

jobs:
  test:
    name: Test on node ${{ matrix.node-version }} and ${{ matrix.os }}
    runs-on: ${{ matrix.os }}
    strategy:
      fail-fast: true
      matrix:
        node-version: [16.x, 18.x, 20.x]
        os: [ubuntu-latest]

    steps:
      - uses: actions/checkout@v4
      - name: Use Node.js ${{ matrix.node-version }}
        uses: actions/setup-node@v4
        with:
          cache: 'npm'
          node-version: ${{ matrix.node-version }}

      # Use separate run commands so command status handled correctly on Windows
      - name: npm install
        run: npm ci

      - name: npm test
        run: npm test

      - name: npm run lint
        run: npm run lint

      - name: npm run build
        run: |
          npm run build
          node dist/sqomplexity.js -V

      # Run some simply CLI tool tests.
      - name: CLI test
        run: |
          node dist/sqomplexity.js "SELECT * FROM users"
          node dist/sqomplexity.js "SELECT * FROM users" -s
          node dist/sqomplexity.js "SELECT * FROM users" -a
          node dist/sqomplexity.js "SELECT * FROM users" -p
          node dist/sqomplexity.js "U0VMRUNUICogRlJPTSB1c2Vycw==" -b
          node dist/sqomplexity.js "U0VMRUNUICogRlJPTSB1c2Vycw==" -b -s