I am trying to retrieve the full record I have changed with an

update

call, is it possible to do some sort of

select: { all }

instead of manually selecting each field like this?

select: {
          id: true,
          name: true,
          street: true,
          zipCode: true,
          city: true,
          person: true,
          email: true,
          telNr: true,
          faxNr: true,
        },

Do we have any library with the help of which i can upload file fromt front-end or client side instead of server/backend?

What’s the easiest way to see what SQL query is generated by a certain prisma invocation?

Hey everyone, I currently have an implicit many-to-many relation in my database model. I want to switch to an explicit definition, and add some metadata to this relation. Is there any guide or best practices for this? It seems like a painful process to do manually.

Lets say i have a monrepo, i have introspected models from the database and they now live in schema.prisma.

backend/
  prisma/
    schema.prisma
frontend/

I wanted to share types between the frontend and backend and because its a monorepo i can simply create

shared

folder.

shared/
backend/
frontend/

if i want to reuse types that are generated by Prisma in the frontend whilst also using them in the backend, how might i do this? Does this even make sense to do, "should" i move the prisma stuff over to the shared directory? Or should i really be creating a new seperate type for my api responses, even though in majority of the cases im simply returning a 1:1 of table columns and object fields.

Is it not advisable to use the spread operator as an argument to a

data

param? For example:

const store = await this.prisma.store.create({
  include: { accounts: true, shopifyOfflineSession: true },
  data: {
    ...options,
  }
}

I’ve not tested it thoroughly but it feels that types aren’t strictly checked like this.

not sure if this is a dumb q. It works when I do:

const pendingRequest = await prisma.connection_request.findFirst({
            where: {
                initiator_id: targetUserProfileId,
                requested_id: authUserProfileId,
            }
        })

But throw error Type ‘{ initiator_id: any; requested_id: number; }’ is not assignable to type ‘connection_requestWhereUniqueInput’. Object literal may only specify known properties, and ‘initiator_id’ does not exist in type ‘connection_requestWhereUniqueInput’. when I do

await prisma.connection_request.update({
                where: {
                    initiator_id: targetUserProfileId,
                    requested_id: authUserProfileId,
                },
                data: {
                  confirmed_at: new Date(),
                },
              })

How can I fix it?

I replaced update with updateMany to get rid of the error for now. Sounds like to use

update

the record has to be unique… The schema does have a that forced tho.

@@unique([initiator_id, requested_id], map: "connection_request_idx_initiator_id_requested_id")

Hey guys, does prisma support CHECK constraint out of the box? Like defining it in the schema.

Prisma Day is Live! 🎉 prisma rainbow

The Prisma Data Platform is now Generally Available The Prisma Data Platform includes a Data Proxy, a Data Browser, and a Query Console that integrates with your current development pipeline.

whats the best way to debug this error. It was working fine before. No idea why it throws this one.

Thanks for a fantastically well organized Prisma day yesterday! It was so fun to meet everyone in person. Props to the the Prisma team and all the presenters for great talks! Hope to meet you all again very soon 😊

@Nurul Is there any way to return relation model field with the help of groupBy

I want to build a simple Home Feed like Instagram where the users sees new posts of the people he follows. So I try to findMany posts where the author of the post is followed by the user who’s requesting. Here is how I imagined it to work:

return prisma.post.findMany({  
        where: {
          author: {
            followers: {
              followerId: args.uid
            }
          } 
        }, 
        include: {
          author: { 
            include: {
              followers: {
                where: { 
                  followerId: args.uid
                },
              }
            }
          }
        }
      })

But unfortunately it tells me `"Unknown arg

followers

in where.author.followers for type UserRelationFilter. Available args:",` More in thread

Hey, how would I generate a full .sql migration file as if my db was brand new?

Is the only way just to nuke the DB and redo the migration?

Hey guys, how’s it going ? Does anyone have an example of fetching data from an external source (i.e Github API) using Prisma for a rest API ?

Hello everyone i have a scnerio in project inwhich i have to upload large file to gcp bucket but i don't know how to resolve this problem my backend is on nodejs and frontend is on reactjs.Now how i can send chunks of a file and supload file to gcp bucket chunk by chunk and want a whole file uploaded url after every chunk get uploaded to gcp bucket successfully i also want a resumable functionality so that if internet connection lost or something happen bad it resume the file upload process i'm searching for 3 days but i'm not able to figure out any solution yet plz help.

This message was deleted.

I'm trying to implement the new data proxy connection string for my nextJs project and when I push to Vercel I get the error:

Error validating datasource `db`: the URL must start with the protocol

postgresql://

or

postgres://

To use a URL with protocol

prisma://

the Data Proxy must be enabled via

prisma generate --data-proxy

.

But as per the docs, I have added the line "PRISMA_GENERATE_DATAPROXY=true" into my .env.production, yet somehow it just seems ignored?

Question: I am trying to update column names. When I run yarn migrate dev, I get "Prisma Migrate could not create the shadow database. Please make sure the database user has permission to create databases. Read more about the shadow database (and workarounds) at https://pris.ly/d/migrate-shadow". This isn't my repo nor Heroku. My question is, how would the owner go about giving me access to update column names? Or is it something simpler?

Is there a way of pushing multiple items to an array? MongoDB supports it but couldn't find a way to do it in prisma?

I want to build a simple Home Feed like Instagram where the users sees new posts of the people he follows. So I try to findMany posts where the author of the post is followed by the user who’s requesting. Here is how I imagined it to work:

return prisma.post.findMany({   
        where: {
          author: {
            some: {
              followers: { 
                followerId: {
                  equals: args.userId
                 } 
              }
            }
          }
        },
        include: {
          author: {   
            include: {
              followers: {
                include: {
                  follower: true
                }
              }
            }
          }
        }
      })

But unfortunately it tells me "Unknown arg

some

in where.author.some" (Schema in thread)

Never leaving Typescript! Thank you Prisma😄

How can I make an optional

unique

input field

phone

NULL

instead of "`undefined`" for missing input. PostgreSQL guarantees uniqueness even for

NULL

fields but not for

undefined

values.

model User {
  id                String          @id @default(cuid())
  email             String          @unique
  phone             String?         @unique
  @@map(name: "user")
}

Hi! How do you guys store images in the database? I have this model here that seems perfect, but if I wanna use it in (for example) 10 different models I would have to make a relation for every model which seems kinda annoying. An alternative would be to just store something like "imageId" in the user model (or basically any model that needs to have an image) and since I'm using graphql it wouldn't be as much of an issue. Does my solution seem good?

model Image {
  id Int @id @default(autoincrement())

  publicId String
  width    Int
  height   Int
  url      String

  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

Hello everyone as you may knew that gcp provides an ability to store files via presignedUrl my question is this can we upload chunk of files using this presignedUrl i am not able to clear about this anyone please?

Took 2 days, but I finally got the form submit to add to the database as it should!

hi, anyone knows how to do conditional search condition? I.e if I only want to search for not null name if my variable is true

prisma.people.findMany({ where: { what here? }})