diff options
| -rw-r--r-- | packages/backend/src/core/CustomEmojiService.ts | 4 | ||||
| -rw-r--r-- | packages/backend/test/unit/CustomEmojiService.ts | 2 |
2 files changed, 4 insertions, 2 deletions
diff --git a/packages/backend/src/core/CustomEmojiService.ts b/packages/backend/src/core/CustomEmojiService.ts index 165d58d1b2..2e4eddf797 100644 --- a/packages/backend/src/core/CustomEmojiService.ts +++ b/packages/backend/src/core/CustomEmojiService.ts @@ -520,11 +520,11 @@ export class CustomEmojiService implements OnApplicationShutdown { const q = params.query; if (q.updatedAtFrom) { // noIndexScan - builder.andWhere('CAST(emoji.updatedAt AS DATE) >= :updateAtFrom', { updateAtFrom: q.updatedAtFrom }); + builder.andWhere('CAST(emoji.updatedAt AS DATE) >= :updatedAtFrom', { updatedAtFrom: q.updatedAtFrom }); } if (q.updatedAtTo) { // noIndexScan - builder.andWhere('CAST(emoji.updatedAt AS DATE) <= :updateAtTo', { updateAtTo: q.updatedAtTo }); + builder.andWhere('CAST(emoji.updatedAt AS DATE) <= :updatedAtTo', { updatedAtTo: q.updatedAtTo }); } if (q.name) { builder.andWhere('emoji.name ~~ ANY(ARRAY[:...name])', { name: multipleWordsToQuery(q.name) }); diff --git a/packages/backend/test/unit/CustomEmojiService.ts b/packages/backend/test/unit/CustomEmojiService.ts index ffd96356e0..8c3dac69e8 100644 --- a/packages/backend/test/unit/CustomEmojiService.ts +++ b/packages/backend/test/unit/CustomEmojiService.ts @@ -17,6 +17,7 @@ import { EmojisRepository } from '@/models/_.js'; import { MiEmoji } from '@/models/Emoji.js'; import { CoreModule } from '@/core/CoreModule.js'; import { DriveService } from '@/core//DriveService.js'; +import { DataSource } from 'typeorm'; describe('CustomEmojiService', () => { let app: TestingModule; @@ -48,6 +49,7 @@ describe('CustomEmojiService', () => { service = app.get<CustomEmojiService>(CustomEmojiService); emojisRepository = app.get<EmojisRepository>(DI.emojisRepository); idService = app.get<IdService>(IdService); + await app.get<DataSource>(DI.db).query("set session time zone 'UTC'"); }); describe('fetchEmojis', () => { |