Install the Prisma VS Code Extension

Initialize Prisma in a TypeScript Node Project

Create a Model for a Table and Run Migrations

Use Prisma Studio to Create a Record

Use Prisma Client to Find Many Records in a Table

Use Prima Client to Select a Subset of Data

Create a Database Record with Prisma Client

Use Express to Create Data Dynamically

Create a Relation Between Two Tables in the Prisma Schema

Use Prisma Client to Query for Related Data

Use Prisma Client to Connect Related Tables when Creating New Data

Limit the Amount of Returned Data with Prisma Client

Build a Backend with Prisma in a TypeScript Node Project

Prisma Client offers methods to create new database records. These methods accept a data object and return the result to be consumed by clients. In this lesson, we use Prisma Client's create method to create new records in the database.

Ryan Chenkie: [0:00] Prisma gives us methods to create data. We can create an endpoint here to add new products. Let's copy over the get endpoint. We'll make it a post endpoint going to products. In the handler, we can add in new products.

[0:13] Our constant of product now, singular, will be a call to await prisma.product.create(). The create method needs an object, on which we need to have a data key. Supply an object to the create method, put in a data key, and then on the data object, put in values for all of the columns that we'll need.

[0:33] On Mac OS, we can do Control-Space bar to find the property names that are required. We can supply name, description, and price.

[0:48] Save the call to create and then open up a res client to make a POST request to the products endpoint. To stick within VS Code, you can try Thunder Client. It's an extension that you can install in the Extensions Marketplace.

[1:03] We get back the new record with a unique id, and we can verify within Prisma Studio that the record was created.

Course

Build a Backend with Prisma in a TypeScript Node Project

Create a Database Record with Prisma Client

Share this video with your friends