test.yml

### A CI workflow template that runs linting and python testing
### TODO: Modify as needed or as desired.

name: Test tap-mssql

on: [push]

jobs:
  pytest:
    runs-on: ubuntu-latest
    env:
      GITHUB_TOKEN: ${{secrets.GITHUB_TOKEN}}
    strategy:
      fail-fast: false
      matrix:
        python-version: ["3.9", "3.10", "3.11", "3.12"]
    steps:
    - uses: actions/checkout@v4
    - name: Set up Python ${{ matrix.python-version }}
      uses: actions/setup-python@v5
      with:
        python-version: ${{ matrix.python-version }}
    - name: Set up SQL Server container
      run: |
        docker compose -f docker-compose.yml up -d
    - name: Sleep for 30 seconds
      run: sleep 30s
    - name: Install ODBC
      working-directory: ${{ github.workspace }}/.github
      run: bash ./install-odbc.sh
    - name: Install Poetry
      run: |
        pip install poetry
    - name: Install dependencies
      run: |
        poetry env use ${{ matrix.python-version }}
        poetry install
    - name: Test with pytest
      run: |
        poetry run pytest