You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
How should I query over relation by multiple conditions?
for example I want to filter table rows with the below properties (all of them are unique and primary key):
column1: value1 (PK)
coulmn2: value2 (PK)
column3: value3 (PK)
My written code:
record = db.table.upsert(
where={'column1': 1,
'column2': 2,
'column3': 3}
data={
'create': {
....
},
'update': {
....
},
},
)
And the error that I encounterd :
prisma.errors.FieldNotFoundError: Failed to validate the query: `Expected exactly one field to be present, got 3.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
How should I query over relation by multiple conditions?
for example I want to filter table rows with the below properties (all of them are unique and primary key):
column1: value1 (PK)
coulmn2: value2 (PK)
column3: value3 (PK)
My written code:
record = db.table.upsert(
where={'column1': 1,
'column2': 2,
'column3': 3}
data={
'create': {
....
},
'update': {
....
},
},
)
And the error that I encounterd :
prisma.errors.FieldNotFoundError: Failed to validate the query: `Expected exactly one field to be present, got 3.
Beta Was this translation helpful? Give feedback.
All reactions