db_indexes.yaml

name: Database indexes
on: [push, pull_request]
concurrency:
  group: database-${{ github.ref }}
  cancel-in-progress: true
defaults:
  run:
    working-directory: 'galaxy root'
jobs:
  check:
    name: Check database indexes
    runs-on: ubuntu-latest
    strategy:
      matrix:
        python-version: ['3.7']
        db: ['postgresql', 'sqlite']
        postgresql-version: ['13']
        include:
          - db: postgresql
            postgresql-version: '9.6'
    services:
      postgres:
        image: postgres:${{ matrix.postgresql-version }}
        env:
          POSTGRES_USER: postgres
          POSTGRES_PASSWORD: postgres
          POSTGRES_DB: postgres
        ports:
          - 5432:5432
    steps:
    - uses: actions/checkout@v2
      with:
        path: 'galaxy root'
    - uses: actions/setup-python@v1
      with:
        python-version: ${{ matrix.python-version }}
    - name: Cache pip dir
      uses: actions/cache@v1
      id: pip-cache
      with:
        path: ~/.cache/pip
        key: pip-cache-${{ matrix.python-version }}-${{ hashFiles('galaxy root/requirements.txt') }}
    - name: Cache tox env
      uses: actions/cache@v2
      with:
        path: .tox
        key: tox-cache-${{ matrix.python-version }}-${{ hashFiles('galaxy root/requirements.txt') }}-check-indexes
    - name: Install tox
      run: pip install tox
    - name: Check indexes on postgresql
      if: matrix.db == 'postgresql'
      env:
        GALAXY_CONFIG_OVERRIDE_DATABASE_CONNECTION: 'postgresql://postgres:postgres@localhost:5432/galaxy?client_encoding=utf8'
      run: tox -e check_indexes
    - name: Check indexes on sqlite
      if: matrix.db == 'sqlite'
      run: tox -e check_indexes