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 dayjs from "dayjs";
import i18n from "@/lib/i18n";
import { getTimeForPbTimestampProtoEs } from "@/types";
import {
type AccessGrant,
AccessGrant_Status,
} from "@/types/proto-es/v1/access_grant_service_pb";
import { ApprovalStatus, IssueStatus } from "@/types/proto-es/v1/common_pb";
import type { Issue } from "@/types/proto-es/v1/issue_service_pb";
import { passedReading, type TimeReading } from "@/utils/datetime";
export type AccessGrantFilterStatus =
| "ACTIVE"
| "PENDING"
| "REVOKED"
| "EXPIRED";
export type AccessGrantDisplayStatus =
| AccessGrantFilterStatus
| "REJECTED"
| "CANCELED"
| "UNKNOWN";
/**
* The fixed deadline of a grant, if it has one. A pending grant holds a ttl
* instead: a duration that starts at approval, which names no instant yet.
*/
export const getAccessGrantExpireTimeMs = (
grant: AccessGrant
): number | undefined =>
grant.expiration.case === "expireTime"
? getTimeForPbTimestampProtoEs(grant.expiration.value)
: undefined;
export const getAccessGrantExpirationText = (
grant: AccessGrant
):
| { type: "datetime"; expireTimeMs: number }
| { type: "duration"; value: string }
| { type: "never" } => {
const expireTimeMs = getAccessGrantExpireTimeMs(grant);
if (expireTimeMs !== undefined) {
// Active grants only carry `expireTime` — the originally-requested
// TTL is `Input only` on the proto and is gone after activation.
// We deliberately do NOT derive a "duration" from
// `expireTime - createTime`: `createTime` is when the request was
// opened, not when the grant was activated, so the subtraction
// double-counts the approval-wait time. A 4h grant approved a day
// later would render as "1d4h", which misleads reviewers about
// the actual granted window. Show the absolute expire datetime
// alone instead. Bot review #3370767734.
return { type: "datetime", expireTimeMs };
}
if (grant.expiration.case === "ttl") {
// Pending grants still carry the requested TTL — safe to format.
const totalSeconds = Number(grant.expiration.value.seconds);
const dur = dayjs.duration(totalSeconds, "seconds");
const days = Math.floor(dur.asDays());
const hours = dur.hours();
const minutes = dur.minutes();
const parts: string[] = [];
if (days > 0) parts.push(`${days}d`);
if (hours > 0) parts.push(`${hours}h`);
if (minutes > 0) parts.push(`${minutes}m`);
return { type: "duration", value: parts.join("") || "<1m" };
}
return { type: "never" };
};
/** The deadline of an activated grant, the only kind that can expire. */
export const getActiveAccessGrantDeadlineMs = (
grant: AccessGrant
): number | undefined =>
grant.status === AccessGrant_Status.ACTIVE
? getAccessGrantExpireTimeMs(grant)
: undefined;
const getAccessGrantDisplayStatus = (
grant: AccessGrant,
issue?: Issue
): AccessGrantDisplayStatus => {
const deadlineMs = getActiveAccessGrantDeadlineMs(grant);
if (deadlineMs !== undefined && passedReading.read(deadlineMs)) {
return "EXPIRED";
}
switch (grant.status) {
case AccessGrant_Status.PENDING:
if (issue) {
if (issue.approvalStatus === ApprovalStatus.REJECTED) {
return "REJECTED";
}
if (issue.status === IssueStatus.CANCELED) {
return "CANCELED";
}
}
return "PENDING";
case AccessGrant_Status.ACTIVE:
return "ACTIVE";
case AccessGrant_Status.REVOKED:
return "REVOKED";
default:
return "UNKNOWN";
}
};
/**
* A grant's status as displayed. Only an activated grant's status changes with
* time, turning expired when its deadline passes.
*/
export const accessGrantStatusReading: TimeReading<
{ grant: AccessGrant; issue?: Issue },
AccessGrantDisplayStatus
> = {
read: ({ grant, issue }) => getAccessGrantDisplayStatus(grant, issue),
nextChangeAt: ({ grant }) => {
const deadlineMs = getActiveAccessGrantDeadlineMs(grant);
return deadlineMs === undefined
? Number.POSITIVE_INFINITY
: passedReading.nextChangeAt(deadlineMs);
},
};
export const getAccessGrantDisplayStatusText = (
displayStatus: AccessGrantDisplayStatus
) => {
switch (displayStatus) {
case "ACTIVE":
return i18n.t("common.active");
case "PENDING":
return i18n.t("common.pending");
case "EXPIRED":
return i18n.t("sql-editor.expired");
case "REVOKED":
return i18n.t("common.revoked");
case "REJECTED":
return i18n.t("common.rejected");
case "CANCELED":
return i18n.t("common.canceled");
default:
return displayStatus;
}
};
export const getAccessGrantStatusTagType = (
status: AccessGrantDisplayStatus
): "success" | "warning" | "error" | "default" => {
switch (status) {
case "ACTIVE":
return "success";
case "PENDING":
return "warning";
case "REVOKED":
case "REJECTED":
return "error";
case "CANCELED":
return "default";
default:
return "default";
}
};