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。

4.4 KB
Raw Blame
// @vitest-environment happy-dom

import { createApp, defineComponent, h, type App } from "vue";
import { createPinia, setActivePinia } from "pinia";
import { createI18n } from "vue-i18n";
import { afterEach, describe, expect, it, vi } from "vitest";
import { useConnectionStore } from "@/stores/connectionStore";
import ObjectSourceDialog from "@/components/objects/ObjectSourceDialog.vue";

const mocks = vi.hoisted(() => ({
  getObjectSource: vi.fn(),
  buildEditableObjectSource: vi.fn(),
}));

vi.mock("@/lib/backend/api", async (importOriginal) => ({
  ...(await importOriginal<typeof import("@/lib/backend/api")>()),
  ...mocks,
}));
vi.mock("@/components/editor/QueryEditor.vue", () => ({
  default: defineComponent({
    name: "QueryEditorStub",
    props: { modelValue: { type: String, default: "" } },
    template: "<div data-query-editor-stub>{{ modelValue }}</div>",
  }),
}));

const mountedApps: Array<{ app: App; host: HTMLElement }> = [];

afterEach(() => {
  for (const { app, host } of mountedApps.splice(0)) {
    app.unmount();
    host.remove();
  }
  vi.restoreAllMocks();
  Object.values(mocks).forEach((mock) => mock.mockReset());
});

async function mountDialog() {
  const pinia = createPinia();
  setActivePinia(pinia);
  const connectionStore = useConnectionStore();
  vi.spyOn(connectionStore, "ensureConnected").mockResolvedValue(undefined);
  const host = document.createElement("div");
  document.body.append(host);
  const app = createApp({
    render: () =>
      h(ObjectSourceDialog, {
        open: true,
        connectionId: "jdbc-1",
        database: "catalog1",
        schema: "APP",
        name: "calculate_total",
        objectType: "FUNCTION",
        databaseType: "jdbc",
        dialect: "mysql",
      }),
  });
  app.use(pinia);
  app.use(createI18n({ legacy: false, locale: "en", messages: { en: {} }, missingWarn: false, fallbackWarn: false }));
  app.mount(host);
  mountedApps.push({ app, host });
  return host;
}

describe("ObjectSourceDialog generic JDBC routine metadata", () => {
  it("renders a source-less function as read-only structured metadata", async () => {
    mocks.getObjectSource.mockResolvedValue({
      name: "calculate_total",
      object_type: "FUNCTION",
      schema: "APP",
      source: "",
      editable: false,
      routine_parameters: [
        { name: "result", mode: "OUT", jdbc_type: 12, type_name: "VARCHAR", length: 32, nullable: true, ordinal: 2 },
        { name: "RETURN", mode: "RETURN", jdbc_type: 3, type_name: "DECIMAL", precision: 12, scale: 2, ordinal: 0 },
        { name: "amount", mode: "IN", jdbc_type: 3, type_name: "DECIMAL", precision: 10, scale: 2, nullable: false, ordinal: 1 },
      ],
    });
    mocks.buildEditableObjectSource.mockResolvedValue("");

    await mountDialog();
    await vi.waitFor(() => expect(document.querySelectorAll("[data-routine-parameter]")).toHaveLength(2));

    expect(document.querySelector("[data-routine-return-type]")?.textContent).toContain("DECIMAL(12,2)");
    const rows = [...document.querySelectorAll("[data-routine-parameter]")];
    expect(rows[0].textContent).toContain("amount");
    expect(rows[0].textContent).toContain("DECIMAL(10,2)");
    expect(rows[1].textContent).toContain("VARCHAR(32)");
    expect(document.querySelector("[data-query-editor-stub]")).toBeNull();
    expect(document.body.textContent).not.toContain("Object source is not supported");
    expect(mocks.getObjectSource).toHaveBeenCalledTimes(1);
    expect([...document.querySelectorAll("button")].some((button) => button.textContent?.trim() === "contextMenu.editObject" || button.textContent?.trim() === "contextMenu.editView")).toBe(false);
  });

  it("keeps a legacy source payload without the optional field on the existing preview path", async () => {
    mocks.getObjectSource.mockResolvedValue({
      name: "calculate_total",
      object_type: "FUNCTION",
      schema: "APP",
      source: "CREATE FUNCTION calculate_total() RETURNS INTEGER RETURN 1",
      editable: false,
    });
    mocks.buildEditableObjectSource.mockResolvedValue("CREATE FUNCTION calculate_total() RETURNS INTEGER RETURN 1");

    await mountDialog();
    await vi.waitFor(() => expect(document.querySelector("[data-query-editor-stub]")).not.toBeNull());

    expect(document.querySelector("[data-routine-metadata]")).toBeNull();
    expect(document.querySelector("[data-query-editor-stub]")?.textContent).toContain("CREATE FUNCTION");
  });
});