main.yml

name: "Test"

on:
  push:
    paths-ignore:
      - "docs/**"
  pull_request:
    paths-ignore:
      - "docs/**"
  schedule:
    - cron: '40 1 * * 3'


jobs:
  test:
    name: test-python${{ matrix.python-version }}-sa${{ matrix.sqlalchemy-version }}-${{ matrix.db-engine }}
    strategy:
      matrix:
        python-version:
          - "3.8"
#          - "3.9"
#          - "3.10"
#          - "pypy-3.7"
        sqlalchemy-version:
          - ">=1.4,<2.0"
          - ">=2.0"
        db-engine:
          - sqlite
          - postgres
          - postgres-native
          - mysql
    runs-on: ubuntu-latest
    services:
      mysql:
        image: mysql
        ports:
          - 3306:3306
        env:
          MYSQL_DATABASE: main
          MYSQL_ALLOW_EMPTY_PASSWORD: yes
        options: >-
          --health-cmd "mysqladmin ping"
          --health-interval 5s
          --health-timeout 2s
          --health-retries 3
      postgres:
        image: postgres
        ports:
          - 5432:5432
        env:
          POSTGRES_PASSWORD: postgres
          POSTGRES_DB: main
        options: >-
          --health-cmd pg_isready
          --health-interval 5s
          --health-timeout 2s
          --health-retries 3
    steps:
      - uses: actions/checkout@v1
      - name: Install sqlalchemy
        run: pip3 install 'sqlalchemy${{ matrix.sqlalchemy-version }}'
      - name: Build
        run: pip3 install -e '.[test]'
      - name: Run tests
        run: pytest
        env:
          DB: ${{ matrix.db-engine }}