Prisma 7.9.1 Architecture, Configuration & Migrations

# Runtime application connection (Phase 08 recommends a session-capable pooled URL for local NestJS).
DATABASE_URL=

# Prisma CLI / migration connection. Prefer a direct URL when reachable.
DIRECT_URL=

# Optional only if migrate dev cannot create an automatic shadow database.
# NEVER point this at the same database as DIRECT_URL.
SHADOW_DATABASE_URL=

TaskFlow Phase 09 Prisma reference snapshot

These files are reference outputs for the end of Phase 09.
Do not paste them blindly over an existing project. Compare responsibilities and adapt the existing files.

Important:
- Prisma packages are locked to 7.9.1.
- DATABASE_URL is for runtime PrismaPg.
- DIRECT_URL is for Prisma CLI/migrations.
- If SHADOW_DATABASE_URL is used, it must point to a separate disposable shadow database.
- src/generated/prisma is generated by `pnpm exec prisma generate`; it is intentionally not included here.

pnpm add -D prisma@7.9.1 @types/pg
pnpm add @prisma/client@7.9.1 @prisma/adapter-pg@7.9.1 pg dotenv @nestjs/config

generator client {
  provider     = "prisma-client"
  output       = "../src/generated/prisma"
  moduleFormat = "cjs"
}

datasource db {
  provider = "postgresql"
}

model Todo {
  id        String   @id @default(cuid())
  title     String
  completed Boolean  @default(false)
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

import "dotenv/config";
import { defineConfig, env } from "prisma/config";

export default defineConfig({
  schema: "prisma/schema.prisma",
  migrations: {
    path: "prisma/migrations",
  },
  datasource: {
    // CLI / migrations: direct or session-capable connection.
    url: env("DIRECT_URL"),
  },
});

import { Module } from "@nestjs/common";
import { ConfigModule } from "@nestjs/config";
import { HealthModule } from "./health/health.module";
import { TodosModule } from "./todos/todos.module";
import { PrismaModule } from "./prisma/prisma.module";

@Module({
  imports: [
    ConfigModule.forRoot({ isGlobal: true }),
    PrismaModule,
    HealthModule,
    TodosModule,
  ],
})
export class AppModule {}

import { Global, Module } from "@nestjs/common";
import { PrismaService } from "./prisma.service";

@Global()
@Module({
  providers: [PrismaService],
  exports: [PrismaService],
})
export class PrismaModule {}

import { Injectable, OnModuleDestroy, OnModuleInit } from "@nestjs/common";
import { ConfigService } from "@nestjs/config";
import { PrismaPg } from "@prisma/adapter-pg";
import { PrismaClient } from "../generated/prisma/client";

@Injectable()
export class PrismaService
  extends PrismaClient
  implements OnModuleInit, OnModuleDestroy
{
  constructor(config: ConfigService) {
    const connectionString = config.getOrThrow<string>("DATABASE_URL");
    const adapter = new PrismaPg({ connectionString });
    super({ adapter });
  }

  async onModuleInit() {
    await this.$connect();
  }