test_matrix.yml

---
name: "test_matrix"

on:  # yamllint disable-line rule:truthy
  pull_request:
    branches: main
  push:
    branches-ignore:
      - '*_test'
      - '*_dev'
      - '*_cloud'
    paths-ignore:
      - '**.md'
      - 'LICENSE'

jobs:
  tests:
    name: Python ${{ matrix.python-version }} | Clickhouse ${{ matrix.clickhouse-version}} | Ubuntu
    runs-on: ubuntu-latest
    env:
      TEST_SETTINGS_FILE: latest

    strategy:
      matrix:
        python-version:
          - '3.8'
          - '3.9'
          - '3.10'
          - '3.11'
        clickhouse-version:
          - '22.8'
          - '23.3'
          - '23.5'
          - '23.6'
          - latest

    steps:
      - name: Checkout
        uses: actions/checkout@v3

      - name: Set environment variables
        if: ${{ matrix.clickhouse-version == '22.3' }}
        run: |
          echo "TEST_SETTINGS_FILE=22_3" >> $GITHUB_ENV
          echo "DBT_CH_TEST_CH_VERSION=22.3" >> $GITHUB_ENV

      - name: Run ClickHouse Container
        run: docker run
             -d
             -p 8123:8123
             -p 9000:9000
             --name clickhouse
             -v /var/lib/clickhouse
             -v ${{ github.workspace }}/tests/integration/test_settings_$TEST_SETTINGS_FILE.xml:/etc/clickhouse-server/users.d/test_settings.xml
             --ulimit nofile=262144:262144
             clickhouse/clickhouse-server:${{ matrix.clickhouse-version }}

      - name: Setup Python ${{ matrix.python-version }}
        uses: actions/setup-python@v4
        with:
          python-version: ${{ matrix.python-version }}

      - name: Install requirements
        run: pip3 install -r dev_requirements.txt

      - name: Run HTTP tests
        run: |
          PYTHONPATH="${PYTHONPATH}:dbt"
          pytest tests

      - name: Run Native tests
        env:
          DBT_CH_TEST_PORT: 9000
        run: |
          PYTHONPATH="${PYTHONPATH}:dbt"
          pytest tests