I tried it like this:

Mutation: {
    createPost: (parent, args) => {
      return prisma.content.create({ 
        postinput: {
            name: args.name,
            content: args.content
          
        }
        
      })
    }
  }

But it is not working and giving me the following error: Unknown arg

postinput

in postinput for type Content. Did you mean

select

?\nArgument data is missing.

When I get rid of the “CreatePostInput” input type and design the Mutation like this:

type Mutation {
    createPost(name: String, content: String): Post!
  }

and my resolver like this:

Mutation: {
    createPost: (parent, args) => {
      return prisma.content.create({ 
        data: {
            name: args.name,
            content: args.content
          
        }
        
      })
    }
  }

it is working fine The problem is I want to keep the PostCreateInput input to add a lot of fields there

Hey guys, Which is the best approach to apply permissions and authentication to prisma?

Hi! Is there a possibility to multiply two fields with each other in findMany in order to fetch one additional field with the multiplied value? Or should I use raw query if I want to achieve this?

Hello 🙂

Could someone help me understand tradeoffs of not using GIS for location data? I really want to use Prisma, but this is an important requirement in a platform I am working on Was wondering if storing latitude and longitude would be enough

Hi guys, is there anyway to enforce model names conventions in prisma.schema? with eslint or something?

Hi guys it is possible to do something like that, i want the function to execute first prisma.pageview.create then update

export async function savePageView(website_id, session_id, url, referrer) {

 

const ref = new Referer(referrer);

 

return runQuery(

   

prisma.pageview.create({

     

data: {

       

website_id,

       

session_id,

       

url: url?.substr(0, URL_LENGTH),

       

referrer: (await getRef(referrer)) //put referrer "direct" if parameters in function is empty,

       

referrer_group: ref.referer ? ref.referer : ref.uri.hostname,

       

referrer_medium: ref.medium,

     

},

   

}),

   

prisma.pageview.update({

     

where: {

       

referrer: "direct",

     

},

     

data: {

       

referrer_group: "Visites directes",

     

},

   

})

 

);

}

Why guys when i run this (pic) it returns me this error : PrismaClientValidationError: Unknown arg

referrer

in where.referrer for type pageviewWhereUniqueInput. Did you mean

select

?"

Has anyone worked with a custom implementation of Soft-Delete functionality? How can I filter in middleware relations like

where: { deletedAt: null }

? Middleware is only called once on

findUnique()

call, but I want a middleware to run on every query operation. The following:

await prisma.cart.findFirst({
  where: { id: 107 },
  include: { foods: true } },
});

will call middleware

prisma.$use()

only once, and not for the DB query when fetching the relation

foods

is there way i can get time series data in prisma ?

Hey does someone know how to programmatically create users and login to these with next-auth ? (I got this error

OAuthAccountNotLinked

from next-auth due to prisma seed)

Any thoughts on the best way to handle something similar to postgres time data type. I need to store the start time for a shift without any concept of date. I was thinking maybe just a string field

Prisma 1 user transitioning to Prisma 2/3 with a basic question. How do I get the scalar model types from Prisma? E.g. in Prisma 1, it's...

import { Deal } from "prisma1/generated/prisma-ts"

const calculateDealProfit = (deal: Deal): number => {
 ....
}

Uhh

I encountered a bug

prisma will not name capatalized models correctly in the generated class

ie

Note -> note

this is especially annoying when dealing with acronyms...

Anyone know how to deal with deleting data from a table which contains a self referencing foreign key with prisma? Normally I would delete the orphaned data first, but doesn't seem to be working?

Referential actions?

I just started trying out the fluent API and I've noticed that if the last call doesn't find any records, the query returns null instead of an empty array like you would get from

findMany()

which is a bummer because if I just return that to Apollo it throws an error like

"message": "Cannot return null for non-nullable field Query.employeeNotes."

. Is this a known issue that will get fixed? In the meantime as a workaround I have to await the result of the query and use the nullish coalescing operator to return an empty array if there are no results:

async getEmployeeNotes(employeeId: string): Promise<EmployeeNote[]> {
    return (
      (await prisma.employee
        .findUnique({
          where: {
            id: employeeId,
          },
        })
        .employeeNotes()) ?? []
    )
  },

This syntax seems more straightforward:

getEmployeeNotes(employeeId: string): Promise<EmployeeNote[]> {
    return prisma.employeeNote.findMany({
      where: {
        employeeId,
      },
    })
  },

I'm just not sure which is better performance-wise in terms of the number of queries created and the GraphQL n+1 problem which I don't understand yet but plan to read up on.

Hello team, is there any progress on this issue ? https://github.com/prisma/prisma/issues/8989

Our CI time almost doubled because we can’t run jest in one go anymore. We have to run it in batch and we’re paying jest’s bootstraping the environment cost for every batch 😅

How can I catch this kind of error?

Unknown arg `country` in data.country for type RegionUncheckedUpdateInput. Did you mean `countryId`? Available args:
type RegionUncheckedUpdateInput {
  id?: String | StringFieldUpdateOperationsInput
  name?: String | StringFieldUpdateOperationsInput
  createdAt?: DateTime | DateTimeFieldUpdateOperationsInput
  updatedAt?: DateTime | DateTimeFieldUpdateOperationsInput
  countryId?: String | StringFieldUpdateOperationsInput
}

This is probably not

PrismaClientKnownRequestError

cause it's missing my nest filter.

Hi, I'm having issues using a many-to-many self-relation similar to the example used in the Prisma docs. I'm running into an error when creating a record along with its relation. The error I'm getting is this.

PrismaClientValidationError: Unknown arg `follower` in data.followers.create.0.follower for type FollowsCreateWithoutFollowerInput. Did you mean `following`?
 Argument following for data.followers.create.0.following is missing.

I posted this question with more details on stackoverflow https://stackoverflow.com/questions/70520589/prisma-many-to-many-self-relation-error-due-to-relation-and-generated-type-inpu If anyone has any ideas I would greatly appreciate it. Thanks in advance.

Hi, has anyone got any (recent) tips for pairing Prisma with a storage solution? I'm looking to store audio files generated via a text-to-speech API. The files need to be retrievable by the user, once generated.

The typical go-to for that is S3 or an S3-compatible object storage service (or self hosted Minio)