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.8 KB
Raw Blame
import { afterEach, describe, expect, it, vi } from "vitest";
import * as api from "@/lib/backend/api.ts";
import { fetchDatabaseSearchColumns, findSearchColumns, searchColumnsTableKey } from "@/lib/database/databaseSearchColumns";

afterEach(() => {
  vi.restoreAllMocks();
});

function rowsResult(columns: string[], rows: unknown[][]) {
  return { columns, rows };
}

describe("databaseSearchColumns", () => {
  it("groups catalog rows by table with lowercase keys", async () => {
    const buildSpy = vi.spyOn(api, "buildDatabaseSearchColumnsSql").mockResolvedValue({ sql: "SELECT 1" });
    const executeQuery = vi.fn().mockResolvedValue(
      rowsResult(
        ["TABLE_NAME", "COLUMN_NAME", "DATA_TYPE", "IS_PRIMARY_KEY"],
        [
          ["USERS", "ID", "NUMBER", 1],
          ["USERS", "EMAIL", "VARCHAR2", 0],
          ["ORDERS", "ID", "NUMBER", 1],
        ],
      ),
    );

    const map = await fetchDatabaseSearchColumns({
      databaseType: "dameng",
      database: "app",
      schema: "DLWEB",
      executeQuery,
      executionId: "exec-1",
    });

    expect(buildSpy).toHaveBeenCalledWith({ databaseType: "dameng", database: "app", schema: "DLWEB" });
    const users = findSearchColumns(map, "DLWEB", "app", "USERS");
    expect(users).toHaveLength(2);
    expect(users?.[0]).toEqual({ name: "ID", data_type: "NUMBER", is_primary_key: true });
    expect(users?.[1]?.is_primary_key).toBe(false);
    expect(findSearchColumns(map, "dlweb", "app", "users")).toHaveLength(2);
    expect(findSearchColumns(map, "DLWEB", "app", "ORDERS")).toHaveLength(1);
  });

  it("normalizes primary key flag variants", async () => {
    vi.spyOn(api, "buildDatabaseSearchColumnsSql").mockResolvedValue({ sql: "SELECT 1" });
    const executeQuery = vi.fn().mockResolvedValue(
      rowsResult(
        ["table_name", "column_name", "data_type", "is_primary_key"],
        [
          ["t1", "a", "int", true],
          ["t1", "b", "int", false],
          ["t2", "a", "int", "1"],
          ["t2", "b", "int", "0"],
          ["t3", "a", "int", 1],
          ["t3", "b", "int", 0],
        ],
      ),
    );

    const map = await fetchDatabaseSearchColumns({ databaseType: "postgres", database: "app", executeQuery, executionId: "e" });
    const t1 = findSearchColumns(map, undefined, "app", "t1")!;
    const t2 = findSearchColumns(map, undefined, "app", "t2")!;
    const t3 = findSearchColumns(map, undefined, "app", "t3")!;
    expect(t1.map((c) => c.is_primary_key)).toEqual([true, false]);
    expect(t2.map((c) => c.is_primary_key)).toEqual([true, false]);
    expect(t3.map((c) => c.is_primary_key)).toEqual([true, false]);
  });

  it("returns empty map when builder yields no sql", async () => {
    const buildSpy = vi.spyOn(api, "buildDatabaseSearchColumnsSql").mockResolvedValue(null);
    const executeQuery = vi.fn();
    const map = await fetchDatabaseSearchColumns({ databaseType: "dameng", database: "app", executeQuery, executionId: "e" });
    expect(map.size).toBe(0);
    expect(buildSpy).toHaveBeenCalled();
    expect(executeQuery).not.toHaveBeenCalled();
  });

  it("returns empty map when the catalog result is truncated so callers fall back per-table", async () => {
    vi.spyOn(api, "buildDatabaseSearchColumnsSql").mockResolvedValue({ sql: "SELECT 1" });
    const executeQuery = vi.fn().mockResolvedValue({
      columns: ["TABLE_NAME", "COLUMN_NAME", "DATA_TYPE", "IS_PRIMARY_KEY"],
      rows: [
        ["USERS", "ID", "NUMBER", 1],
        ["USERS", "EMAIL", "VARCHAR2", 0],
      ],
      truncated: true,
    });

    const map = await fetchDatabaseSearchColumns({
      databaseType: "dameng",
      database: "app",
      schema: "DLWEB",
      executeQuery,
      executionId: "exec-1",
    });

    expect(map.size).toBe(0);
  });

  it("returns empty map when the catalog query fails", async () => {
    vi.spyOn(api, "buildDatabaseSearchColumnsSql").mockResolvedValue({ sql: "SELECT 1" });
    const executeQuery = vi.fn().mockRejectedValue(new Error("permission denied"));
    const map = await fetchDatabaseSearchColumns({ databaseType: "mysql", database: "app", executeQuery, executionId: "e" });
    expect(map.size).toBe(0);
  });

  it("skips bulk fetch for unsupported dialects without calling the builder", async () => {
    const buildSpy = vi.spyOn(api, "buildDatabaseSearchColumnsSql");
    const map = await fetchDatabaseSearchColumns({ databaseType: "sqlite", database: "app", executeQuery: vi.fn(), executionId: "e" });
    expect(map.size).toBe(0);
    expect(buildSpy).not.toHaveBeenCalled();
  });

  it("keys use schema when present and database otherwise", () => {
    expect(searchColumnsTableKey("public", "app", "Users")).toBe("public\nusers");
    expect(searchColumnsTableKey(undefined, "app", "Users")).toBe("app\nusers");
    expect(searchColumnsTableKey("  ", "app", "Users")).toBe("app\nusers");
  });
});