test-package.yml

# This workflow will install Python dependencies, run tests and lint with a variety of Python versions
# For more information see: https://docs.github.com/en/actions/automating-builds-and-tests/building-and-testing-python

name: Python package

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

jobs:
  test:

    runs-on: ubuntu-latest
    strategy:
      fail-fast: false
      matrix:
        python-version: ["3.9", "3.10", "3.11"]
    services:
      clickhouse:
        image: clickhouse/clickhouse-server:24.1.5.6
        ports:
          - 8123:8123
          - 9000:9000

    steps:
    - uses: actions/checkout@v3
    - name: Set up Python ${{ matrix.python-version }}
      uses: actions/setup-python@v3
      with:
        python-version: ${{ matrix.python-version }}
    - name: Install Poetry
      run: |
        curl -sSL https://install.python-poetry.org | python3 - --version 1.5.1
    - name: Install dependencies
      run: |
        poetry install --all-extras
    - name: Lint with flake8
      run: |
        # stop the build if there are Python syntax errors or undefined names
        poetry run flake8 . --count --select=E9,F63,F7,F82 --show-source --statistics
        # exit-zero treats all errors as warnings. The GitHub editor is 127 chars wide
        poetry run flake8 . --count --exit-zero --max-complexity=10 --max-line-length=119 --statistics --ignore E203,E266,E501,W503
    - name: Test with pytest
      env:
        SQL_MOCK_CLICKHOUSE_HOST: 127.0.0.1
        SQL_MOCK_CLICKHOUSE_PORT: 8123
        SQL_MOCK_CLICKHOUSE_USER: default
      run: |
        poetry run pytest tests/