Page trash: soft delete, restore, and purge job #31

New Issue

fable-5 · 2026-07-04T14:52:13+02:00

fable-5 commented

2026-07-04 14:52:13 +02:00

Context

Deleting must be recoverable (ADR 0013): pages go to a pond-level trash with retention.

Scope

Backend: DELETE /pages/:id sets deleted_at/by; trash endpoints (list, restore, purge single); introduce the jobs table + in-app scheduler (data-model.md) with the daily trash-purge job honoring retention (instance setting, default 30 days); purge deletes state, versions (placeholder — exist from M3), cache rows, and files. Frontend: trash view per pond (restore/purge buttons), delete confirmation, deleted pages excluded everywhere.

Acceptance criteria

deleted page disappears from sidebar and direct URL (404 with trash hint for those who may edit)
restore brings content and files back intact (e2e)
purge job removes rows and volume files past retention (time-travel test with injected clock)
scheduler survives API restart and never double-runs a job (locking test)

Technical notes

ADR 0013, data-model.md (jobs), operations.md (job table).
The scheduler built here is reused by all later maintenance jobs — keep it generic (name, cadence, handler, last-run bookkeeping).

Dependencies

Depends on #23, #27.

Size: ~2 days

Conventions: English code/comments, clear human-readable code, no hard-coded UI strings (ADR 0012, add de and en), permission checks only via the shared guard (docs/architecture/permissions.md). Read the referenced ADRs before starting.

## Context Deleting must be recoverable (ADR 0013): pages go to a pond-level trash with retention. ## Scope Backend: `DELETE /pages/:id` sets `deleted_at/by`; trash endpoints (list, restore, purge single); introduce the `jobs` table + in-app scheduler (data-model.md) with the daily `trash-purge` job honoring retention (instance setting, default 30 days); purge deletes state, versions (placeholder — exist from M3), cache rows, and files. Frontend: trash view per pond (restore/purge buttons), delete confirmation, deleted pages excluded everywhere. ## Acceptance criteria - [ ] deleted page disappears from sidebar and direct URL (404 with trash hint for those who may edit) - [ ] restore brings content and files back intact (e2e) - [ ] purge job removes rows and volume files past retention (time-travel test with injected clock) - [ ] scheduler survives API restart and never double-runs a job (locking test) ## Technical notes - ADR 0013, data-model.md (`jobs`), operations.md (job table). - The scheduler built here is reused by all later maintenance jobs — keep it generic (name, cadence, handler, last-run bookkeeping). ## Dependencies Depends on #23, #27. **Size**: ~2 days --- *Conventions: English code/comments, clear human-readable code, no hard-coded UI strings (ADR 0012, add `de` **and** `en`), permission checks only via the shared guard (docs/architecture/permissions.md). Read the referenced ADRs before starting.*

fable-5 added this to the M2 — Ponds & pages, single-user editing milestone 2026-07-04 14:52:13 +02:00

fable-5 added the

backend

frontend

labels 2026-07-04 14:52:13 +02:00

fable-5 referenced this issue

2026-07-04 14:52:13 +02:00

QA: M2 fixtures and content regression pack #32

fable-5 referenced this issue

2026-07-04 14:52:18 +02:00

Update-log compaction job #40

fable-5 referenced this issue

2026-07-04 14:52:32 +02:00

Conversion job queue and pandoc sidecar integration #62

fable-5 referenced this issue

2026-07-04 14:52:46 +02:00

Maintenance-jobs admin panel and audit-log viewer #86

sonnet-5 referenced this issue from a commit

2026-07-08 12:48:24 +02:00

Add page trash: soft delete, restore, and purge job (#31)

sonnet-5 closed this issue

2026-07-08 12:48:24 +02:00

sonnet-5 commented

2026-07-08 13:14:16 +02:00

Implemented in a645763 and closed via Closes #31. Pipeline verification for that commit:

CI / Lint, typecheck, test — success
CI / Auth e2e pack — success
CD / Build and push images — success
CD / Deploy to Test — success
CD / Smoke tests against Test — success
CD / Promote to Int — success

Acceptance criteria covered by apps/api/src/trash/trash.e2e.db.test.ts (list/restore/purge, trash-hint 404, time-travel purge via injected clock — in CI), apps/api/src/scheduler/scheduler.service.db.test.ts (locking + restart-survival — in CI), and apps/web/e2e/trash.spec.ts (UI delete/restore/purge — run locally against the dev stack).

Implemented in a645763 and closed via `Closes #31`. Pipeline verification for that commit: - CI / Lint, typecheck, test — success - CI / Auth e2e pack — success - CD / Build and push images — success - CD / Deploy to Test — success - CD / Smoke tests against Test — success - CD / Promote to Int — success Acceptance criteria covered by `apps/api/src/trash/trash.e2e.db.test.ts` (list/restore/purge, trash-hint 404, time-travel purge via injected clock — in CI), `apps/api/src/scheduler/scheduler.service.db.test.ts` (locking + restart-survival — in CI), and `apps/web/e2e/trash.spec.ts` (UI delete/restore/purge — run locally against the dev stack).

opus-4-8 referenced this issue from a commit

2026-07-08 17:06:51 +02:00

Add collab document persistence hooks and content-cache refresh (#35)

opus-4-8 referenced this issue

2026-07-08 17:36:00 +02:00

Document persistence hooks: load, store, and content-cache refresh #35

opus-4-8 referenced this issue from a commit

2026-07-09 08:16:06 +02:00

Add Yjs update-log compaction job (#40)

opus-4-8 referenced this issue

2026-07-09 08:34:23 +02:00

Update-log compaction job #40