name: Run tests

on: [push, pull_request]

jobs:
  run-tests:

    strategy:
      matrix:
        #os: [ubuntu-latest, windows-latest]
        os: [windows-latest]
        #python-version: ["2.7", "3.5", "3.6", "3.7", "3.8", "3.9", "3.10", "3.11"]
        python-version: ["3.7"]
        include:
        #- os: ubuntu-latest
        #  os-name: Linux
        #  pip-cache-path: ~/.cache/pip
        - os: windows-latest
          os-name: w32
          pip-cache-path: ~\AppData\Local\pip\Cache

    name: Python ${{ matrix.python-version }} @ ${{ matrix.os-name }}
    runs-on: ${{ matrix.os }}

    steps:

      # Setup MySQL
      #- uses: ankane/setup-mysql@v1

      # Setup PostgreSQL
      #- uses: ankane/setup-postgres@v1
      #- name: Setup Postgres user
      #  run: |
      #    sudo -u postgres psql --command="ALTER USER runner CREATEDB ENCRYPTED PASSWORD 'test'"
      #  if: ${{ runner.os == 'Linux' }}
      #- name: Setup Postgres user
      #  run: |
      #    psql --command="CREATE USER runner CREATEDB ENCRYPTED PASSWORD 'test'"
      #  if: ${{ runner.os == 'Windows' }}

      # Setup MS SQL
      - uses: ankane/setup-sqlserver@v1
        with:
          accept-eula: true
      - name: tsql
        run: |
          sudo apt-get update --yes
          sudo apt-get install --yes freetds-bin
          echo "SELECT @@VERSION" | tsql -H localhost -p 1433 -U sa -P 'YourStrong!Passw0rd'
        if: ${{ runner.os == 'Linux' }}
      - name: Enable TCP for MSSQL
        run: |
          [System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SqlWmiManagement')
          $wmi = New-Object 'Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer' localhost
          $tcp = $wmi.ServerInstances['MSSQLSERVER'].ServerProtocols['Tcp']
          $tcp.IsEnabled = $true
          $tcp.Alter()
          Restart-Service -Name MSSQLSERVER -Force
        shell: powershell
        if: ${{ runner.os == 'Windows' }}

      # Setup Python/pip
      - uses: actions/checkout@v2
      - uses: actions/setup-python@v4
        with:
          python-version: ${{ matrix.python-version }}
      - name: Cache pip
        uses: actions/cache@v3
        with:
          path: ${{ matrix.pip-cache-path }}
          key: ${{ runner.os }}-pip

      # Setup tox
      - name: Install dependencies
        run: |
          python --version
          python -m pip install --upgrade pip setuptools wheel
          pip --version
          pip install --upgrade virtualenv tox
      - name: Set PYVER
        run: |
          import os, sys
          pyver = '%d%d' % tuple(sys.version_info[:2])
          with open(os.environ['GITHUB_ENV'], 'a') as f:
            f.write('PYVER=' + pyver + '\n')
            f.write('PGPASSWORD=test\n')
        shell: python

      - name: tox version
        run: |
          tox --version
      - name: Run tox @ Linux
        run: |
          #devscripts/tox-select-envs $PYVER-mysql
          #devscripts/tox-select-envs $PYVER-postgres
          #devscripts/tox-select-envs $PYVER-sqlite
          devscripts/tox-select-envs $PYVER-mssql
          devscripts/tox-select-envs $PYVER-pytds
          devscripts/tox-select-envs $PYVER-flake8
        if: ${{ runner.os == 'Linux' }}
      - name: Run tox @ w32
        run: |
          #devscripts\tox-select-envs.cmd %PYVER%-mysql
          #devscripts\tox-select-envs.cmd %PYVER%-postgres
          #devscripts\tox-select-envs.cmd %PYVER%-sqlite
          devscripts\tox-select-envs.cmd %PYVER%-mssql
          devscripts\tox-select-envs.cmd %PYVER%-pytds
        if: ${{ runner.os == 'Windows' }}