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, defineComponent, h, nextTick, type App } from "vue";
import { afterEach, beforeEach, describe, expect, it, vi } from "vitest";
import type { SchemaDiffObject } from "@/lib/schema/schemaDiff";
vi.mock("vue-i18n", () => ({
useI18n: () => ({ t: (key: string) => key }),
}));
vi.mock("@/composables/useToast", () => ({
useToast: () => ({ toast: vi.fn() }),
}));
vi.mock("@/lib/common/clipboard", () => ({
copyToClipboard: vi.fn(),
}));
vi.mock("@/stores/settingsStore", () => ({
useSettingsStore: () => ({
editorSettings: {
customThemes: [],
activeCustomThemeId: "",
},
}),
DEFAULT_CUSTOM_THEME_DDL_COLORS: {
addedRowBg: "#00ff00",
addedRowBgAlpha: 20,
removedRowBg: "#ff0000",
removedRowBgAlpha: 20,
modifiedRowBg: "#ffaa00",
modifiedRowBgAlpha: 20,
modifiedCharBg: "#ffaa00",
modifiedCharBgAlpha: 40,
},
}));
vi.mock("@/components/diff/DiffSvgConnector.vue", () => ({
default: defineComponent({
setup() {
return () => h("div", { class: "diff-svg-connector" });
},
}),
}));
vi.mock("splitpanes", () => ({
Splitpanes: defineComponent({
setup(_props, { slots }) {
return () => h("div", { class: "splitpanes" }, slots.default?.());
},
}),
Pane: defineComponent({
setup(_props, { slots }) {
return () => h("div", { class: "pane" }, slots.default?.());
},
}),
}));
vi.mock("@/components/ui/switch", async () => {
const { defineComponent, h } = await import("vue");
return {
Switch: defineComponent({
props: { modelValue: Boolean },
emits: ["update:modelValue"],
setup(props, { emit }) {
return () =>
h("button", {
class: "switch-stub",
"data-model-value": String(props.modelValue),
onClick: () => emit("update:modelValue", !props.modelValue),
});
},
}),
};
});
import SchemaDiffDdlPanel from "@/components/diff/SchemaDiffDdlPanel.vue";
const mountedApps: App[] = [];
beforeEach(() => {
localStorage.clear();
});
afterEach(() => {
for (const app of mountedApps.splice(0)) app.unmount();
document.body.innerHTML = "";
});
describe("SchemaDiffDdlPanel", () => {
const sampleObject: SchemaDiffObject = {
id: "table-users",
operationType: "modify",
objectKind: "table",
name: "users",
selected: true,
sourceDdl: `CREATE TABLE "public"."users" (
"id" integer NOT NULL,
"name" text NOT NULL,
CONSTRAINT "users_pkey" PRIMARY KEY ("id")
);`,
targetDdl: `CREATE TABLE "other_schema"."users" (
"id" integer NOT NULL,
"name" text NOT NULL,
CONSTRAINT "users_pkey" PRIMARY KEY ("id")
);`,
};
it("shows raw DDL by default and keeps the schema-name switch off", async () => {
const host = document.createElement("div");
document.body.append(host);
const app = createApp(
defineComponent({
setup() {
return () =>
h(SchemaDiffDdlPanel, {
selectedObject: sampleObject,
sourceSchema: "public",
targetSchema: "other_schema",
deploySql: "",
deploySqlAll: "",
});
},
}),
);
mountedApps.push(app);
app.mount(host);
await nextTick();
// Check header displays schema names
expect(host.textContent).toContain("diff.sourceDdl (public)");
expect(host.textContent).toContain("diff.targetDdl (other_schema)");
// Check switch exists and starts off
const switchLabel = host.querySelector("label");
expect(switchLabel?.textContent).toContain("diff.ignoreSchemaName");
const switchBtn = host.querySelector(".switch-stub") as HTMLButtonElement | null;
expect(switchBtn?.getAttribute("data-model-value")).toBe("false");
// Raw DDL, including schema qualifiers, is shown by default
expect(host.textContent).toContain('CREATE TABLE "public"."users"');
expect(host.textContent).toContain('CREATE TABLE "other_schema"."users"');
// The toggle is per dialog and never persisted
expect(localStorage.getItem("dbx-schema-diff-ignore-schema-name")).toBeNull();
});
it("strips schema names when the switch is toggled on without persisting it", async () => {
const host = document.createElement("div");
document.body.append(host);
const app = createApp(
defineComponent({
setup() {
return () =>
h(SchemaDiffDdlPanel, {
selectedObject: sampleObject,
sourceSchema: "public",
targetSchema: "other_schema",
deploySql: "",
deploySqlAll: "",
});
},
}),
);
mountedApps.push(app);
app.mount(host);
await nextTick();
// Find the switch button and click it to turn it on
const switchBtn = host.querySelector(".switch-stub") as HTMLButtonElement | null;
expect(switchBtn).not.toBeNull();
switchBtn?.click();
await nextTick();
// Now the schema qualifiers should be stripped on both sides
expect(host.textContent).toContain('CREATE TABLE "users"');
expect(host.textContent).not.toContain('CREATE TABLE "public"."users"');
expect(host.textContent).not.toContain('CREATE TABLE "other_schema"."users"');
// Toggling is not persisted across dialogs
expect(localStorage.getItem("dbx-schema-diff-ignore-schema-name")).toBeNull();
});
it("uses the selected database as schema for MySQL views without an explicit schema", async () => {
const mysqlViewObject: SchemaDiffObject = {
id: "view-active-users",
operationType: "modify",
objectKind: "view",
name: "active_users",
selected: true,
sourceDdl: "CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `mydb`.`active_users` AS SELECT * FROM `mydb`.`users`;",
targetDdl: "CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `otherdb`.`active_users` AS SELECT * FROM `otherdb`.`users`;",
};
const host = document.createElement("div");
document.body.append(host);
const app = createApp(
defineComponent({
setup() {
return () =>
h(SchemaDiffDdlPanel, {
selectedObject: mysqlViewObject,
sourceDatabase: "mydb",
targetDatabase: "otherdb",
sourceDbType: "mysql",
targetDbType: "mysql",
deploySql: "",
deploySqlAll: "",
});
},
}),
);
mountedApps.push(app);
app.mount(host);
await nextTick();
const switchBtn = host.querySelector(".switch-stub") as HTMLButtonElement | null;
expect(switchBtn).not.toBeNull();
switchBtn?.click();
await nextTick();
// The database is the schema for MySQL, so the qualifier is stripped even
// though the schema picker left sourceSchema/targetSchema empty.
expect(host.textContent).toContain("VIEW `active_users` AS SELECT * FROM `users`");
expect(host.textContent).not.toContain("VIEW `mydb`.");
expect(host.textContent).not.toContain("VIEW `otherdb`.");
});
});