Function createFindManyFilters

src/controllers/UserBookmark.controller.ts:50–81

(query: z.output<typeof findManyBookmarksSchema>, userId: UserId)

}

async function createFindManyFilters(query: z.output<typeof findManyBookmarksSchema>, userId: UserId) {
  const { keyword, tagIds = [], tagNames, hostCheckStatus, ids } = query
  const filters = [userLimiter(userId)]
  if (ids?.length) {
    filters.push(inArray(userBookmarks.id, ids))
  }
  if (keyword) {
    filters.push(createBookmarkFilterByKeyword(userBookmarks, keyword))
  }
  if (tagNames?.length) {
    const tags = await UserTagController.getAll(userId)
    for (const name of tagNames) {
      const tag = tags.find((el) => el.name === name)
      tag && tagIds.push(tag.id)
    }
  }
  const newTagIds = await UserTagController.filterUserTagIds(userId, tagIds)
  if (newTagIds.length) {
    const findTargetBIds = db
      .select({ bId: userBookmarkToTag.bId })
      .from(userBookmarkToTag)
      .where(inArray(userBookmarkToTag.tId, newTagIds))
      .groupBy(userBookmarkToTag.bId)
      .having(sql`COUNT(DISTINCT ${userBookmarkToTag.tId}) = ${newTagIds.length}`)
    filters.push(inArray(userBookmarks.id, findTargetBIds))
  }
  const hostCheckFilter = hostCheckStatus ? createBookmarkHostCheckFilter(userBookmarks, hostCheckStatus) : undefined
  if (hostCheckFilter) {
    filters.push(hostCheckFilter)
  }
  return and(...filters)
}

const UserBookmarkController = {
  async insert(bookmark: InsertBookmark) {