summaryrefslogtreecommitdiff
path: root/packages/backend/src/core/QueryService.ts (follow)
Commit message (Collapse)AuthorAgeFilesLines
* merge: Avoid more N+1 queries in NoteEntityService and UserEntityService (!1099)Hazelnoot2025-06-121-1/+1
|\ | | | | | | | | | | View MR for information: https://activitypub.software/TransFem-org/Sharkey/-/merge_requests/1099 Approved-by: dakkar <dakkar@thenautilus.net> Approved-by: Marie <github@yuugi.dev>
| * fix typo in QueryService.generateBlockQueryForUsersHazelnoot2025-06-091-1/+1
| |
* | enforce DM visibility in generateVisibilityQueryHazelnoot2025-06-101-7/+9
|/
* additional fixes and cleanup to all note endpointsHazelnoot2025-06-051-9/+116
|
* use index when checking visibleUserIds and mentions in generateVisibilityQueryHazelnoot2025-06-051-3/+30
|
* more QueryService fixesHazelnoot2025-06-031-109/+173
|
* replace generateBlockedHostQueryForNote allowSilenced parameter with ↵Hazelnoot2025-06-021-14/+3
| | | | generateSilencedUserQueryForNotes
* fix andWhere/orWhere in QueryService.tsHazelnoot2025-06-021-21/+40
|
* refactor QueryService to use EXISTS instead of IN for most queriesHazelnoot2025-06-021-152/+218
|
* merge: Fix logic error in generateBlockedHostQueryForNote (!1085)Hazelnoot2025-06-011-4/+7
|\ | | | | | | | | | | View MR for information: https://activitypub.software/TransFem-org/Sharkey/-/merge_requests/1085 Approved-by: dakkar <dakkar@thenautilus.net> Approved-by: Marie <github@yuugi.dev>
| * remove duplicate isBlocked check from generateBlockedHostQueryForNoteHazelnoot2025-06-011-2/+1
| |
| * fix logic error in generateBlockedHostQueryForNote that would allow blocked ↵Hazelnoot2025-06-011-2/+6
| | | | | | | | instances if allowSilenced was set to false
* | fix withRenotes check in generateMutedUserRenotesQueryForNotesHazelnoot2025-06-011-0/+1
|/
* use instance block columns instead of checking meta columnsHazelnoot2025-05-281-25/+19
|
* fix QueryService.generateMutedUserRenotesQueryForNotes to properly exclude ↵Hazelnoot2025-05-281-6/+5
| | | | quotes
* nicer SQL checks for blocked hostsdakkar2025-05-021-2/+1
| | | | | | | | instead of passing a (possibly gigantic) array from JS, we get PostgreSQL to look at the value in the `meta` table directly tested the `federation/instances` endpoint, and the `QueryService` methods; I have not tested the charts
* Merge branch 'misskey-develop' into merge/2025-03-24Hazelnoot2025-04-291-1/+37
|\ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | # Conflicts: # .github/workflows/api-misskey-js.yml # .github/workflows/changelog-check.yml # .github/workflows/check-misskey-js-autogen.yml # .github/workflows/get-api-diff.yml # .github/workflows/lint.yml # .github/workflows/locale.yml # .github/workflows/on-release-created.yml # .github/workflows/storybook.yml # .github/workflows/test-backend.yml # .github/workflows/test-federation.yml # .github/workflows/test-frontend.yml # .github/workflows/test-misskey-js.yml # .github/workflows/test-production.yml # .github/workflows/validate-api-json.yml # package.json # packages/backend/package.json # packages/backend/src/server/api/ApiCallService.ts # packages/backend/src/server/api/endpoints/drive/files/create.ts # packages/frontend-shared/js/url.ts # packages/frontend/package.json # packages/frontend/src/components/MkFileCaptionEditWindow.vue # packages/frontend/src/components/MkInfo.vue # packages/frontend/src/components/MkLink.vue # packages/frontend/src/components/MkNote.vue # packages/frontend/src/components/MkNotes.vue # packages/frontend/src/components/MkPageWindow.vue # packages/frontend/src/components/MkReactionsViewer.vue # packages/frontend/src/components/MkTimeline.vue # packages/frontend/src/components/MkUrlPreview.vue # packages/frontend/src/components/MkUserPopup.vue # packages/frontend/src/components/global/MkPageHeader.vue # packages/frontend/src/components/global/MkUrl.vue # packages/frontend/src/components/global/PageWithHeader.vue # packages/frontend/src/pages/about-misskey.vue # packages/frontend/src/pages/announcements.vue # packages/frontend/src/pages/antenna-timeline.vue # packages/frontend/src/pages/channel.vue # packages/frontend/src/pages/instance-info.vue # packages/frontend/src/pages/note.vue # packages/frontend/src/pages/page.vue # packages/frontend/src/pages/role.vue # packages/frontend/src/pages/tag.vue # packages/frontend/src/pages/timeline.vue # packages/frontend/src/pages/user-list-timeline.vue # packages/frontend/src/pages/user/followers.vue # packages/frontend/src/pages/user/following.vue # packages/frontend/src/pages/user/home.vue # packages/frontend/src/pages/user/index.vue # packages/frontend/src/ui/deck.vue # packages/misskey-js/generator/package.json # pnpm-lock.yaml # scripts/changelog-checker/package-lock.json # scripts/changelog-checker/package.json
| * Exclude blocked instance note from most timelines (#15792)anatawa122025-04-281-1/+37
| | | | | | | | | | | | | | | | | | * Exclude blocked instance note from most timelines * Exclude blocked instance note from FTT timelines * Exclude blocked instance note from featured * fix type
* | Merge branch 'develop' into merge/2025-03-24Hazelnoot2025-03-311-2/+2
|\ \ | |/ |/| | | | | | | # Conflicts: # packages/backend/src/server/api/StreamingApiServerService.ts # packages/backend/src/server/api/stream/Connection.ts
| * do not make a DM visible if user is mentioned but not a recipientJacob Hall2025-02-211-2/+2
| |
* | refactor(backend): better method namesyuilo2025-03-271-2/+2
|/
* (re) update SPDX-FileCopyrightTexttamaina2024-02-131-1/+1
| | | | Fix #13290
* Revert "update SPDX-FileCopyrightText"tamaina2024-02-131-1/+1
| | | | This reverts commit 9b5aeb76d8c9372d67058c512597152b6bf222f2.
* update SPDX-FileCopyrightTextsyuilo2024-02-121-1/+1
|
* refactor: ↵YS2024-01-151-3/+3
| | | | | | | | | | | | | noteテーブルのインデックス整理と配列カラムへのクエリでインデックスを使うように (#12993) * Optimize note model index * enhance(backend): ANY()をやめる (MisskeyIO#239) * add small e2e test drive endpoint --------- Co-authored-by: まっちゃとーにゅ <17376330+u1-liquid@users.noreply.github.com>
* enhance(backend): RedisへのTLのキャッシュをオフにできるようにsyuilo2023-10-231-1/+1
|
* perf(backend): createdAtをidから取得するように & ↵syuilo2023-10-161-4/+4
| | | | 無駄なDateインスタンスの生成を避けるように
* perf(backend): ↵syuilo2023-10-091-7/+10
| | | | untilDate/sinceDate指定時のクエリパフォーマンスを向上
* fixsyuilo2023-10-091-1/+1
|
* lint fixessyuilo2023-10-091-44/+57
|
* feat: improve tl performance (#11946)syuilo2023-10-031-63/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * wip * wip * wip * wip * wip * wip * Update NoteCreateService.ts * wip * wip * wip * wip * Update NoteCreateService.ts * wip * Update NoteCreateService.ts * wip * Update user-notes.ts * wip * wip * wip * Update NoteCreateService.ts * wip * Update timeline.ts * Update timeline.ts * Update timeline.ts * Update timeline.ts * Update timeline.ts * wip * Update timelines.ts * Update timelines.ts * Update timelines.ts * wip * wip * wip * Update timelines.ts * Update misskey-js.api.md * Update timelines.ts * Update timelines.ts * wip * wip * wip * Update timelines.ts * wip * Update timelines.ts * wip * test * Update activitypub.ts * refactor: UserListJoining -> UserListMembership * Update NoteCreateService.ts * wip
* refactor(backend): update directory structure for modelssyuilo2023-09-201-1/+1
|
* update deps (#11820)syuilo2023-09-151-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | * update deps * fix * wip * wip * wip * Update docker-compose.yml.example * Delete reviewer-lottery.yml * Update RepositoryModule.ts * wip * wip * clean up * update deps * wip * wip
* refactor: prefix Mi for all entities (#11719)syuilo2023-08-161-11/+11
| | | | | | | | | | | | | | | | | | | | | * wip * wip * wip * wip * Update RepositoryModule.ts * wip * wip * wip * Revert "wip" This reverts commit c1c13b37d2aaf3c65bc148212da302b0eb7868bf.
* chore: ↵Shun Sakai2023-07-271-0/+5
| | | | | | | | | | | | | | 著作権とライセンスについての情報を各ファイルに追加する (#11348) * chore: Add the SPDX information to each file Add copyright and licensing information as defined in version 3.0 of the REUSE Specification. * tweak format --------- Co-authored-by: syuilo <Syuilotan@yahoo.co.jp>
* cleanup: trim trailing whitespace (#11136)okayurisotto2023-07-081-20/+20
| | | | | | | | | * cleanup: trim trailing whitespace * update(`.editorconfig`) --------- Co-authored-by: syuilo <Syuilotan@yahoo.co.jp>
* enhance: ↵syuilo2023-05-161-2/+2
| | | | | | タイムラインにフォロイーの行った他人へのリプライを含めるかどうかの設定をアカウントに保存するのをやめるように Resolve #10646
* feat: Per-user renote mute (#10249)syuilo2023-03-081-2/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * feat: per-user renote muting From FoundKey/c414f24a2c https://akkoma.dev/FoundKeyGang/FoundKey * Update ja-JP.yml * Delete renote-muting.ts * rename * fix ids * lint * fix * Update CHANGELOG.md * リノートをミュートしたユーザー一覧を見れるように * :art: * add test * fix test --------- Co-authored-by: Hélène <pleroma-dev@helene.moe>
* refactor: fix typessyuilo2023-02-091-3/+3
|
* refactor: introduce bindThis decorator to bind this automaticalysyuilo2022-12-041-0/+10
|
* fixessyuilo2022-09-231-0/+1
|
* なんかもうめっちゃ変えたsyuilo2022-09-181-0/+262
generated by cgit v1.2.3-freya (git 2.53.0.84.g453e7b744a) at 2026-03-03 15:26:54 +0000