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。
TypeScript aicliclickhousedatabasedatabase-clientdatabase-managementdockerguimcpmongodbmysqlpostgresqlredisrustsql-serversqlitetaurivue
// @vitest-environment happy-dom
import { createApp, h, nextTick, reactive } from "vue";
import { afterEach, beforeEach, describe, expect, it, vi } from "vitest";
import i18n, { setLocale } from "@/i18n";
import OracleRoutineRenamePreview from "../OracleRoutineRenamePreview.vue";
import type { OracleRoutineRenamePlan } from "@/lib/table/oracleRoutineRename";
function fixture(): OracleRoutineRenamePlan {
const target = { connectionId: "routine-preview", database: "APP", databaseType: "oceanbase-oracle" as const, schema: "APP", objectType: "PROCEDURE" as const, oldName: "P_OLD", newName: "P_NEW" };
const root = { name: "P_OLD", objectType: "PROCEDURE", objectId: "101", status: "VALID", source: "CREATE OR REPLACE PROCEDURE APP.P_OLD AS BEGIN NULL; END;", signature: "[]", grants: "[]", errors: "[]" };
return {
target,
canonicalNewName: "P_NEW",
root,
rootDraft: root.source,
rootCreateSource: "CREATE PROCEDURE APP.P_NEW AS BEGIN NULL; END;",
callers: [],
dependencyEdges: [],
statements: ["CREATE PROCEDURE APP.P_NEW AS BEGIN NULL; END;", "DROP PROCEDURE APP.P_OLD"],
steps: [
{ kind: "create", objectName: "P_NEW", objectType: "PROCEDURE", sql: "CREATE PROCEDURE APP.P_NEW AS BEGIN NULL; END;" },
{ kind: "drop", objectName: "P_OLD", objectType: "PROCEDURE", sql: "DROP PROCEDURE APP.P_OLD" },
],
issues: [{ code: "unsupported_dependency", message: "Cannot update dependent OTHER.P_CALLER (PACKAGE).", objectName: "P_CALLER", repairable: false }],
metadataComplete: true,
executable: false,
};
}
const cleanups: Array<() => void> = [];
function mount(options: Partial<{ plan: OracleRoutineRenamePlan | null; drafts: Record<string, string>; loading: boolean; validating: boolean; executing: boolean }> = {}) {
const state = reactive({ plan: fixture() as OracleRoutineRenamePlan | null, drafts: {} as Record<string, string>, loading: false, validating: false, executing: false, ...options });
const reload = vi.fn();
const edit = vi.fn();
const validate = vi.fn();
const container = document.createElement("div");
document.body.appendChild(container);
const app = createApp({ render: () => h(OracleRoutineRenamePreview, { ...state, onEdit: edit, onValidate: validate, onReload: reload }) }).use(i18n);
app.mount(container);
cleanups.push(() => {
app.unmount();
container.remove();
});
return { container, state, reload, edit, validate };
}
describe("Oracle routine rename preview", () => {
beforeEach(async () => {
await setLocale("zh-CN");
});
afterEach(() => cleanups.splice(0).forEach((cleanup) => cleanup()));
it("shows the blocking dependent and the exact SQL sequence without enabling execution", () => {
const { container } = mount();
expect(container.textContent).toContain("P_CALLER");
expect(container.textContent).toContain("PACKAGE");
expect(container.textContent).toContain("CREATE PROCEDURE APP.P_NEW AS BEGIN NULL; END;");
expect(container.textContent).toContain("DROP PROCEDURE APP.P_OLD");
expect(container.querySelector('[role="status"]')!.textContent).toBe(i18n.global.t("objects.viewRenameValidationPending"));
});
it("hides plan SQL after an unvalidated source edit", async () => {
const { container, state } = mount();
state.drafts["PROCEDURE:P_OLD"] = "CREATE OR REPLACE PROCEDURE APP.P_OLD AS BEGIN NULL; END; -- edited";
await nextTick();
expect(container.textContent).not.toContain("DROP PROCEDURE APP.P_OLD");
});
it("offers a localized refresh control and disables it while execution is active", async () => {
const { container, state, reload } = mount();
const button = container.querySelector<HTMLButtonElement>("[data-reload]")!;
button.click();
expect(reload).toHaveBeenCalledOnce();
state.executing = true;
await nextTick();
expect(button.disabled).toBe(true);
});
it("keeps a failed caller editable and emits edits for revalidation", async () => {
const original = "CREATE PROCEDURE APP.CALLER_1 AS BEGIN EXECUTE IMMEDIATE 'BEGIN APP.P_OLD; END;'; END;";
const plan = {
...fixture(),
callers: [{ name: "CALLER_1", objectType: "PROCEDURE", objectId: "102", status: "VALID", source: original, signature: "[]", grants: "[]", errors: "[]", rewrittenSource: "", rewrittenFingerprint: "", rewriteRequired: true, depth: 1, draft: original }],
issues: [{ code: "caller_rewrite_failed", message: "Dynamic routine references cannot be rewritten automatically.", objectName: "CALLER_1", repairable: true }],
} as unknown as OracleRoutineRenamePlan;
const { container, edit, validate } = mount({ plan, drafts: {} });
const editor = container.querySelector<HTMLTextAreaElement>('[data-source-draft="PROCEDURE:CALLER_1"]');
expect(editor?.value).toBe(original);
editor!.value = original.replace("P_OLD", "P_NEW");
editor!.dispatchEvent(new Event("input", { bubbles: true }));
expect(edit).toHaveBeenCalledWith("PROCEDURE:CALLER_1", expect.stringContaining("P_NEW"));
container.querySelector<HTMLButtonElement>("[data-validate]")!.click();
expect(validate).toHaveBeenCalledOnce();
});
});