feat: Recycle bin for deleted pages in space

[mobley-trent]

Closes #59

[CLAassistant]

All committers have signed the CLA.

[mobley-trent]

POC

https://github.com/user-attachments/assets/e5668ef1-5b44-408b-86a3-43b09bb84d27

[mobley-trent]

@Philipinho kindly review

[Philipinho]

I can’t seem to find how pages with children are handled. Ideally, when a page is soft-deleted, its children should be too. Same applies to restoration.

Let me know if I am missing something.

[mobley-trent]

I can’t seem to find how pages with children are handled. Ideally, when a page is soft-deleted, its children should be too. Same applies to restoration.

Let me know if I am missing something.

Deletion and restoration works with pages that have subpages as well.

[mobley-trent]

https://github.com/user-attachments/assets/89b847e5-a0c6-4400-b72d-0015aa9914c9

[Philipinho]

Aside from removing it from the tree, do sub-pages get soft-deleted too? i.e deleted_at field updated for each sub-page.

[mobley-trent]

Aside from removing it from the tree, do sub-pages get soft-deleted too? i.e deleted_at field updated for each sub-page.

I assumed the previous route for page deletion would also handle deletion of subpages, since the route seemed to carry out deletion for a single page. I simply updated the route to update the deletedAt field.

[Philipinho]

The default deletion process auto deletes child pages via foreign key relationship.

[mobley-trent]

@Philipinho I updated the remove (soft delete) and restore routes to fetch page ids for descendants as well.

[mobley-trent]

Hi @Philipinho I would appreciate your feedback

[Philipinho]

@mobley-trent thank you for your work. I will get to it.

[mobley-trent]

Any update on this @Philipinho ?

[mobley-trent]

PTAL @Philipinho

[mobley-trent]

@Philipinho I opted to auto-reload the page to handle the state

[Philipinho]

One of the issues I encountered the last time I tried it was, If a page with children gets deleted and the child of a deleted page gets restored, the child and it's children gets lost and does not appear in the sidebar.

[mobley-trent]

One of the issues I encountered the last time I tried it was, If a page with children gets deleted and the child of a deleted page gets restored, the child and it's children gets lost and does not appear in the sidebar.

I handled this by setting the parentPageId to null when restoring a page. This effectively ensures that the restored page and child pages are restored as root pages in the sidebar.