test: add test for separate_server option #327

	# SPDX-FileCopyrightText: Copyright (C) 2025 Opal Health Informatics Group <https://www.opalmedapps.com>
	#
	# SPDX-License-Identifier: MIT
	name: ci

	on:
	push:
	branches:
	- main
	pull_request:
	workflow_dispatch:
	merge_group:

	concurrency:
	group: ${{ github.workflow }}-${{ github.event.pull_request.number \|\| '' }}
	cancel-in-progress: true

	permissions:
	contents: read

	jobs:
	lint:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v6.0.1
	with:
	persist-credentials: false
	- uses: pre-commit/action@v3.0.1
	test:
	runs-on: ubuntu-latest
	services:
	# simulate a separate DB server
	external-db:
	image: mariadb:10.11.15-jammy
	ports:
	- 3307:3306
	env:
	MARIADB_ROOT_PASSWORD: root-password
	steps:
	- uses: actions/checkout@v6.0.1
	with:
	persist-credentials: false
	- uses: astral-sh/setup-uv@61cb8a9741eeb8a550a1b8544337180c0fc8476b # v7.2.0
	id: setup-uv
	with:
	# renovate: datasource=pypi dependency=uv
	version: "0.9.26"
	- name: Test template using copier-template-tester
	run: \|
	uv run --with copier --with copier-templates-extensions --with bcrypt --with copier-template-tester ctt
	- name: Show running containers
	run: \|
	docker ps

Provide feedback