diff options
| author | anatawa12 <anatawa12@icloud.com> | 2025-08-15 22:39:55 +0900 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-08-15 22:39:55 +0900 |
| commit | 60f7278aff27b9a0e03c1f1a2a77663cfb0e0ddb (patch) | |
| tree | 76d9f4e99144879566c5d39da7de7bd7f11a7668 /packages/backend/src/queue/processors/CleanRemoteNotesProcessorService.ts | |
| parent | enhance(frontend): improve enableInfiniteScroll stability (diff) | |
| download | misskey-60f7278aff27b9a0e03c1f1a2a77663cfb0e0ddb.tar.gz misskey-60f7278aff27b9a0e03c1f1a2a77663cfb0e0ddb.tar.bz2 misskey-60f7278aff27b9a0e03c1f1a2a77663cfb0e0ddb.zip | |
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
Diffstat (limited to 'packages/backend/src/queue/processors/CleanRemoteNotesProcessorService.ts')
| -rw-r--r-- | packages/backend/src/queue/processors/CleanRemoteNotesProcessorService.ts | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/packages/backend/src/queue/processors/CleanRemoteNotesProcessorService.ts b/packages/backend/src/queue/processors/CleanRemoteNotesProcessorService.ts index 77a9dc5557..f53d403280 100644 --- a/packages/backend/src/queue/processors/CleanRemoteNotesProcessorService.ts +++ b/packages/backend/src/queue/processors/CleanRemoteNotesProcessorService.ts @@ -82,6 +82,7 @@ export class CleanRemoteNotesProcessorService { const removalCriteria = [ 'note."id" < :newestLimit', 'note."clippedCount" = 0', + 'note."pageCount" = 0', 'note."userHost" IS NOT NULL', 'NOT EXISTS (SELECT 1 FROM user_note_pining WHERE "noteId" = note."id")', 'NOT EXISTS (SELECT 1 FROM note_favorite WHERE "noteId" = note."id")', |