Function createBookmarkHostCheckFilter

src/controllers/BookmarkHostCheck.controller.ts:69–86

(
  table: { hostKey: any },
  status: BookmarkHostCheckFilterStatus
)

}

export function createBookmarkHostCheckFilter(
  table: { hostKey: any },
  status: BookmarkHostCheckFilterStatus
) {
  if (!status) return undefined

  const checkedHostKeys = db.select({ hostKey: bookmarkHostChecks.hostKey }).from(bookmarkHostChecks)

  if (status === 'unchecked') {
    return or(isNull(table.hostKey), notInArray(table.hostKey, checkedHostKeys))
  }

  const targetHostKeys = db
    .select({ hostKey: bookmarkHostChecks.hostKey })
    .from(bookmarkHostChecks)
    .where(eq(bookmarkHostChecks.status, status))
  return and(inArray(table.hostKey, targetHostKeys))
}

export async function withBookmarkHostCheckSummaries<T extends BookmarkWithHostKey>(
  list: T[]