Skip the unread-message subquery when listing joinable games #2103

	name: Test Service

	on:
	push:
	branches: [ main ]
	pull_request:
	branches: [ main ]

	permissions:
	contents: read

	jobs:
	test:
	runs-on: ubuntu-latest
	timeout-minutes: 20

	services:
	postgres:
	image: postgres:16
	env:
	POSTGRES_DB: diplicity
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 5432:5432

	steps:
	- uses: actions/checkout@v7
	with:
	persist-credentials: false

	- uses: actions/setup-python@v7
	with:
	python-version: '3.12'
	cache: 'pip'
	cache-dependency-path: \|
	service/requirements.txt
	service/dev_requirements.txt

	- name: Install dependencies
	run: pip install -r requirements.txt -r dev_requirements.txt
	working-directory: service

	- name: Run service tests
	run: python -m pytest -v --timeout=60 -n auto --ignore=integration/
	working-directory: service
	env:
	DATABASE_NAME: diplicity
	DATABASE_USER: postgres
	DATABASE_PASSWORD: postgres
	DATABASE_HOST: localhost
	DATABASE_PORT: 5432
	DJANGO_DEBUG: 'True'

Navigation Menu