Rob Hoskins
09/19/2022, 9:09 PMmodel User {
id String @id @default(cuid())
name String?
email String? @unique
emailVerified DateTime?
image String?
accounts Account[]
sessions Session[]
Playlist Playlist[]
Like Like[]
}
model Playlist {
id String @id @default(cuid())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
likeCount Int?
type PlaylistType
url String
name String?
description String?
author String?
tags Tag[]
submittedBy User? @relation(fields: [userId], references: [id])
likes Like[]
userId String?
}
model Like {
id String @id @default(cuid())
createdAt DateTime @default(now())
user User @relation(fields: [userId], references: [id])
userId String
playlist Playlist @relation(fields: [playlistId], references: [id])
playlistId String
@@unique([userId, playlistId])
}
const newLike = { userId: 'cl883tgpm0079x4u5ivj6bzv9', playlistId: 'cl86l256l00935cu59fv08pc3' }
const result = await prisma.playlist.update({
where: {
id: 'cl86l256l00935cu59fv08pc3'
},
data: {
likeCount: { increment: 1 },
likes: {
upsert: {
create: newLike,
update: newLike
}
},
},
include: {
likes: true,
tags: true
}
})
console.log(result)
Nurul
09/20/2022, 11:43 AMconst result = await prisma.playlist.update({
where: {
id: 'cl86l256l00935cu59fv08pc3',
},
data: {
likeCount: { increment: 1 },
likes: {
create: {
userId: 'cl883tgpm0079x4u5ivj6bzv9',
},
},
},
include: {
likes: true,
},
});
console.log(result);
Joey
09/20/2022, 1:08 PMRob Hoskins
09/20/2022, 1:49 PMRob Hoskins
09/20/2022, 1:53 PM