import type { ExpressionBuilder } from "kysely";
import type { Database } from "./index.ts";

export function issuesLabelFilter(
    eb: ExpressionBuilder<Database, "issues">,
    labelIds: number[],
) {
    return eb.exists(
        eb
            .selectFrom("issue_labels")
            .select("issue_labels.issue_id")
            .whereRef("issue_labels.issue_id", "=", "issues.id")
            .where("issue_labels.label_id", "in", labelIds),
    );
}

export function patchesLabelFilter(
    eb: ExpressionBuilder<Database, "patches">,
    labelIds: number[],
) {
    return eb.exists(
        eb
            .selectFrom("patch_labels")
            .select("patch_labels.patch_id")
            .whereRef("patch_labels.patch_id", "=", "patches.id")
            .where("patch_labels.label_id", "in", labelIds),
    );
}