feat: Added automatic prisma migrations for production DB #199

	name: CI Pipeline

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

	jobs:
	lint:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4
	- uses: ./.github/actions/setup-environment
	- name: Run ESLint and Prettier Check
	run: npm run lint

	svelte_check:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4
	- uses: ./.github/actions/setup-environment
	- name: Run Svelte Check
	run: npm run check

	playwright_tests:
	runs-on: ubuntu-latest
	services:
	cockroach_db:
	image: cockroachdb/cockroach:v24.2.1
	env:
	COCKROACH_ARGS: 'start-single-node --insecure'
	ports:
	- 26257:26257

	steps:
	- uses: actions/checkout@v4
	- uses: ./.github/actions/setup-environment

	- name: Set DATABASE_URL
	run: echo "DATABASE_URL=postgresql://root@localhost:26257/defaultdb?sslmode=disable" >> $GITHUB_ENV

	- name: Initialize database schema
	run: npx prisma db push

	- name: Generate AUTH_SECRET
	run: echo "AUTH_SECRET=$(openssl rand -base64 33)" >> $GITHUB_ENV

	- name: Install Playwright Browsers
	run: npx playwright install --with-deps

	- name: Run Playwright tests
	run: npx playwright test

	- name: Upload Playwright report
	uses: actions/upload-artifact@v4
	if: always()
	with:
	name: playwright-report
	path: playwright-report/
	retention-days: 30

Provide feedback