Skip to content

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

6.7 KB
Raw Blame
import { CheckCircle } from "lucide-react";
import { useEffect, useMemo } from "react";
import { useTranslation } from "react-i18next";
import { EnvironmentLabel } from "@/components/EnvironmentLabel";
import { Badge } from "@/components/ui/badge";
import { Button } from "@/components/ui/button";
import { FormField } from "@/components/ui/form";
import { Separator } from "@/components/ui/separator";
import { useProjectByName } from "@/hooks/useProjectByName";
import { rulesToTemplate } from "@/lib/sql-review/utils";
import { cn } from "@/lib/utils";
import { useAppStore } from "@/stores/app";
import {
  environmentNamePrefix,
  projectNamePrefix,
} from "@/stores/modules/v1/common";
import { useSQLReviewStore } from "@/stores/sqlReview";
import type { SQLReviewPolicyTemplateV2 } from "@/types";
import { TEMPLATE_LIST_V2 as builtInTemplateList } from "@/types";

interface PolicyTemplate extends SQLReviewPolicyTemplateV2 {
  review?: {
    name: string;
    resources: string[];
  };
}

interface TemplateSelectorProps {
  required?: boolean;
  selectedTemplateId?: string;
  onSelectTemplate: (template: SQLReviewPolicyTemplateV2) => void;
}

function ResourceBadge({ resource }: { resource: string }) {
  const { t } = useTranslation();
  // subscribe to re-render on project cache change
  const projectsByName = useAppStore((s) => s.projectsByName);

  useEffect(() => {
    if (resource.startsWith(projectNamePrefix)) {
      useAppStore.getState().getOrFetchProjectByName(resource, true);
    }
  }, [resource]);

  const projectFromResource = useProjectByName(resource);
  const projectTitle = resource.startsWith(projectNamePrefix)
    ? projectFromResource?.title
    : undefined;
  void projectsByName;

  if (resource.startsWith(environmentNamePrefix)) {
    return (
      <Badge variant="default" className="gap-x-1">
        <span className="text-control-light text-xs">
          {t("common.environment")}:
        </span>
        <EnvironmentLabel environmentName={resource} />
      </Badge>
    );
  }

  if (resource.startsWith(projectNamePrefix)) {
    return (
      <Badge variant="default" className="gap-x-1">
        <span className="text-control-light text-xs">
          {t("common.project")}:
        </span>
        <span>{projectTitle || resource}</span>
      </Badge>
    );
  }

  return <Badge variant="default">{resource}</Badge>;
}

export function TemplateSelector({
  required,
  selectedTemplateId,
  onSelectTemplate,
}: TemplateSelectorProps) {
  const { t } = useTranslation();
  const sqlReviewStore = useSQLReviewStore();
  const policyList = sqlReviewStore.reviewPolicyList;

  useEffect(() => {
    sqlReviewStore.fetchReviewPolicyList();
  }, []);

  const reviewPolicyTemplateList = useMemo<PolicyTemplate[]>(() => {
    return policyList.map((r) => rulesToTemplate(r));
  }, [policyList]);

  const isSelected = (template: SQLReviewPolicyTemplateV2) =>
    template.id === selectedTemplateId;

  return (
    <FormField
      title={
        <>
          {t("sql-review.create.basic-info.choose-template")}
          {required && <span className="text-error ml-0.5">*</span>}
        </>
      }
    >
      <div className="flex flex-col gap-y-2">
        {reviewPolicyTemplateList.length > 0 && (
          <>
            <div className="flex flex-wrap gap-4">
              {reviewPolicyTemplateList.map((template) => (
                <Button
                  type="button"
                  key={template.id}
                  appearance="secondary"
                  size="xs"
                  aria-pressed={isSelected(template)}
                  className={cn(
                    "relative h-auto w-full flex-col items-start rounded-sm border border-control-border px-6 py-4 text-left whitespace-normal sm:max-w-xs",
                    "hover:bg-control-bg focus-visible:outline-hidden focus-visible:ring-2 focus-visible:ring-accent focus-visible:ring-offset-2",
                    isSelected(template) && "bg-control-bg"
                  )}
                  onClick={() => onSelectTemplate(template)}
                >
                  <div className="flex w-full min-w-0 flex-col gap-y-2 text-left">
                    <span className="break-words text-base font-medium">
                      {template.review?.name}
                    </span>
                    <div className="flex flex-wrap gap-2">
                      {template.review?.resources.map((resource) => (
                        <ResourceBadge key={resource} resource={resource} />
                      ))}
                    </div>
                    <p className="break-words text-sm">
                      <span className="mr-2">
                        {t("sql-review.enabled-rules")}:
                      </span>
                      <span>{template.ruleList.length}</span>
                    </p>
                  </div>
                  {isSelected(template) && (
                    <CheckCircle className="absolute right-3 top-3 size-7 text-accent" />
                  )}
                </Button>
              ))}
            </div>

            <Separator className="my-2" />
          </>
        )}

        <div className="flex flex-wrap gap-4">
          {builtInTemplateList.map((template) => (
            <Button
              type="button"
              key={template.id}
              appearance="secondary"
              size="xs"
              aria-pressed={isSelected(template)}
              className={cn(
                "relative h-auto w-full flex-col items-start rounded-sm border border-control-border px-6 py-4 text-left whitespace-normal sm:max-w-xs",
                "hover:bg-control-bg focus-visible:outline-hidden focus-visible:ring-2 focus-visible:ring-accent focus-visible:ring-offset-2",
                isSelected(template) && "bg-control-bg"
              )}
              onClick={() => onSelectTemplate(template)}
            >
              <div className="flex w-full min-w-0 flex-col gap-y-2 text-left">
                <span className="break-words text-base font-medium">
                  {t(`sql-review.template.${template.id.split(".").join("-")}`)}
                </span>
                <p className="break-words text-sm text-control-light">
                  {t(
                    `sql-review.template.${template.id.split(".").join("-")}-desc`
                  )}
                </p>
                <p className="break-words text-sm">
                  <span className="mr-2">{t("sql-review.enabled-rules")}:</span>
                  <span>{template.ruleList.length}</span>
                </p>
              </div>
              {isSelected(template) && (
                <CheckCircle className="absolute right-3 top-3 size-7 text-accent" />
              )}
            </Button>
          ))}
        </div>
      </div>
    </FormField>
  );
}