Prisma ORM指南

// schema.prisma datasource db { provider = "postgresql" url = env("DATABASE_URL") } generator client { provider = "prisma-client-js" } model User { id Int @id @default(autoincrement()) email String @unique name String? createdAt DateTime @default(now()) posts Post[] profile Profile? } model Post { id Int @id @default(autoincrement()) title String content String? published Boolean @default(false) author User @relation(fields: [authorId], references: [id]) authorId Int tags Tag[] } model Tag { id Int @id @default(autoincrement()) name String @unique posts Post[] }

const prisma = new PrismaClient(); // 查找 const users = await prisma.user.findMany({ where: { email: { contains: '@example.com' } }, orderBy: { createdAt: 'desc' }, take: 10, skip: 0, include: { posts: { where: { published: true } } }, }); // 创建 const user = await prisma.user.create({ data: { email: 'alice@example.com', name: 'Alice', posts: { create: { title: 'First post' } }, }, }); // 更新 await prisma.post.update({ where: { id: 1 }, data: { published: true } }); // 删除 await prisma.user.delete({ where: { id: 1 } }); // 插入或更新 await prisma.user.upsert({ where: { email: 'alice@example.com' }, update: { name: 'Alice Smith' }, create: { email: 'alice@example.com', name: 'Alice Smith' }, });