Prisma deleteMany with a list of IDs

Question

I'm wondering if there is a way in the Prisma Client to batch delete database records by id.

Something like this doesn't seem to exist:

const idsToDelete = [5, 29, 255]

prisma.post.deleteMany({
    where: {
        id: {
            equals: idsToDelete
        }
    }
})

The docs allude to the concept of Scalar List Filters, but this doesn't seem to be supported for numeric lists or perhaps isn't supported in deleteMany.

Under the hood, I'm hoping for a SQL DELETE ... WHERE IN clause. I'd prefer not to:

Spin up a bunch of individual JS promises
Use database-specific Prisma features (ok if it's not supported in MongoDB)
Write SQL directly

timewastingprofessional · Accepted Answer · 2022-07-04T17:41:19.173

21

You can use the in operator:

    where: {
        id: {
            in: idsToDelete
        }
    }

edited Jul 04 '22 at 17:41

answered Nov 30 '21 at 22:24

timewastingprofessional

608
5
11

Thanks, that's exactly what I need. Do you have a link to where it is documented? – Nate Vaughan Nov 30 '21 at 22:56
1

No problem. The client API reference is here: https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#in – timewastingprofessional Nov 30 '21 at 22:58

Prisma deleteMany with a list of IDs

1 Answers1