From a9a245b46104429912168e9c6806fe7c61727a61 Mon Sep 17 00:00:00 2001 From: syuilo Date: Thu, 22 Dec 2022 08:32:01 +0900 Subject: enhance(server): delete outdated notes of antenna regularly to improve db performance --- packages/backend/src/queue/processors/CleanProcessorService.ts | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'packages/backend/src/queue/processors/CleanProcessorService.ts') diff --git a/packages/backend/src/queue/processors/CleanProcessorService.ts b/packages/backend/src/queue/processors/CleanProcessorService.ts index 9836065aa7..4aa1dc15fd 100644 --- a/packages/backend/src/queue/processors/CleanProcessorService.ts +++ b/packages/backend/src/queue/processors/CleanProcessorService.ts @@ -1,7 +1,7 @@ import { Inject, Injectable } from '@nestjs/common'; import { In, LessThan, MoreThan } from 'typeorm'; import { DI } from '@/di-symbols.js'; -import type { MutedNotesRepository, NotificationsRepository, UserIpsRepository } from '@/models/index.js'; +import type { AntennaNotesRepository, MutedNotesRepository, NotificationsRepository, UserIpsRepository } from '@/models/index.js'; import type { Config } from '@/config.js'; import type Logger from '@/logger.js'; import { bindThis } from '@/decorators.js'; @@ -26,6 +26,9 @@ export class CleanProcessorService { @Inject(DI.mutedNotesRepository) private mutedNotesRepository: MutedNotesRepository, + @Inject(DI.antennaNotesRepository) + private antennaNotesRepository: AntennaNotesRepository, + private queueLoggerService: QueueLoggerService, private idService: IdService, ) { @@ -49,6 +52,10 @@ export class CleanProcessorService { reason: 'word', }); + this.antennaNotesRepository.delete({ + id: LessThan(this.idService.genId(new Date(Date.now() - (1000 * 60 * 60 * 24 * 90)))), + }); + this.logger.succ('Cleaned.'); done(); } -- cgit v1.2.3-freya