Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

2.9 KB
Raw Blame
import i18n from "@/lib/i18n";
import type {
  RuleConfigComponent,
  RuleMapValidationError,
  RuleTemplateV2,
  SQLReviewPolicy,
} from "@/types";
import {
  convertPolicyRuleToRuleTemplate,
  getRuleLocalization,
  ruleTemplateMapV2,
  ruleTypeToString,
} from "@/types";
import { SQLReviewRule_Type } from "@/types/proto-es/v1/review_config_service_pb";
import type { PayloadValueType } from "./rule-config-types";

export const getRuleKey = (rule: RuleTemplateV2) =>
  `${rule.engine}:${rule.type}`;

export const getTemplateId = (review: SQLReviewPolicy) =>
  `bb.sql-review.${review.id}`;

export const rulesToTemplate = (review: SQLReviewPolicy) => {
  const ruleTemplateList: RuleTemplateV2[] = [];

  for (const rule of review.ruleList) {
    // rule.type is already SQLReviewRule_Type enum
    const type = rule.type ?? SQLReviewRule_Type.TYPE_UNSPECIFIED;

    const ruleTemplate = ruleTemplateMapV2.get(rule.engine)?.get(type);
    if (!ruleTemplate) {
      continue;
    }

    const data = convertPolicyRuleToRuleTemplate(rule, ruleTemplate);
    if (data) {
      ruleTemplateList.push(data);
    }
  }

  return {
    id: getTemplateId(review),
    review,
    ruleList: ruleTemplateList,
  };
};

export const payloadValueListToComponentList = (
  rule: RuleTemplateV2,
  data: PayloadValueType[]
) => {
  return rule.componentList.reduce<RuleConfigComponent[]>(
    (list, component, index) => {
      switch (component.payload.type) {
        case "STRING_ARRAY":
          list.push({
            ...component,
            payload: {
              ...component.payload,
              value: data[index] as string[],
            },
          });
          break;
        case "NUMBER":
          list.push({
            ...component,
            payload: {
              ...component.payload,
              value: data[index] as number,
            },
          });
          break;
        case "BOOLEAN":
          list.push({
            ...component,
            payload: {
              ...component.payload,
              value: data[index] as boolean,
            },
          });
          break;
        default:
          list.push({
            ...component,
            payload: {
              ...component.payload,
              value: data[index] as string,
            },
          });
          break;
      }
      return list;
    },
    []
  );
};

export const getRuleMapValidationErrorTitle = (
  error: RuleMapValidationError
): string => {
  if (error.type === "EMPTY_RULE_LIST") {
    return i18n.t("sql-review.validation.rule-required");
  }

  const ruleTitle = getRuleLocalization(
    ruleTypeToString(error.rule.type),
    error.rule.engine
  ).title;
  if (error.type === "INVALID_NUMBER") {
    return i18n.t("sql-review.validation.number-positive", {
      rule: ruleTitle,
    });
  }
  return i18n.t("sql-review.validation.string-array-required", {
    rule: ruleTitle,
  });
};