I have a large (~65,000 lines) JSON file which is being used as data for a prisma postgres database in a Next.js project I'm working on. The file contains entries like so: [ { "NativeClass": "class-name", "Classes": [ // data…
I am using NextJs, Typescript, Prisma and MongoDb. Everything works fine when i run "npm run build". But when I am trying to deploy a project on Vercel, I am getting this error: Type error: Module '"@prisma/client"' has no exported…
this is Prisma Schema generator client { provider = "prisma-client-js" } datasource db { provider = "mysql" url = env("DATABASE_URL") relationMode = "prisma" } // Models model User { id Int @id @default(autoincrement()) type UserRole @default(PATIENT) patientRelations Patient? nurseRelations Nurse?…
I have a database table with two columns updated_at and children_updated_at and I would like to show the latest modified records first based on the SQL function GREATEST(updated_at, children_updated_at). The SQL query I'd like to generate is: select * from…
I am trying to seed my prisma db but am having trouble doing so with a user -> Payment relation. Seeder Code: export const userSeeder = async (prisma) => { const productIds = await getProductIds(prisma); const { gamingLaptopProductId, chairProductId, cologneProductId,…
I have this data in mongodb { items: [ { id: '6614005475802af9ae05b6b2', title: 'title', createdAt: '2024-04-08T14:33:56.734Z', }, { id: '6613fda792ffb86a14d266ea', title: 'testing', createdAt: '2024-04-08T14:22:30.880Z', }, { id: '6613fe3675802af9ae05b6a2', title: 'cool stuff', createdAt: '2024-04-08T14:24:54.580Z', } ] } How can I reorder…
Forgive my ignorance on creating schema. I am attempting to add a one to many relationship to a model with a compound ID. Here is that model: model UserPlantSpeciesInventoried { userId String user User @relation("user", fields: [userId], references: [id]) plantSpeciesId…
Techstack:Next.js 14, MongoDB, Prisma ORM. I have a many documents in my DB but I need random 15 documents each time I request... If I have to do the same thing using mongoose I can do this: const selectedProjects =…
I use Prisma and Postgresql for a project to store and manage recipes. I am struggling to implement a Many to Many relationship where I can constrain one side to require at least one value for the relation field. Recipes…
I have an input file with multiple images upload. I am adding them to Supabase storage as you can see in the server actions, it works fine. When I try adding the images URL's to the Prisma database it does…