Prisma - Prisma v7 사용법

Prisma

 

 

✅ 배포 시 설정법

---

<package.json>

"dependencies": {
	"prisma": "^7.2.0",
    "@prisma/adapter-pg": "^7.2.0",
    "@prisma/client": "^7.2.0",
    "pg": "^8.17.1",
},
"scripts": {
    "dev": "next dev",
    "prebuild": "npx prisma generate",
    "build": "next build",
    "start": "next start",
    "lint": "eslint"
},

 

npm i pg @prisma/adapter-pg

 

<prisma.config.ts>

// This file was generated by Prisma, and assumes you have installed the following:
// npm install --save-dev prisma dotenv
import "dotenv/config";
import { defineConfig } from "prisma/config";

export default defineConfig({
  schema: "prisma/schema.prisma",
  migrations: {
    path: "prisma/migrations",
  },
  datasource: {
    url: process.env["DATABASE_URL"],
  },
});

 

<schema.prisma>

generator client {
  provider = "prisma-client"
  output   = "../app/generated/prisma"
}

datasource db {
  provider = "postgresql"
}

 

<db.ts>

import { PrismaClient } from "../app/generated/prisma/client";
import { PrismaPg } from "@prisma/adapter-pg";

const globalForPrisma = global as unknown as {
  db: PrismaClient;
};

const adapter = new PrismaPg({
  connectionString: process.env.DATABASE_URL,
});

const db =
  globalForPrisma.db ||
  new PrismaClient({
    adapter,
  });

if (process.env.NODE_ENV !== "production") {
  globalForPrisma.db = db;
}

export default db;