Prisma

The official Discord server of Prisma! Find us online at prisma.io

Prisma

The official Discord server of Prisma! Find us online at prisma.io

7/24/2024

Finding model constraints in code

Hello, I'm looking for a way to find the foreign keys of a model in the Prisma client. Not by typing but in JS. I can't find anything, even after digging into the engine...

Inuk

7/24/2024

Recursive CTE

Hello all, I'm trying to make a recursive query, but I'm not sure where to start? I have something like the following model: ```js model Role {...

Solution:

I'm not sure I'm too satisfied with the answer, but I ended up writing a view to solve my issue, and then use seed.ts to ensure that it exists.

omgwot

7/24/2024

Is there any way to avoid this cast?

``` public forProject<T extends Prisma.unified_applicationDefaultArgs>( projectId: string, payload?: T, txn: Prisma.TransactionClient = this.prisma...

gave_one

7/23/2024

I have a nested create many query I am getting Unknown argument 'answers'

(v5.16.1) CockroachDB , I restarted the application I have removed all migration. I have re-migrated the data again. and push the data. But I'm still having this problem...

infinity

7/23/2024

Getting P2023 When getting params

I am getting this error message when getting params with the id: ``` code: 'P2023', clientVersion: '5.17.0', meta: {...

Kartik

7/23/2024

Ts Error for Prisma Json field with null value

SPEEDBIRD101

7/23/2024

$use but instead with $extends issue

Hey! i am trying to use $extends but i am having an issue here, here is what kappa told me and it worked perfectly: ```js...

SeeMe

7/23/2024

migrations folder

is there a way to have 2 migrations folders?

Deragon

7/23/2024

Cant add data to user table

Hey, Im just making a simple Gemini Nextjs App but the logic for adding additional credits after stripe payment isnt implementing Basically I want to create a user if it doesnt exist or update the user if it exist https://github.com/Raunak0713/AI_Content/...

JudgeJLo

7/22/2024

unrecognized keys some

I'm trying to write a query that returns a list of users where any of them have a related record in another table. It seemed that "some" would get me what I need based on the docs, but I'm getting an error about some being an unrecognized key.

Fervore

7/22/2024

Nested relation query help

Hello, I was trying to query users, then I added the implementation to show payments but now I realize it was bringing payments of all users from the membership instead of bringing all payments of that specific user for each specific membership. Is there a way to do this query in the same object or is there a way to reference the current user for each index of the array? ```prisma.user.findMany({ orderBy: { id: 'desc', },...

dinglebop

7/22/2024

Pulse local development + static IPs

two questions - What are your recommendations for connecting local developer environments with Pulse? Is there any kind of Docker emulator or something that we can use? - Does Pulse have static IPs? I see that's available for Accelerate but can't figure out if it is for Pulse...

Levan Parastashvili

7/22/2024

Error: 🟥 @prisma/react-native failed to initialize, js engine: hermes

getting this error message for expo da prisma connection db.ts in root directory ...

rohanrajpal

7/22/2024

Issues with prisma docker deployments

Hey, locally i am able to use prisma well, but when i deploy to docker, issues start popping up, like this one: ``` 2024-07-22 22:57:55.535
PrismaClientValidationError:...

tom_bombadil

7/22/2024

Dynamic Filtering items with prisma and Nextjs?

Oi everyone! I use prisma in combination with Nextjs and mongodb on a project that deals with animal adoption. Namely, now I would like to do dynamic filtering by certain categories and enable it to interact with the user on the client side. Well, I'm interested in whether it's feasible to do it using prism, since I found out through the documentation that I can filter out certain things via the where: { } query. Any help and suggestions on how to do this are welcome. Thank you all!...

Oli

7/22/2024

creating a record attempting to update it shortly after causes error

The code provided in the screenshot gives me this error

``
Invalid

prisma.hosting_ticket.update()` invocation in D:\Coding\Birdflop\botflop-panel\src\functions\tickets\createTicket.ts:84:33 82...

matsyui

7/22/2024

Not updating types

i made changes so i go db pull and its not updating types....

CNY

7/22/2024

docker container problem

Hi i always got this problem when running docker container with prisma, what should i do?

Uncle

7/21/2024

Help with findFirst and none relations

I'm working on seeding my database for a self storage and I'm trying to randomly select a customer with no leases and assign them a lease. This is my code and it's alway returning the same customer: ` const customer = await prisma.user.findFirst({ where: { customerLeases: { none: {}...

ms. cobel

7/21/2024

Can't see relation field in Types

Hi, How do I make stages visible in my code? (What I mean is in the image attached, stages doesn't appear on the types for ProjectPage.) ```ts model ProjectPage {...

Previous Next

Gaming

Programming

Prisma

The official Discord server of Prisma! Find us online at prisma.io

Prisma

The official Discord server of Prisma! Find us online at prisma.io