0
Jump into concepts and practice - no test required
Recommended
Prisma ORM helps you easily work with databases in your Next.js app. It turns database data into simple JavaScript objects you can use.
npx prisma init // Then edit prisma/schema.prisma to define your data models // Generate Prisma client npx prisma generate // Use Prisma client in your Next.js code import { PrismaClient } from '@prisma/client' const prisma = new PrismaClient()
npx prisma init creates the basic setup files.
You define your database tables as models in schema.prisma.
model User {
id Int @id @default(autoincrement())
name String
email String @unique
}const users = await prisma.user.findMany()
const newUser = await prisma.user.create({ data: { name: 'Anna', email: 'anna@example.com' } })
This Next.js compatible code creates a user and then fetches all users from the database. It logs the results to the console.
import { PrismaClient } from '@prisma/client' const prisma = new PrismaClient() async function main() { // Create a new user const user = await prisma.user.create({ data: { name: 'John Doe', email: 'john@example.com' } }) // Fetch all users const allUsers = await prisma.user.findMany() console.log('Created user:', user) console.log('All users:', allUsers) } main() .catch(e => console.error(e)) .finally(async () => { await prisma.$disconnect() })
Always run npx prisma generate after changing your schema.
Use environment variables to keep your database URL safe.
Disconnect Prisma client after use to avoid open connections.
Prisma ORM makes database work simple and safe in Next.js.
Define your data models in schema.prisma.
Use Prisma client to create, read, update, and delete data easily.
schema.prisma file in a Next.js project using Prisma ORM?schema.prismaschema.prisma. Styling is done with CSS or styling libraries.schema.prisma = data models [OK]new keyword to create an instance: new PrismaClient().schema.prisma:
model Post {
id Int @id @default(autoincrement())
title String
published Boolean @default(false)
}
What will be the result of this Prisma Client query?
const posts = await prisma.post.findMany({ where: { published: true } });
console.log(posts);published. The query filters posts where published is true.findMany returns an array of all matching posts, so it returns all posts with published: true.import { PrismaClient } from '@prisma/client';
const prisma = new PrismaClient();
export default async function handler(req, res) {
const user = await prisma.user.findUnique({ where: { id: req.query.id } });
res.json(user);
}
But you get an error: TypeError: Cannot read property 'id' of undefined. What is the likely cause?Cannot read property 'id' of undefined, meaning req.query is undefined or id is missing.?id=someValue so req.query.id exists.req.query object is undefined or missing id -> Option CComment related to Post in your Prisma schema, where each comment belongs to one post. Which of the following schema additions correctly sets up this relationship?postId and a relation field post with @relation specifying fields and references.comments field as an array of Comment to represent one-to-many relation.