Object Relational Mapping

Objective

Complete the 6 Relational Mapping guide to create a sample application that uses ORM.

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

Install Prisma and initialize it with a SQLite provider:

npm install --save-dev prisma
npx prisma init --datasource-provider sqlite --output ./client

Define the data models using a Prisma schema:
prisma/schema.prisma
```
model Task { }
```
Use Prisma Migrate to create the database based on the schema, then access it using Prisma Studio:
```
npx prisma migrate dev --name init
npx prisma studio
```

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

repos/prisma.js

import { PrismaClient } from "@/prisma/client";
const prisma = new PrismaClient();
export default prisma;

repos/tasks.js

import prisma from "@/repos/prisma";

Complete the 7 Server Actions guide to learn more about server actions.

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

Install Prisma and initialize it with a SQLite provider:

npm install --save-dev prisma
npx prisma init --datasource-provider sqlite --output ./client

Define the data models using a Prisma schema:
prisma/schema.prisma
```
model Account { }
 
model Transaction { }
```
Use Prisma Migrate to create the database based on the schema, then access it using Prisma Studio:
```
npx prisma migrate dev --name init
npx prisma studio
```

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

repos/prisma.js

import { PrismaClient } from "@/prisma/client";
const prisma = new PrismaClient();
export default prisma;

repos/accounts.js

import prisma from "@/repos/prisma";

repos/transactions.js

import prisma from "@/repos/prisma";