#26 miss thx and check psql #85

	name: Tests Unit

	on:
	push:
	branches: '*'

	permissions:
	contents: read
	pull-requests: write
	checks: write

	env:
	PGPASSWORD: ep2m2
	PGUSER: ep2m2
	PGPORT: 5432
	PGDATABASE: ep2m2db

	jobs:
	test:
	runs-on: ubuntu-latest
	services:
	service-p2m2tool-api:
	image: inraep2m2/service-p2m2tools-api
	ports:
	- 8080:8080
	db:
	image: postgres:latest
	# Provide the password for postgres
	env:
	POSTGRES_PASSWORD: secret
	POSTGRES_DB: testdb
	# Set health checks to wait until postgres has started
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 5432:5432

	steps:
	- name: Get repo
	uses: actions/checkout@v3
	- name: add client
	run: \|
	sudo apt-get update -y
	sudo apt-get install --yes postgresql-client
	- name: check psql
	run: psql --help
	- name: Configure Database
	run: \|
	PGPASSWORD=secret psql -U postgres -d testdb -tc "CREATE TABLE proj
	(id SERIAL PRIMARY KEY);"
	- name: Use Node.js
	uses: actions/setup-node@v3
	with:
	node-version: latest
	cache: 'npm'
	- name: Installation project s packages
	run: npm ci
	- name: Test & coverage
	run: npm run coverage
	- name: Report coverage
	if: always()
	uses: davelosert/vitest-coverage-report-action@v2
	with:
	file-coverage-mode: all
	- name: Summary Tests
	uses: EnricoMi/publish-unit-test-result-action@v2
	if: always()
	with:
	files: \|
	test/*/.xml
	- name: Complet report tests
	uses: dorny/test-reporter@v1
	if: always()
	with:
	reporter: "java-junit"
	name: Test Unit
	path: test/*/.xml

Provide feedback