Bump psycopg[c] from 3.1.9 to 3.1.11 #9

	name: CI

	# Enable Buildkit and let compose use it to speed up image building
	env:
	DOCKER_BUILDKIT: 1
	COMPOSE_DOCKER_CLI_BUILD: 1

	on:
	pull_request:
	branches: ['master', 'main']
	paths-ignore: ['docs/**']

	push:
	branches: ['master', 'main']
	paths-ignore: ['docs/**']

	concurrency:
	group: ${{ github.head_ref \|\| github.run_id }}
	cancel-in-progress: true

	jobs:
	linter:
	runs-on: ubuntu-latest
	steps:
	- name: Checkout Code Repository
	uses: actions/checkout@v3

	- name: Set up Python
	uses: actions/setup-python@v4
	with:
	python-version: '3.10'
	# Consider using pre-commit.ci for open source project
	- name: Run pre-commit
	uses: pre-commit/[email protected]

	# With no caching at all the entire ci process takes 4m 30s to complete!
	pytest:
	runs-on: ubuntu-latest

	services:
	postgres:
	image: postgres:15
	ports:
	- 5432:5432
	env:
	POSTGRES_PASSWORD: postgres

	env:
	# postgres://user:password@host:port/database
	DATABASE_URL: 'postgres://postgres:postgres@localhost:5432/postgres'

	steps:
	- name: Checkout Code Repository
	uses: actions/checkout@v3

	- name: Set up Python
	uses: actions/setup-python@v4
	with:
	python-version: '3.10'
	cache: pip
	cache-dependency-path: \|
	requirements/base.txt
	requirements/local.txt

	- name: Install Dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install -r requirements/local.txt

	- name: Test with pytest
	run: pytest

Provide feedback