Comments (3)
Example to use Prisma Client Extensions.
-
Install Prisma Client v4.7.0 or later and install [email protected]
-
Enable
clientExtensions
preview
datasource db {
provider = "sqlite"
url = "file:dev.db"
}
generator client {
provider = "prisma-client-js"
previewFeatures = ["clientExtensions"]
}
model User {
id String @id @default(cuid())
email String @unique
name String?
}
- Create a file for the Prisma extension
prisma.extension.ts
import { PrismaClient } from '@prisma/client';
/**
* TS error: "Inferred type of this node exceeds the maximum length the compiler will serialize" with "declaration": true in tsconfig
*
* Change "declaration": false in `tsconfig.json`
*
* https://github.com/prisma/prisma/issues/16536#issuecomment-1332055501
*/
export const prismaClient = new PrismaClient().$extends({
model: {
user: {
findByEmail: async (email: string) => {
return prismaClient.user.findFirstOrThrow({ where: { email } });
},
},
},
});
export type prismaClient = typeof prismaClient;
- Change
declaration
tofalse
in yourtsconfig.json
- workaround for prisma/prisma#16536 (comment)
The inferred type of this node exceeds the maximum length the compiler will serialize. An explicit type annotation is needed.
- Use
CustomPrismaModule.forRootAsync
import { Module } from '@nestjs/common';
import { CustomPrismaModule } from 'nestjs-prisma';
import { AppController } from './app.controller';
import { AppService } from './app.service';
import { prismaClient } from './prisma.extension';
@Module({
imports: [
CustomPrismaModule.forRootAsync({
name: 'PrismaService',
useFactory: () => {
return prismaClient;
},
}),
],
controllers: [AppController],
providers: [AppService],
})
export class AppModule {}
- Inject
CustomPrismaService
into your controller/service
import { Inject, Injectable } from '@nestjs/common';
import { CustomPrismaService } from 'nestjs-prisma';
import { prismaClient } from './prisma.extension';
@Injectable()
export class AppService {
constructor(
// ✅ use `prismaClient` from extension for correct type-safety
@Inject('PrismaService')
private prismaService: CustomPrismaService<prismaClient>,
) {}
users() {
return this.prismaService.client.user.findMany();
}
user(userId: string) {
// 🦾 use new `findByEmail`
return this.prismaService.client.user.findByEmail(userId);
}
}
from nestjs-prisma.
Thank you for the example. That helps a lot to understand how to use extension with new dev release version, but is there a way we can use extension in existing PrismaService or anyway to override that?
from nestjs-prisma.
hi @shoaibsharif haven't found a way to use extension with the existing PrismaService
as the service is directly extended by the default PrismaClient
. For now you need to use CustomPrismaService
.
from nestjs-prisma.
Related Issues (20)
- When will nestjs 10 be supported? HOT 2
- use extension instead of middleware HOT 1
- Error: "beforeExit" hook is not applicable to the library engine since Prisma 5.0.0, it is only relevant and implemented for the binary engine. Please add your event listener to the `process` object directly instead. HOT 8
- Options fail with latest nest cli HOT 2
- Prisma 5.0.0 Upgrade HOT 1
- PrismaService generator generates deprecated code HOT 3
- feat: add option to use generic http messages in Prisma exception filter HOT 1
- applicationRef undefined in nest e2e tests HOT 1
- error TS2307: Cannot find module '@nestjs-prisma' or its corresponding type declarations. HOT 1
- Extensions: `create` and `update` broken HOT 1
- Using extension packages (read replica) HOT 7
- Custom Prisma Client is not working HOT 13
- Bump prisma version HOT 2
- Link on `middleware` broken HOT 1
- CustomPrismaService unit testing HOT 2
- Feature Request: add support for using PrismaClientExceptionFilter as a controller/gateway/method level filter
- Possibility to use extensions and this.prisma. HOT 2
- Excessive Database Connections When Using Prisma with PgBouncer in PM2 Clustered Environment HOT 3
- Support for Multiple Database Clients in NestJS Prisma Module HOT 2
- How can we use it with ZenStack HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from nestjs-prisma.