跳到主要内容

快速开始

准备

nodejs 版本高于 v14.17.0

1 创建项目

# 创建文件夹
mkdir hello-prisma
cd hello-prisma
# 初始化
npm init -y
# 安装依赖
npm install typescript ts-node @types/node --save-dev

配置 typescript

touch tsconfig.json
{
"compilerOptions": {
"sourceMap": true,
"outDir": "dist",
"strict": true,
"lib": ["esnext"],
"esModuleInterop": true
}
}

安装依赖

npm install prisma --save-dev

初始化数据源

npx prisma init --datasource-provider sqlite

2 创建模型

model User {
id Int @id @default(autoincrement())
email String @unique
name String?
posts Post[]
}

model Post {
id Int @id @default(autoincrement())
title String
content String?
published Boolean @default(false)
author User @relation(fields: [authorId], references: [id])
authorId Int
}

3 创建数据库

npx prisma migrate dev --name init

4 通过 Prisma Client 体验数据库操作

增加数据

// touch script.ts
import { PrismaClient } from "@prisma/client";

const prisma = new PrismaClient();

async function main() {
// ... you will write your Prisma Client queries here
const user = await prisma.user.create({
data: {
name: "Alice",
email: "alice@prisma.io",
},
});
console.log(user);
}

main()
.then(async () => {
await prisma.$disconnect();
})
.catch(async (e) => {
console.error(e);
await prisma.$disconnect();
process.exit(1);
});

执行命令

npx ts-node script.ts

查询数据

async function main() {
const users = await prisma.user.findMany();
console.log(users);
}

关联创建

const user = await prisma.user.create({
data: {
name: "Bob",
email: "bob@prisma.io",
posts: {
create: {
title: "Hello World",
},
},
},
});

关联查询

const usersWithPosts = await prisma.user.findMany({
include: {
posts: true,
},
});
console.dir(usersWithPosts, { depth: null });

5 使用 GUI 操作数据库

npx prisma studio