fix: increase seed transaction timeout to 30s #35

	name: Seed staging database

	on:
	# Manual trigger
	workflow_dispatch:
	# Trigger after staging deployment (adjust if you have a different deployment workflow)
	push:
	branches:
	- staging
	paths-ignore:
	- ".beads/**"
	- "*.md"
	- "docs/**"

	jobs:
	seed:
	runs-on: ubuntu-latest

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

	- name: Setup Node.js
	uses: actions/setup-node@v4
	with:
	node-version: "20"

	- name: Setup pnpm
	uses: pnpm/action-setup@v4

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

	- name: Generate Prisma client
	env:
	DATABASE_URL: "postgresql://dummy:dummy@localhost:5432/dummy"
	run: npx prisma generate

	- name: Reset and migrate database
	env:
	DATABASE_URL: ${{ secrets.STAGING_DATABASE_URL }}
	run: npx prisma migrate reset --force

	- name: Grant permissions to app user
	env:
	DATABASE_URL: ${{ secrets.STAGING_DATABASE_URL }}
	run: \|
	psql "$DATABASE_URL" -c "
	GRANT USAGE, CREATE ON SCHEMA public TO tea_app;
	GRANT ALL ON ALL TABLES IN SCHEMA public TO tea_app;
	GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO tea_app;
	ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO tea_app;
	ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO tea_app;
	"

	- name: Run seed script
	env:
	DATABASE_URL: ${{ secrets.STAGING_DATABASE_URL }}
	SEED_USER_PASSWORD: ${{ secrets.SEED_USER_PASSWORD }}
	run: npx tsx prisma/seed/dev-seed.ts

Provide feedback