aiosql-package.yml

# This workflow will install Python dependencies, run tests and lint with a variety of Python versions
# For more information see: https://help.github.com/actions/language-and-framework-guides/using-python-with-github-actions

name: Aiosql Package

on:
  push:
    branches: [ main ]
  pull_request:
    branches: [ main ]

jobs:
  build:

    runs-on: ubuntu-latest
    strategy:
      fail-fast: false
      matrix:
        # NOTE asyncpg does not compile with pypy 3.7 & 3.8, nor python 3.12-dev
        # https://github.com/actions/python-versions (versions-manifest.json)
        # https://downloads.python.org/pypy/versions.json
        # KO: "3.12-dev"
        python-version: ["3.8", "3.9", "3.10", "3.11", "3.12-dev"]
    steps:
    - uses: actions/checkout@v3
    - name: Set up Python ${{ matrix.python-version }}
      uses: actions/setup-python@v4
      with:
        python-version: ${{ matrix.python-version }}
    - name: Install dependencies
      run: |
        python -m pip install --upgrade pip
        python -m pip install .[dev,dev-postgres,dev-mysql,dev-sqlite,dev-duckdb]
    - name: Check types with mypy
      run: make VENV= INSTALL= check.mypy
    - name: Lint with black
      run: make VENV= INSTALL= check.black
    - name: Lint with flake8
      run: make VENV= INSTALL= check.flake8
    - name: Test with pytest and databases
      run: make VENV= INSTALL= check.pytest
    - name: Coverage tests
      run: make VENV= INSTALL= check.coverage
    - name: Check RST files
      run: make VENV= INSTALL= check.rstcheck