Hi folks, someone have a example that upsert quer...
# orm-helpc
Cleyde Andrade
07/26/2021, 1:16 PMHi folks, someone have a example that upsert query with multiple keys
r
Ryan
07/26/2021, 2:39 PM@Cleyde Andrade 👋
By multiple keys, do you mean adding them in
wherec
Cleyde Andrade
07/26/2021, 2:43 PMyes
Cleyde Andrade
07/26/2021, 2:44 PMin where clause
Cleyde Andrade
07/26/2021, 2:44 PM@@id([userId, courseId, levelId])
Cleyde Andrade
07/26/2021, 2:45 PMwhere: {
userId: req.body.userId,
courseId: req.body.courseId,
contentId: req.body.contentId,
},
Cleyde Andrade
07/26/2021, 2:45 PMError …
Cleyde Andrade
07/26/2021, 2:45 PMType ‘{ userId: any; courseId: any; contentId: any; }’ is not assignable to type ‘course_content_progressWhereUniqueInput’.
r
Ryan
07/26/2021, 2:46 PMIt should be something like this:
Copy code
userId_courseId_levelId {
userId: req.body.userId,
courseId: req.body.courseId,
levelId: req.body.levelId
}Ryan
07/26/2021, 2:46 PMUsing
ctrl+spacewherec
Cleyde Andrade
07/26/2021, 2:48 PMcool I try this
👍 1
4 Views