Hi all what is the best way to run a `deleteMany` query wher Prisma #orm-help

Hi all, what is the best way to run a `deleteMany`...

Reuben Porter

11/02/2021, 11:49 AM

Hi all, what is the best way to run a

deleteMany

query where I have two where clauses, with one being an array of ids. For a basic example:

Copy code

model SurveyPermission {
  id           
  userId 
  surveyId 
}

const userIds = ['1', '2', '3'];
const surveyId = 'survey-id';

delete many from surveyPermissions where surveyId === surveyId && userId === one of userIds array

I thought I could use

has

but can't seem to get it working as I think that's just for enums. Obviously I could do this in a loop and use a single delete but ideally wanted to handle it in a single query .

Ryan

11/02/2021, 11:52 AM

Copy code

deleteMany({
  where: {
    surveyId: 'id',
    userId: { in: userIds }
  }
})

🙌 2

Reuben Porter

11/02/2021, 11:53 AM

I was being so stupid! Thanks Ryan. Do you know if the whole query will fail if say an incorrect id is passed in?

Reuben Porter

11/02/2021, 11:54 AM

e.g. 24 valid and 1incorrect

Reuben Porter

11/02/2021, 11:54 AM

or will a count of 24 just be returned and the invalid one silently just fail

Reuben Porter

11/02/2021, 11:55 AM

(just like a SQL in)

Ryan

11/02/2021, 11:56 AM

It will not fail, the values that match the user ids passed will be deleted

Reuben Porter

11/02/2021, 11:56 AM

yeah just confirmed that cheers mat

Reuben Porter

11/02/2021, 11:56 AM

mate

🙌 1

Reuben Porter

11/02/2021, 12:00 PM

Is there a way to return those that failed in the query? Longshot...

Reuben Porter

11/02/2021, 12:00 PM

not in I guess? ah nvm that wouldn't work

Ryan

11/02/2021, 12:10 PM

That wouldn't be possible unfortunately.

✅ 1

3 Views

Open in Slack

Previous Next