Merge pull request #258 from favourawaku/staging #6

	name: Database Migrations

	on:
	push:
	branches:
	- main
	- staging
	paths:
	- 'prisma/migrations/**'
	- 'prisma/schema.prisma'
	pull_request:
	paths:
	- 'prisma/migrations/**'
	- 'prisma/schema.prisma'

	jobs:
	migrate:
	name: Run Prisma migrate deploy
	runs-on: ubuntu-latest

	services:
	postgres:
	image: postgres:16
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: mux_test
	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/mux_test

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

	- name: Setup pnpm
	uses: pnpm/action-setup@v4
	with:
	version: latest

	- name: Setup Node.js
	uses: actions/setup-node@v4
	with:
	node-version: '22'
	cache: 'pnpm'

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

	- name: Generate Prisma client
	run: pnpm prisma:generate

	- name: Run migrations
	run: pnpm prisma:migrate:prod

Navigation Menu