I'm developing a quite simple backend application with Express, using Prisma ORM to connect to a MongoDB database. The events collection is filled with documents such as: { "_id": string, "class_code": string "class_type": string, "created_by": string, "end_period": date, "end_time": time,…
I want to delete 2 models from a postgreSQL production database that are no longer used but have data on them. I am a bit afraid of removing them from the schema and running prisma migrate dev and then having…
I have a nextjs project that's using prismaDB for the ORM. I'm able to connect just fine to my local postgres db but I'm getting this error when running npx prisma migrate. Error: P1001: Can't reach database server at db-name.*.us-west-2.rds.amazonaws.com:5432.…
I am trying to update a record in prisma and it will not let me query the record with an update. I use the exact same where condition for both a findMany and the update but the update does not…
I'm using Prisma w/ Postgres and am trying to have a simple 1-to-many relationship with a User which can have zero or more Product(s). I'm able to create 1 product for a particular user but when I try to create…
A Product can have various sizes so I added one to many relation. But Each product can have only 1 unique size, i.e, in many to many the sizes should not repeat. For instance, Product X can have size 1,…
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…