tests.yml

name: tests
on:
  push:
    branches:
    - main
  pull_request:
    branches:
    - main
jobs:
  pre-commit:
    runs-on: ubuntu-latest
    steps:
    - uses: actions/checkout@v4
    - uses: actions/setup-python@v4
    - uses: pre-commit/action@v3.0.0
  integration-tests:
    runs-on: ubuntu-latest
    strategy:
      matrix:
        dbt_core: [1.5.*, 1.8.*]
        db_target: [duckdb, postgres, clickhouse]
    services:
      postgres:
        image: ${{ (matrix.db_target == 'postgres') && 'postgres' || '' }}
        env:
          POSTGRES_USER: postgres
          POSTGRES_PASSWORD: postgres
          POSTGRES_DB: dbt_linreg
        ports:
          - 5432:5432
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
    steps:
      - uses: actions/checkout@v4
      - name: Install uv
        uses: astral-sh/setup-uv@v5
      - name: Setup
        run: |
          sudo apt-get update
          sudo apt-get install
          chmod +x ./run
          uv venv
          uv sync --extra python-dev
          uv pip install -U "dbt-core==$DBT_CORE_VERSION" "dbt-${DBT_TARGET}==$DBT_CORE_VERSION"
        env:
          UV_NO_SYNC: true
          DO_NOT_TRACK: 1
          DBT_CORE_VERSION: ${{ matrix.dbt_core }}
          DBT_TARGET: ${{ matrix.db_target }}
      - name: Test
        run: ./run test "${DBT_TARGET}"
        env:
          UV_NO_SYNC: true
          DO_NOT_TRACK: 1
          DBT_TARGET: ${{ matrix.db_target }}
          POSTGRES_HOST: localhost
          POSTGRES_USER: postgres
          POSTGRES_PASSWORD: postgres
          POSTGRES_DB: dbt_linreg