diff options
| author | syuilo <4439005+syuilo@users.noreply.github.com> | 2025-07-31 14:40:51 +0900 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-07-31 14:40:51 +0900 |
| commit | f2a23fb55ef2100bd26e3f2bcd7f939052c2ea09 (patch) | |
| tree | dff9f61bbb387e2e7d871cdf1d83d1580ebef10a /packages/backend/src/core/QueryService.ts | |
| parent | fix(test): Fix name of a test in e2e/timelines.ts (#16334) (diff) | |
| download | misskey-f2a23fb55ef2100bd26e3f2bcd7f939052c2ea09.tar.gz misskey-f2a23fb55ef2100bd26e3f2bcd7f939052c2ea09.tar.bz2 misskey-f2a23fb55ef2100bd26e3f2bcd7f939052c2ea09.zip | |
ノートの脱CASCADE削除 (#16332)
* wip
* Update CHANGELOG.md
* Update QueryService.ts
* Update QueryService.ts
* wip
* Update MkNoteDetailed.vue
* Update NoteEntityService.ts
* wip
* Update antennas.ts
* Update create.ts
* Update NoteEntityService.ts
* wip
* Update CHANGELOG.md
* Update NoteEntityService.ts
* Update NoteCreateService.ts
* Update note.test.ts
* Update note.test.ts
* Update ClientServerService.ts
* Update ClientServerService.ts
* add error handling
* Update NoteDeleteService.ts
* Update CHANGELOG.md
* Update entities.ts
* Update entities.ts
* Update misskey-js.api.md
Diffstat (limited to 'packages/backend/src/core/QueryService.ts')
| -rw-r--r-- | packages/backend/src/core/QueryService.ts | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/packages/backend/src/core/QueryService.ts b/packages/backend/src/core/QueryService.ts index d398e83230..49f93ad108 100644 --- a/packages/backend/src/core/QueryService.ts +++ b/packages/backend/src/core/QueryService.ts @@ -360,7 +360,7 @@ export class QueryService { public generateSuspendedUserQueryForNote(q: SelectQueryBuilder<any>, excludeAuthor?: boolean): void { if (excludeAuthor) { const brakets = (user: string) => new Brackets(qb => qb - .where(`note.${user}Id IS NULL`) + .where(`${user}.id IS NULL`) // そもそもreplyやrenoteではない、もしくはleftjoinなどでuserが存在しなかった場合を考慮 .orWhere(`user.id = ${user}.id`) .orWhere(`${user}.isSuspended = FALSE`)); q @@ -368,7 +368,7 @@ export class QueryService { .andWhere(brakets('renoteUser')); } else { const brakets = (user: string) => new Brackets(qb => qb - .where(`note.${user}Id IS NULL`) + .where(`${user}.id IS NULL`) // そもそもreplyやrenoteではない、もしくはleftjoinなどでuserが存在しなかった場合を考慮 .orWhere(`${user}.isSuspended = FALSE`)); q .andWhere('user.isSuspended = FALSE') |