การดำเนินการ CRUD ด้วย Prisma Client

Welcome! In this lesson, we'll master CRUD operations using Prisma Client. CRUD stands for Create, Read, Update, and Delete – the four fundamental operations for interacting with any database.

Prisma Client provides a type-safe and intuitive way to perform these actions, making your database interactions efficient and less error-prone.

Before performing any database operations, you need to instantiate the Prisma Client. This client is automatically generated based on your schema.prisma file and connects your application to the database.

You'll typically do this once in your application's entry point or a dedicated database module.

The Create operation adds new records to your database. With Prisma, you use the create method on a model to insert data.

• Specify the model (e.g., prisma.user).
• Provide the data for the new record in the data object.
• Prisma handles the SQL insertion for you!

Remember, this assumes you have a User model defined in your schema.prisma.

Let's create a new User record. Notice how Prisma Client provides autocompletion for fields like email and name, ensuring type safety.

Run this example to see a new user being added.

The Read operation retrieves data. To fetch multiple records, use the findMany method. You can filter results using the where clause, order them with orderBy, or limit them with take.

For example, prisma.user.findMany({ where: { name: 'Alice Smith' } }) would find all users named Alice Smith.

To fetch a single, unique record, use findUnique. This method requires a unique identifier (like an @id or @unique field in your schema) to ensure only one record is returned.

If you need to find the first record matching a non-unique condition, use findFirst. It returns null if no record is found.

Let's fetch all users and then find a specific user by their email using findUnique. This demonstrates how to retrieve both lists and individual items.

Run the code to see the results of these queries.

The Update operation changes existing records. The update method requires two main parts:

• A where clause to identify the record(s) to update.
• A data object containing the fields and new values to set.

Always ensure your where clause is specific enough to avoid unintended updates!

We'll update the user 'Alice Smith' to 'Alicia Wonderland'. Notice how we target the user with their unique email and then provide the new name.

After running, you can try fetching Alice again to see the updated name.

Finally, the Delete operation removes records from your database. The delete method, like update, requires a where clause to specify which record(s) to remove.

Be cautious with delete operations, as they are permanent! Always double-check your where condition.

Which Prisma Client method would you use to remove a specific user record from the database?

Great job! You've learned the core of database interaction using Prisma Client.

• Create (C): Use prisma.model.create() to add new records.
• Read (R): Use prisma.model.findMany() for lists, findUnique() or findFirst() for single records.
• Update (U): Use prisma.model.update() to modify existing records.
• Delete (D): Use prisma.model.delete() to remove records.

Prisma's type safety and intuitive API make these essential operations straightforward and robust in your Next.js applications.