Skip to content

armgit / dbx

Public Imported from GitHub
0

25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具,支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库,提供桌面端、Docker、CLI、内置 AI 助手和 MCP。

2.6 KB
Raw Blame
import { watch } from "vue";
import { uuid } from "@/lib/common/utils";
import i18n from "@/i18n";
import { useConnectionStore } from "@/stores/connectionStore";
import { useSqlExecutionDangerStore } from "@/stores/sqlExecutionDangerStore";
import { useProductionSafetyStore } from "@/stores/productionSafetyStore";
import { executeOracleTriggerPlan, type OracleTriggerExecutionResult, type OracleTriggerPlan, type OracleTriggerSnapshot, type OracleTriggerTarget } from "./oracleTriggerPlan";

/** Reuse the application's SQL preview/confirmation queue; no second execution dialog or executor. */
export async function confirmOracleTriggerPlan(plan: OracleTriggerPlan, options: { isCurrent: () => boolean; refresh?: (target: Readonly<OracleTriggerTarget>, snapshot?: OracleTriggerSnapshot) => Promise<void> }): Promise<OracleTriggerExecutionResult> {
  const danger = useSqlExecutionDangerStore();
  const production = useProductionSafetyStore();
  const scopeId = `oracle-trigger:${uuid()}`;
  const stop = watch(
    options.isCurrent,
    (current) => {
      if (!current) {
        danger.cancelScope(scopeId);
        production.cancelScope(scopeId);
      }
    },
    { flush: "sync" },
  );
  try {
    const connection = useConnectionStore().getConfig(plan.target.connectionId);
    const binding = plan.expectedAfter?.binding;
    const parent = binding ?? (plan.before.metadata.parent ? { scope: plan.before.metadata.parent.objectType, ...plan.before.metadata.parent } : { scope: plan.before.metadata.scope, owner: plan.before.metadata.scopeOwner });
    const targets = [`TRIGGER ${plan.target.owner}.${plan.target.name}`, `ON ${parent.scope}${parent.owner ? ` ${parent.owner}${"name" in parent && parent.name ? `.${parent.name}` : ""}` : ""}`, `${i18n.global.t("oracleTrigger.executionSchema")}: ${plan.target.executionSchema}`];
    if (plan.steps.length > 1) targets.push(i18n.global.t("oracleTrigger.nonAtomic"));
    const confirmed =
      options.isCurrent() &&
      (plan.steps.length === 0 ||
        (await danger.requestConfirmation({
          sql: plan.steps.map((step) => step.sql).join("\n\n"),
          kind: "sql",
          connectionName: connection?.name,
          database: plan.target.database,
          targetLabel: targets.join("\n"),
          databaseType: plan.before.metadata.engine === "dm" ? "dameng" : plan.before.metadata.engine,
          scopeId,
        })));
    return await executeOracleTriggerPlan(plan, { confirmed, confirmationScope: scopeId, ...options });
  } finally {
    stop();
    danger.cancelScope(scopeId);
    production.cancelScope(scopeId);
  }
}