Object Relational Mapping

Objectives

1. Prisma ORM.
2. Prisma schemas and data source providers.
3. Prisma Migrate, Client, and Studio.

1 Task Tracker

Update the data repository service of 9.2 Task Tracker to use Prisma Client.

1. Install Prisma and initialize it with a SQLite provider:

   bun add --dev prisma
   bunx prisma init --datasource-provider sqlite --generator-provider prisma-client-js --output client

2. Define the data models using a Prisma schema:

   prisma/schema.prisma

   model Task { }

3. Use Prisma Migrate to create the database based on the schema, then access it using Prisma Studio:

   bunx prisma migrate dev --name init
   bunx prisma studio

4. Create a data repository service with CRUD methods and use Prisma Client to access the data store:

   repos/prisma.js

   import { PrismaLibSql } from "@prisma/adapter-libsql";
   import { PrismaClient } from "@/prisma/client/client";
    
   export default new PrismaClient({
     adapter: new PrismaLibSql({
       url: process.env.DATABASE_URL ?? "",
     }),
   });
   repos/tasks.js

   import prisma from "@/repos/prisma";

5. Create an API using Next.js and use the data repository service in all routes.

6. Test the routes using Postman (opens in a new tab).

2 Bank Accounts

Update the data repository service of 9.3 Bank Accounts to use Prisma Client.

1. Install Prisma and initialize it with a SQLite provider:

   bun add --dev prisma
   bunx prisma init --datasource-provider sqlite --generator-provider prisma-client-js --output client

2. Define the data models using a Prisma schema:

   prisma/schema.prisma

   model Account { }
    
   model Transaction { }

3. Use Prisma Migrate to create the database based on the schema, then access it using Prisma Studio:

   bunx prisma migrate dev --name init
   bunx prisma studio

4. Create a data repository service with CRUD methods and use Prisma Client to access the data store:

   repos/prisma.js

   import { PrismaLibSql } from "@prisma/adapter-libsql";
   import { PrismaClient } from "@/prisma/client/client";
    
   export default new PrismaClient({
     adapter: new PrismaLibSql({
       url: process.env.DATABASE_URL ?? "",
     }),
   });
   repos/accounts.js

   import prisma from "@/repos/prisma";
   repos/transactions.js

   import prisma from "@/repos/prisma";

5. Create an API using Next.js and use the data repository service in all routes.

6. Test the routes using Postman (opens in a new tab).

Structure

Resources

• Prisma ORM (opens in a new tab), Prisma Schema (opens in a new tab), Prisma Client (opens in a new tab), Prisma Client CRUD (opens in a new tab), Prisma Client relation queries (opens in a new tab)
• Prisma DBML Generator (opens in a new tab)
• Next.js Guides (opens in a new tab), How to create forms with Server Actions (opens in a new tab)