From 60f7278aff27b9a0e03c1f1a2a77663cfb0e0ddb Mon Sep 17 00:00:00 2001 From: anatawa12 Date: Fri, 15 Aug 2025 22:39:55 +0900 Subject: fix: Remote Note Cleaning will delete notes embedded in a page (#16408) * feat: preserve number of pages referencing the note * chore: delete pages on account delete * fix: notes on the pages are removed by CleanRemoteNotes * test: add the simplest test for page embedded notes * fix: section block is not considered * fix: section block is not considered in migration * chore: remove comments from columns * revert unnecessary change * add pageCount to webhook test * fix type error on backend --- packages/backend/src/models/Note.ts | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'packages/backend/src/models') diff --git a/packages/backend/src/models/Note.ts b/packages/backend/src/models/Note.ts index ff46615729..26d5c1d535 100644 --- a/packages/backend/src/models/Note.ts +++ b/packages/backend/src/models/Note.ts @@ -114,6 +114,13 @@ export class MiNote { }) public clippedCount: number; + // The number of note page blocks referencing this note. + // This column is used by Remote Note Cleaning and manually updated rather than automatically with triggers. + @Column('smallint', { + default: 0, + }) + public pageCount: number; + @Column('jsonb', { default: {}, }) -- cgit v1.2.3-freya