Prisma ORM setup in NextJS - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to import PrismaClient from the Prisma package.

NextJS

import { [1] } from '@prisma/client';

Drag options to blanks, or click blank then click option'

APrismaClient

BPrisma

CClient

DPrismaService

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Prisma' instead of 'PrismaClient' causes import errors.

Trying to import 'Client' alone will not work.

You need to import PrismaClient to interact with your database using Prisma.

2fill in blank

medium

Complete the code to create a new PrismaClient instance.

NextJS

const prisma = new [1]();

Drag options to blanks, or click blank then click option'

APrisma

BClient

CPrismaClient

DPrismaService

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Prisma' instead of 'PrismaClient' causes runtime errors.

Forgetting the 'new' keyword will cause errors.

You create a new instance of PrismaClient to start querying your database.

3fill in blank

hard

Fix the error in the code to correctly export the Prisma client instance.

NextJS

export const prisma = [1];

Drag options to blanks, or click blank then click option'

Anew PrismaClient()

BPrismaClient()

CprismaClient

Dnew prismaClient()

Attempts:

3 left

💡 Hint

Common Mistakes

Calling PrismaClient without 'new' causes errors.

Using lowercase 'prismaClient' instead of 'PrismaClient' is incorrect.

You must export the instance created with new PrismaClient() to use it elsewhere.

4fill in blank

hard

Fill both blanks to write a Prisma query that fetches all users.

NextJS

const users = await prisma.[1].[2]();

Drag options to blanks, or click blank then click option'

Auser

BfindMany

CfindFirst

Dusers

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'users' instead of 'user' for the model name causes errors.

Using 'findFirst' returns only one record, not all.

Use prisma.user.findMany() to get all user records from the database.

5fill in blank

hard

Fill all three blanks to write a Prisma query that creates a new post with a title.

NextJS

const newPost = await prisma.[1].[2]({ data: { title: [3] } });

Drag options to blanks, or click blank then click option'

Apost

Bcreate

C`My first post`

Dupdate

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'update' instead of 'create' will not add a new record.

Forgetting to wrap the title string in quotes or backticks causes syntax errors.

Use prisma.post.create() with a data object to add a new post. The title is a string wrapped in backticks.