Name: Use Prisma Client to Query for Related Data
Uploaded: 2021-07-12T10:53:12-05:00
Description: When two tables are related to one another, we can use Prisma Client to query for data through those relations. In this lesson, we see how to use Prisma Client to tie together data from two separate tables and pull it out in a nested fashion.

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

When two tables are related to one another, we can use Prisma Client to query for data through those relations. In this lesson, we see how to use Prisma Client to tie together data from two separate tables and pull it out in a nested fashion.

https://app.egghead.io/api/v1/lessons/prisma-use-prisma-client-to-query-for-related-data/subtitles

Ryan Chenkie: [0:00] Prisma Studio is aware of the relations between different tables. This makes it easy to manage data. If we add a record for a new review and give it a rating, we can then choose which product we want to assign this review to. Let's say that it should go to the first one, which is shoes.

[0:18] We can save this record, and we now have one review with a relation to a product. If we check out that product, we can see the review that is related. Prisma Client allows us to easily pull out this relation information when we make queries.

[0:33] In the call to the products endpoint to get all the products, add some information to tell Prisma Client that we want to get the review as well. In the findMany call, add an object with the include keyword and say that we want to include reviews true. Save the endpoint and check it out in the browser.

[0:54] Reviews shows up as an array because it is a one-to-many relationship between product and review. For cases where there are no reviews, the array is just empty.

Use Prisma Client to Query for Related Data

Share this video with your friends

Course

Build a Backend with Prisma in a TypeScript Node Project