Files

T

Jeffery f44200f543 feat: 完成 B 群組 — 資料層與核心領域模型

- 導入 Prisma 7.9.1 + SQLite（better-sqlite3 driver adapter），prisma.config.ts 管理連線設定
- 完整資料模型：User／Work／Character／CharacterAlias／EpisodicMemory／SemanticMemory／
  ProceduralRule／EmotionState／Relationship／SentimentLedgerEntry
- packages/db：Prisma Client 存取層（ESM，因 Prisma 7 產出的 generated client 僅支援 ESM）
- apps/api 隨之改為 ESM 以相容 packages/db
- packages/shared：新增角色／記憶／情緒／關係共用型別，api 與 web 皆從此匯入
- prisma/seed.ts：建立測試使用者與元氣型測試角色，含完整關係帳本與記憶種子資料
- apps/api：新增 GET /characters
- scripts/smoke/B.mjs：驗證資料表齊全、API 讀出種子角色、關係與記憶可寫入讀出
- 保留 Prisma 官方隨 CLI 附的 agent skill 文件（.agents/skills 等），供後續群組查閱

npm run restart && npm run smoke -- B 皆通過（B-V），A 群組冒煙測試無回歸。

2026-08-13 09:43:15 +08:00

2.6 KiB

Raw Permalink Blame History

Prisma 7 Client Instantiation

Prisma 7 changed how PrismaClient connects to databases. The CLI (prisma db push, prisma migrate) reads the URL from prisma.config.ts. But at runtime, you must provide a driver adapter to PrismaClient explicitly.

Required packages

npm install @prisma/client @prisma/adapter-pg pg

@prisma/adapter-pg — the Prisma adapter for the pg PostgreSQL driver
pg — the underlying Node.js PostgreSQL driver

Basic instantiation

import 'dotenv/config'
import pg from 'pg'
import { PrismaPg } from '@prisma/adapter-pg'
import { PrismaClient } from './generated/prisma/client.js'

const pool = new pg.Pool({ connectionString: process.env.DATABASE_URL })
const adapter = new PrismaPg(pool)
const prisma = new PrismaClient({ adapter })

Key rules

Import path: Always ./generated/prisma/client.js — not ./generated/prisma and not @prisma/client.
Adapter is mandatory: new PrismaClient() with no arguments throws. new PrismaClient({ datasourceUrl: '...' }) also throws — datasourceUrl does not exist in Prisma 7.
ESM required: The generated client uses ESM. Ensure package.json has "type": "module".
Pool lifecycle: Call await pool.end() when shutting down (after prisma.$disconnect()).

Usage in application code

import 'dotenv/config'
import pg from 'pg'
import { PrismaPg } from '@prisma/adapter-pg'
import { PrismaClient } from './generated/prisma/client.js'

const pool = new pg.Pool({ connectionString: process.env.DATABASE_URL })
const adapter = new PrismaPg(pool)
const prisma = new PrismaClient({ adapter })

// Create
const user = await prisma.user.create({
  data: { email: 'alice@example.com', name: 'Alice' },
})

// Read with relations
const posts = await prisma.post.findMany({
  where: { published: true },
  include: { author: true },
})

// Update
await prisma.post.update({
  where: { id: 1 },
  data: { published: true },
})

// Delete
await prisma.post.delete({ where: { id: 1 } })

// Cleanup
await prisma.$disconnect()
await pool.end()

Common mistakes

Mistake	Error	Fix
`import { PrismaClient } from './generated/prisma'`	`Cannot find module`	Use `./generated/prisma/client.js`
`new PrismaClient()`	`PrismaClient needs non-empty options`	Pass `{ adapter }`
`new PrismaClient({ datasourceUrl: url })`	`Unknown property datasourceUrl`	Use adapter pattern instead
Missing `"type": "module"` in package.json	ESM import errors	Add `"type": "module"`
`import { PrismaClient } from '@prisma/client'`	Wrong export	Use `./generated/prisma/client.js`

2.6 KiB Raw Permalink Blame History