maximunited / yomu / 26372766887

85%

push

github

feat: migrate to Prisma 7 with PostgreSQL driver adapter (#55)

* feat: migrate to Prisma 7 with PostgreSQL driver adapter

BREAKING CHANGE: Migrate from Prisma 6 to Prisma 7

Changes:
- Update @prisma/client and prisma to v7.8.0
- Remove url field from datasource in schema.prisma (Prisma 7 requirement)
- Create prisma.config.ts for migration configuration
- Install and configure @prisma/adapter-pg for PostgreSQL connections
- Update PrismaClient initialization to use driver adapter pattern
- Add pg package for PostgreSQL pool management

Prisma 7 no longer supports direct url field in schema.prisma. Instead,
database connections are configured via driver adapters at runtime. This
provides better flexibility and follows modern database connection patterns.

Migration guide followed: https://pris.ly/d/prisma7-client-config

All tests passing (481/481)
Build verified successfully

Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>

* fix(prisma): remove --skip-generate flag (removed in Prisma 7)

Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>

* fix(prisma): add fallback DATABASE_URL for build time

Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>

* fix(prisma): pass DATABASE_URL via --url flag for db push

Prisma 7 requires explicit URL passing to prisma db push command.

Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>

* style: format conditional-db-push.js

Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>

* fix: resolve CI failures and security vulnerabilities

Fixes all issues identified in PR #55 review:

1. **CI Build Failures**
   - Add DATABASE_URL to CI workflow build step
   - Add DATABASE_URL and SKIP_DB_PUSH to Dockerfile build stage
   - Prevents "DATABASE_URL environment variable is not set" errors

2. **Docker Configuration**
   - Migrate from SQLite to PostgreSQL in compose.yml
   - Update db service to use postgres:16-alpine
   - Add healthcheck for database availability
   - Update connec... (continued)

688 of 970 branches covered (70.93%)

Branch coverage included in aggregate %.

6 of 6 new or added lines in 1 file covered. (100.0%)

10061 of 11711 relevant lines covered (85.91%)

33.59 hits per line