how to store array of obejct in prisma orm

Question

i am working on prisma orm and nest js. i want to store the array of object in the prisma. any body know how to dot it?? this is my prisma model

 model User {
  id         String     @id @default(uuid())
  firstName  String
  lastName   String
  email      String     @unique
  password   String
  isVerified Boolean
  isActive   Boolean
  createdAt  DateTime   @default(now())
  updatedAt  DateTime   @default(now())
  avatar     String?
  companyId  String
  schedule   Json[] 
  Company    Company    @relation(fields: [companyId], references: [id], onDelete: Cascade)
  Problem    Problem[]
  Payments   Payments[]
}

but it give this error

any body know please rewrite this code

 const user = await this.prismaService.user.create({
    data: {
      email,
      firstName,
      lastName,
      password: hashedPassword,
      isActive: true,
      isVerified: false,
      companyId: company.id,
      schedule: [{
        key:"value1",
        key2:"value2"
      }],
    },

score 0 · Accepted Answer · answered Aug 05 '23 at 20:04

I assume you are using Typescript.

const scheduleJson = [{
        key:"value1",
        key2:"value2"
      }] as Prisma.JsonArray

const user = await this.prismaService.user.create({
    data: {
      email,
      firstName,
      lastName,
      password: hashedPassword,
      isActive: true,
      isVerified: false,
      companyId: company.id,
      schedule: scheduleJson,
    }

Source: official docs https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-json-fields#writing-to-a-json-field

how to store array of obejct in prisma orm

1 Answers1