Skip to content

Fix UP031 errors - Part 1 #26554

Fix UP031 errors - Part 1

Fix UP031 errors - Part 1 #26554

Workflow file for this run

name: Database indexes
on:
push:
paths-ignore:
- 'client/**'
- 'doc/**'
- 'lib/galaxy_test/selenium/**'
pull_request:
paths-ignore:
- 'client/**'
- 'doc/**'
- 'lib/galaxy_test/selenium/**'
concurrency:
group: ${{ github.workflow }}-${{ github.ref }}
cancel-in-progress: true
defaults:
run:
working-directory: 'galaxy root'
jobs:
check:
name: Check database indexes
runs-on: ubuntu-latest
strategy:
matrix:
db: ['postgresql', 'sqlite']
postgresql-version: ['13']
python-version: ['3.8']
include:
- db: postgresql
postgresql-version: '9.6'
python-version: '3.8'
services:
postgres:
image: postgres:${{ matrix.postgresql-version }}
env:
POSTGRES_USER: postgres
POSTGRES_PASSWORD: postgres
POSTGRES_DB: postgres
ports:
- 5432:5432
steps:
- uses: actions/checkout@v4
with:
path: 'galaxy root'
- uses: actions/setup-python@v5
with:
python-version: ${{ matrix.python-version }}
cache: 'pip'
cache-dependency-path: 'galaxy root/requirements.txt'
- name: Get full Python version
id: full-python-version
shell: bash
run: echo "version=$(python -c 'import sys; print("-".join(str(v) for v in sys.version_info))')" >> $GITHUB_OUTPUT
- name: Cache tox env
uses: actions/cache@v4
with:
path: .tox
key: tox-cache-${{ runner.os }}-${{ steps.full-python-version.outputs.version }}-${{ hashFiles('galaxy root/requirements.txt') }}-check-indexes
- name: Install tox
run: pip install tox
- name: Set database connection on PostgreSQL
if: matrix.db == 'postgresql'
run: echo 'GALAXY_CONFIG_OVERRIDE_DATABASE_CONNECTION=postgresql://postgres:postgres@localhost:5432/galaxy?client_encoding=utf8' >> $GITHUB_ENV
- name: Check indexes
run: tox -e check_indexes