본문 바로가기

Front-End

Prisma CRUD 함수 정리

반응형

await prisma.modelName.create({
  data: { ... }
})

 

await prisma.modelName.createMany({
  data: [ {...}, {...}, ... ],
  skipDuplicates: true // (옵션)
})

 

await prisma.modelName.delete({
  where: { id: 값 }
})

 

await prisma.modelName.deleteMany({
  where: { 조건 }
})

 

await prisma.modelName.upsert({
  where: { id: 값 },
  update: { ... },
  create: { ... }
})

 

await prisma.cms_board_data.count({
  where: { board_key: 'notice' }
})
await prisma.cms_board_data.findFirst({
  where: { board_key: 'notice' },
  orderBy: { create_date: 'desc' }
})
await prisma.cms_board_data.findUnique({
  where: { idx: 123 }
})

 

반응형