refactor: check that the user-defined table has 1 and only 1 primary … #1255

	---
	name: Test Suite

	on:
	push:
	branches:
	- "**"
	pull_request:
	branches: ["main"]
	schedule:
	- cron: "0 0 * * *"

	jobs:
	tests:
	name: "Python ${{ matrix.python-version }}"
	runs-on: "ubuntu-latest"

	strategy:
	matrix:
	python-version: ["3.8", "3.9", "3.10", "3.11", "3.12"]

	services:

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

	postgres_alt:
	image: postgres:10.8
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: saffier_alt
	ports:
	- 5433:5432
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5

	steps:
	- uses: "actions/checkout@v4"
	- uses: "actions/setup-python@v5"
	with:
	python-version: "${{ matrix.python-version }}"
	- uses: actions/cache@v4
	id: cache
	with:
	path: ${{ env.pythonLocation }}
	key: ${{ runner.os }}-python-${{ env.pythonLocation }}-${{ hashFiles('pyproject.toml') }}-test-v02
	- name: "Install dependencies"
	if: steps.cache.outputs.cache-hit != 'true'
	run: "scripts/install"
	- name: "Run lint checks"
	run: "scripts/check"
	- name: "Run tests"
	env:
	TEST_DATABASE_URL: "postgresql+asyncpg://postgres:postgres@localhost:5432/saffier"
	TEST_DATABASE_ALTERNATIVE_URL: "postgresql+asyncpg://postgres:postgres@localhost:5433/saffier_alt"
	run: "scripts/test"

Provide feedback