Anders
03/01/2021, 4:47 PMconst updatedPostCount = await prisma.formInput.updateMany({
where: {
id: [
"49523f75-9ec5-471f-999a-62b8097cabcc",
"51272b87-9592-4121-83f8-a1471abcc540",
],
},
data: { name: "test mass" },
});
I get the following error
Argument id: Got invalid value
[
'49523f75-9ec5-471f-999a-62b8097cabcc',
'51272b87-9592-4121-83f8-a1471abcc540'
]
on prisma.updateManyFormInput. Provided List<UUID>, expected StringFilter or String.
type StringFilter {
equals?: String
in?: List<String>
notIn?: List<String>
lt?: String
lte?: String
gt?: String
gte?: String
contains?: String
startsWith?: String
endsWith?: String
not?: String | NestedStringFilter
}
any help would be greatBen Ezard
03/01/2021, 5:02 PMconst updatedPostCount = await prisma.formInput.updateMany({
where: {
id: {
in: [
"49523f75-9ec5-471f-999a-62b8097cabcc",
"51272b87-9592-4121-83f8-a1471abcc540",
],
},
},
data: { name: "test mass" },
});
Anders
03/01/2021, 5:04 PMBen Ezard
03/01/2021, 5:05 PMAnders
03/01/2021, 5:06 PMBen Ezard
03/01/2021, 5:07 PMWHERE (id = 'ID 1' AND name = 'Name 1') OR (id = 'ID 2' AND name = 'Name 2')
?Anders
03/01/2021, 5:09 PMBen Ezard
03/01/2021, 5:12 PMwhere
clause for this:
where: {
OR: [
{
id: 'ID 1',
name: 'Name 1'
},
{
id: 'ID 2',
name: 'Name 2'
},
]
}
Anders
03/01/2021, 5:12 PMBen Ezard
03/01/2021, 5:12 PMAnders
03/01/2021, 5:17 PMBen Ezard
03/01/2021, 5:19 PMname
field to be Test Name
then you'd use
data: {
name: 'Test Name'
}
Anders
03/01/2021, 5:20 PMBen Ezard
03/01/2021, 5:24 PMcase
statements in MySQL, or update from
in Postgres, etcAnders
03/01/2021, 5:29 PM