I have a NodeJS/NestJS project consisting of multiple microservices. I've deployed my postgres database and also a microservice pod which interact with the database, on an aws kubernetes cluster. I'm using Prisma as ORM and when I exec into pod…
I am building a nextjs 13 site on github actions and deploying statically to vercel. It usses prisma and I get this error in the runtime logs from vercel: 2022-12-12T01:07:00.163Z 2022-12-12T01:07:00.196Z 2581999e-981c-4f05-a35d-f6f467934166 INFO PrismaClientInitializationError: Query engine library for current platform…
I am using prisma with mongoDb for the first time and I want to update a boolean value stored in a collection, but I am not able to find a way/query to update the value from true to false or…
model Comment { id Int @id @default(autoincrement()) cid String bid String author AppProfile @relation(fields: [bid], references: [bid]) comment String created DateTime @default(now()) } const results = await prisma.comment.create({ data: { cid: req.body.cid, comment: req.body.comment, bid: appProfile.bid, }, }); prisma:query INSERT…
async function change_status(object_id:number){ const response = await fetch('/api/db', { method: 'POST', body: JSON.parse(`{"id":${object_id}}`) }); if (!response.ok){ throw new Error(response.statusText); } return await response.json(); } I want this button to change an int in mysql <button onClick={() => change_status(object.id)}> change Status…
I'm trying to use docker-compose to run a project with two Docker containers, MySQL and NodeJS. I'm having trouble connect to the SQL container from the backend container. My backend container uses Prisma as it's ORM and shows me the…
I'm having a problem when running the npx prisma migrate dev command. Docker desktop tells me that the database is running correctly on port 5432 but I still can't see the problem. I tried to put connect_timeout=300 to the connection…
Given a user id, I want to find the followers that the user follows (i.e. follow each other) My Prisma model looks like the following: model User { id Int @id @default(autoincrement()) name String? followedBy Follows[] @relation("following") following Follows[] @relation("follower")…
This might be a dumb and simple question, but since I am a completely newbie I could not find a workaround. Lets say I have these users in the DB : Me with maxScore : 4 John with maxScore: 3…
The simplest example I can give, is a User that can create multiple Posts. A one-to-many relationship where multiple posts can be tied to a single user. But what if I want the User to only be able to have…