CRUD operations with Prisma in NextJS - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does CRUD stand for in database operations?

CRUD stands for Create, Read, Update, and Delete. These are the four basic operations to manage data in a database.

beginner

How do you create a new record using Prisma Client in Next.js?

Use the prisma.model.create() method, where model is your database table name. Pass an object with a data property containing the new record's fields.

beginner

Which Prisma Client method is used to fetch multiple records from the database?

The method prisma.model.findMany() fetches multiple records. You can add filters or pagination inside its options.

intermediate

How do you update a record with Prisma Client?

Use prisma.model.update() with two main options: where to specify which record to update, and data to specify the new values.

beginner

What method does Prisma Client provide to delete a record?

Use prisma.model.delete() with a where option to specify the record to remove from the database.

Which Prisma Client method is used to add a new record?

A prisma.model.findUnique()

B prisma.model.delete()

C prisma.model.update()

D prisma.model.create()

The create() method adds a new record to the database.

How do you specify which record to update in Prisma?

A Using the <code>where</code> option

B Using the <code>data</code> option

C Using the <code>select</code> option

D Using the <code>include</code> option

The where option tells Prisma which record to update.

Which method fetches a single record by unique identifier?

A prisma.model.findUnique()

B prisma.model.create()

C prisma.model.findMany()

D prisma.model.delete()

findUnique() fetches one record by a unique field like ID.

What happens if you call prisma.model.delete() without a where clause?

A Deletes all records

B Throws an error

C Deletes the first record

D Updates the record instead

Prisma requires a where clause to know which record to delete; otherwise, it throws an error.

Which of these is NOT a CRUD operation?

A Create

B Read

C Render

D Delete

'Render' is not part of CRUD; CRUD stands for Create, Read, Update, Delete.

Explain how to perform all four CRUD operations using Prisma Client in a Next.js app.

Think about the methods Prisma provides for each operation.

Describe why the 'where' option is important in update and delete operations with Prisma.

Consider what would happen if Prisma didn't know which record to update or delete.