add: postgres sql for test workflow #22

	name: Project test
	on: push

	permissions:
	contents: read
	packages: read

	jobs:
	test-check:
	runs-on: ubuntu-latest
	timeout-minutes: 5

	services:
	postgres:
	image: postgres:14-alpine
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: test
	ports:
	- 5432:5432
	options: --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5

	steps:
	- name: Checkout
	uses: actions/checkout@v4
	- name: Setup python 3.12
	uses: actions/setup-python@v4
	with:
	python-version: 3.12
	cache: pip
	cache-dependency-path: pyproject.toml
	- name: dependency install
	run: pip install -e ".[dev]"
	- name: copy env
	run: cp .env.example .env
	- name: test
	run: tox
	env:
	TEST_DATABASE_NAME: test

Provide feedback