Tests

Add comprehensive production readiness review #65

	name: Tests

	on:
	push:
	branches: [main, develop]
	pull_request:
	branches: [main]

	jobs:
	test:
	runs-on: ubuntu-latest

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

	steps:
	- uses: actions/checkout@v3

	- name: Use Node.js
	uses: actions/setup-node@v3
	with:
	node-version: '18'
	cache: 'npm'

	- name: Install dependencies
	run: npm ci

	- name: Build
	run: npm run build

	- name: Run unit tests
	run: npm run test:unit

	- name: Run integration tests
	env:
	DATABASE_URL: postgresql://postgres:postgres@localhost:5432/test_db
	run: npm run test:integration

	- name: Upload coverage reports
	uses: actions/upload-artifact@v3
	if: always()
	with:
	name: coverage-report
	path: coverage/

Provide feedback