Prisma designs a personalized function within the schema

Question

Prisma designs a personalized function within the schema

In my mongo collection, there is a field named amount. My requirement is to have the amount automatically divided by 100 whenever it is requested. In Django, this can be achieved with a custom function within the model. Here's how I implemented it:

class Book(models.Model):
    title = models.CharField(...)
    price = models.IntegerField()

    
    def get_price(self):
        return self.price // 100

I'm curious about the Prisma equivalent of this in TypeScript.

I tested out the Django implementation and it worked well. Now, I am looking for guidance on how to implement the same logic in a Prisma setup within NestJS.

class Book(models.Model):
    title = models.CharField(...)
    price = models.IntegerField()

    
    def get_price(self):
        return self.price // 100

typescript django-models prisma plumatic-schema

Answer 1

Answer №1

After some thorough research in the Prisma documentation, I discovered a solution that involves using custom fields to query results.

The implementation looks like this:

const xprisma = prisma.$extends({
  result: {
    user: {
      fullName: {
        // specify dependencies
        needs: { firstName: true, lastName: true },
        compute(user) {
          // define computation logic
          return `${user.firstName} ${user.lastName}`
        },
      },
    },
  },
})

const user = await xprisma.user.findFirst()

// output the user's full name, for example "John Doe"
console.log(user.fullName)

For more details, check out the official documentation.

Answer 2

After some thorough research in the Prisma documentation, I discovered a solution that involves using custom fields to query results.

The implementation looks like this:

const xprisma = prisma.$extends({
  result: {
    user: {
      fullName: {
        // specify dependencies
        needs: { firstName: true, lastName: true },
        compute(user) {
          // define computation logic
          return `${user.firstName} ${user.lastName}`
        },
      },
    },
  },
})

const user = await xprisma.user.findFirst()

// output the user's full name, for example "John Doe"
console.log(user.fullName)

For more details, check out the official documentation.

Prisma designs a personalized function within the schema

Answer №1

Similar questions

Priority is given to strings over numbers

React Native Material - Implementing a loading indicator upon button press

How to define a TypeScript recursive object with a defined endpoint?

Factory Pattern Utilizing Enum for Field Population

The Ionic search bar will only initiate a search once the keyboard is no longer in view

The Child/Parent arguments in Typescript methods cannot be assigned

How can you resolve the error message "No overload matches this call." while implementing passport.serializeUser()?

Encountered a bug in the findUnique function within the services of a Nest JS and Prisma project

Error in AWS Lambda: Module 'index' not found

Facing an issue with the TypeScript error in the Tailwind-Styled-Component Npm package. Any suggestions on how to troub

What is the best way to showcase a file edited in Emacs within Atom?

What is the process for retrieving the GitHub username in the GitHub OAuth Next.js sign-in callback in order to store it in a database?

The .map() operator requires a declaration or statement to be specified - TS1128 error

Tips for sorting an array with various data types in TypeScript while explicitly defining the type

Using RxJs in Angular, you can invoke an observable from within an error callback

In my coding project using Angular and Typescript, I am currently faced with the task of searching for a particular value within

When trying to save a child entity, TypeORM's lazy loading feature fails to update

Sharing data from a Provider to a function in React can be done through various methods

Adjust the alignment of divs in Angular

What is the correct way to include a new property in the MUI Link component using TypeScript?