feat: Allow soft-deletion of orphaned relation rows using orphanedRow…

[oxeye-yuvalk]

Allow soft-deletion of orphaned relation rows using orphanedRowAction
related to - #8408

Description of change

The Problem
orphanedRowAction supports nullifying the relation rows or deleting them but not soft-deleting them.

The Solution
Add a soft-delete option for orphanedRowAction.

Pull-Request Checklist

• Code is up-to-date with the master branch
• npm run lint passes with this change
• npm run test passes with this change
• This pull request links relevant issues as Fixes #0000
• There are new or updated unit tests validating the change
• Documentation has been updated to reflect this change
• The new commits follow conventions explained in CONTRIBUTING.md

[pleerock]

@jbjhjm what do you think about this feature request?

[jbjhjm]

@pleerock Makes sense to me. Adds another facet to making the orphanedRowAction feature complete.
Implementation is really easy so not much worrying it might break anything.

Tests look fine, but I'm missing a check validating that there actually is a soft-deleted Post in database.
As far as I can see current tests would pass if the row was hard-deleted from database too.
So I think the "should delete the orphaned Post from the database" test should become "should mark orphaned Post as soft-deleted" @oxeye-yuvalk -- do you agree?

[oxeye-yuvalk]

@pleerock @jbjhjm I just changed the test file and all check have passed!