Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
import { useMemo } from "react";
import { useAppStore } from "@/stores/app";
import type { IssueComment } from "@/types/proto-es/v1/issue_service_pb";
import type { Plan_Spec } from "@/types/proto-es/v1/plan_service_pb";
import { getSheetStatement, isSheetContentComplete } from "@/utils/v1/sheet";
import { placementsForSheet } from "../../shared/stores/placementSlice";
import { usePlanDetailStore } from "../../shared/stores/usePlanDetailStore";
import {
completePreviewLineCount,
countPlacedUnresolvedBySpec,
countUnresolvedThreads,
groupThreads,
sheetNameOfSha256,
targetSha256OfSpec,
} from "./threadModel";
const NO_COMMENTS: IssueComment[] = [];
const previewEndLinesByContent = new WeakMap<Uint8Array, number>();
const useIssueThreads = (issueName: string | undefined) => {
const comments = useAppStore((state) =>
issueName ? state.getIssueComments(issueName) : NO_COMMENTS
);
return useMemo(() => groupThreads(comments), [comments]);
};
// Every unresolved thread on the issue; zero before an issue exists, and
// before its comments have loaded.
export function useUnresolvedThreadTotal(issueName: string | undefined) {
const threads = useIssueThreads(issueName);
return useMemo(() => countUnresolvedThreads(threads), [threads]);
}
// Whether the issue's comments have loaded at least once. A failed load leaves
// it false.
export function useIssueThreadsLoaded(issueName: string | undefined) {
return useAppStore(
(state) => !issueName || state.issueCommentsByIssue[issueName] !== undefined
);
}
// The last complete line the statement editor loads for each spec whose
// sheet is too large to load whole; specs loaded whole have no entry.
export function usePreviewEndLines(
specs: readonly Plan_Spec[],
projectName: string
): ReadonlyMap<string, number> {
const sheetsByName = useAppStore((s) => s.sheetsByName);
return useMemo(() => {
const lines = new Map<string, number>();
for (const spec of specs) {
const sha = targetSha256OfSpec(spec);
if (!sha) continue;
const sheet = sheetsByName[sheetNameOfSha256(projectName, sha)];
if (sheet && !isSheetContentComplete(sheet)) {
let endLine = previewEndLinesByContent.get(sheet.content);
if (endLine === undefined) {
endLine = completePreviewLineCount(getSheetStatement(sheet), true);
previewEndLinesByContent.set(sheet.content, endLine);
}
lines.set(spec.id, endLine);
}
}
return lines;
}, [projectName, sheetsByName, specs]);
}
// Unresolved threads the statement editor shows for each of `specs`, so a
// change tab and its editor walker agree.
export function usePlacedUnresolvedThreadCounts(
issueName: string | undefined,
specs: Plan_Spec[],
projectName: string
): ReadonlyMap<string, number> {
const threads = useIssueThreads(issueName);
const placements = usePlanDetailStore((s) => s.placements);
const placementTargets = usePlanDetailStore((s) => s.placementTargets);
const previewEndLines = usePreviewEndLines(specs, projectName);
return useMemo(
() =>
countPlacedUnresolvedBySpec(
threads,
specs,
(specId, sha) =>
placementsForSheet({ placements, placementTargets }, specId, sha),
(specId) => previewEndLines.get(specId)
),
[placementTargets, placements, previewEndLines, specs, threads]
);
}