feat(ci, publish): add PostgreSQL service configuration and environme… #19

	name: CI

	on:
	push:
	branches:
	- main
	- develop
	pull_request:
	branches:
	- main
	- develop

	jobs:
	test:
	name: Run Tests
	runs-on: ubuntu-latest

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

	env:
	DATABASE_URL: postgresql://postgres:postgres@localhost:5432/artisyn?schema=public
	NODE_ENV: test

	strategy:
	matrix:
	node-version: [20.x, 22.x, 24.x, 25.x]

	steps:
	- name: Checkout code
	uses: actions/checkout@v4

	- name: Install pnpm
	uses: pnpm/action-setup@v2
	with:
	version: 8

	- name: Setup Node.js ${{ matrix.node-version }}
	uses: actions/setup-node@v4
	with:
	node-version: ${{ matrix.node-version }}
	cache: 'pnpm'

	- name: Install dependencies
	run: pnpm install --no-frozen-lockfile

	- name: Run linter
	run: pnpm lint

	- name: Build the project
	run: \|
	cd express && pnpm build
	cd ../h3 && pnpm build
	cd ../
	pnpm build:packages

	- name: Run Prisma Generate
	run: pnpm prisma generate

	- name: Run tests
	run: pnpm test:coverage

	- name: Upload coverage reports to Codecov
	uses: codecov/codecov-action@v5
	with:
	token: ${{ secrets.CODECOV_TOKEN }}
	slug: arcstack-hq/resora

Provide feedback