[Feature Request] A real soft-delete feature

[ymc9]

Background

Current pattern: https://zenstack.dev/blog/soft-delete

But it has some limitations:

• You can't call the regular delete method
• onDelete referential actions don't work

Proposed Solution

The thought is to make it as simple as:

model Foo {
    ...
    deletedAt DateTime? @softDelete
}

And the enhance() API can have an option to opt-in for it:

const db = enhance(prisma, { user: ..., softDelete: true });

When enabled, the enhanced client has additional behavior:

1. delete and deleteMany (including nested ones) become soft delete
2. onDelete: Cascade propagate soft-delete to related entities
3. Read APIs (findXXX, count, aggregate, groupBy) automatically exclude soft-deleted entities

More Context

Context from chat with ikishan on discord:

[nahtnam]

const db = enhance(prisma, { user: ..., softDelete: true });

It would be specifically cool if we can have softDelete without enhance/an alternative function that doesn't use the authorization layer

I have a global export of prisma and I use that in my webhooks and cron jobs. I would love if they could also have soft deletes, but there is no "user" in those contexts so enchance wouldn't make sense. Would also be nice if they can respect the validations as well.

[ymc9]

const db = enhance(prisma, { user: ..., softDelete: true });

It would be specifically cool if we can have softDelete without enhance/an alternative function that doesn't use the authorization layer

I have a global export of prisma and I use that in my webhooks and cron jobs. I would love if they could also have soft deletes, but there is no "user" in those contexts so enchance wouldn't make sense. Would also be nice if they can respect the validations as well.

With the new unified enhance API in V2, it's probably going to look like:

const dbSoftDelete = enhance(prisma, undefined, { kinds: ['soft-delete'] });

Data validation is also part of access control today. It'll be a separate task to spin it out 😄

[ad6025b]

@ymc9 im thinking of using your zenstack for my next project, and i have been very impressed by what you created. However, I do need a soft-delete functionaly. The extension: https://github.com/olivierwilkinson/prisma-extension-soft-delete looks pretty good.

have you gotten close to releasing your soft-delete feature?

I would rather use yours, then yet another extension. Please advise. tx

[ymc9]

@ymc9 im thinking of using your zenstack for my next project, and i have been very impressed by what you created. However, I do need a soft-delete functionaly. The extension: https://github.com/olivierwilkinson/prisma-extension-soft-delete looks pretty good.

have you gotten close to releasing your soft-delete feature?

I would rather use yours, then yet another extension. Please advise. tx

Hi @ad6025b , there isn't a concrete plan to implement a native soft-delete yet.