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, nextTick, type App } from "vue";
import { createPinia, setActivePinia } from "pinia";
import { afterEach, beforeEach, describe, expect, it, vi } from "vitest";
import i18n from "@/i18n";
import { useQueryStore } from "@/stores/queryStore";
import { useSavedSqlStore } from "@/stores/savedSqlStore";
import type { SavedSqlFile } from "@/types/database";
import { changeSearchMode } from "./sqlSearchTestUtils";
vi.mock("@/components/ui/select", () => import("./sqlSearchTestUtils"));
vi.mock("@/lib/backend/tauriRuntime", () => ({ isTauriRuntime: () => false }));
import SqlLibraryPanel from "../SqlLibraryPanel.vue";
const mounted: Array<{ app: App; host: HTMLElement }> = [];
const timestamp = "2026-10-01T00:00:00Z";
function file(id: string, name: string, sql: string, sqlLoaded = true): SavedSqlFile {
return { id, name, sql, sqlLoaded, connectionId: "", database: "metadata-only", createdAt: timestamp, updatedAt: timestamp };
}
async function mountPanel() {
const pinia = createPinia();
setActivePinia(pinia);
const store = useSavedSqlStore();
store.loadState = "loaded";
store.files = [file("name", "needle.sql", "SELECT 1"), file("body", "other.sql", "", false)];
const load = vi.spyOn(store, "ensureAllFilesLoaded").mockResolvedValue(undefined);
const host = document.createElement("div");
document.body.appendChild(host);
const app = createApp(SqlLibraryPanel);
app.use(pinia);
app.use(i18n);
app.mount(host);
mounted.push({ app, host });
await nextTick();
return { host, store, load };
}
async function typeQuery(host: HTMLElement, query: string) {
const input = host.querySelector<HTMLInputElement>("[data-sql-library-search]")!;
input.value = query;
input.dispatchEvent(new Event("input"));
await nextTick();
}
function visibleFiles(host: HTMLElement) {
return [...host.querySelectorAll("[data-sql-library-file]")].map((row) => row.getAttribute("data-sql-library-file"));
}
beforeEach(() => localStorage.clear());
afterEach(() => {
for (const { app, host } of mounted.splice(0)) {
app.unmount();
host.remove();
}
vi.restoreAllMocks();
});
describe("SQL library search scopes", () => {
it("defaults to filenames without loading content, even on focus", async () => {
const { host, load } = await mountPanel();
host.querySelector<HTMLInputElement>("[data-sql-library-search]")!.focus();
await typeQuery(host, "needle");
expect(visibleFiles(host)).toEqual(["name"]);
expect(load).not.toHaveBeenCalled();
expect(host.querySelector(".dbx-sql-library-snippets")).toBeNull();
await typeQuery(host, "metadata-only");
expect(visibleFiles(host)).toEqual([]);
});
it("loads only for content searches and excludes matching names and directories", async () => {
const { host, store, load } = await mountPanel();
store.folders = [{ id: "folder", connectionId: "", name: "needle", createdAt: timestamp, updatedAt: timestamp }];
store.files.push({ ...file("unrelated", "unrelated.sql", "SELECT 1"), folderId: "folder" });
load.mockImplementation(async () => {
store.files = store.files.map((entry) => (entry.id === "body" ? { ...entry, sql: "SELECT needle", sqlLoaded: true } : entry));
});
await changeSearchMode(host, "content");
expect(load).not.toHaveBeenCalled();
await typeQuery(host, "needle");
await vi.waitFor(() => expect(visibleFiles(host)).toEqual(["body"]));
expect(load).toHaveBeenCalledTimes(1);
expect(host.querySelector("mark")?.textContent).toBe("needle");
await changeSearchMode(host, "name");
expect(visibleFiles(host)).toContain("name");
expect(visibleFiles(host)).not.toContain("body");
expect(host.querySelector(".dbx-sql-library-snippets")).toBeNull();
});
it("shows pending and incomplete states, allows retry, and does not claim no matches", async () => {
const { host, store, load } = await mountPanel();
let complete!: () => void;
load.mockImplementationOnce(
() =>
new Promise<void>((resolve) => {
complete = resolve;
}),
);
await changeSearchMode(host, "content");
await typeQuery(host, "needle");
expect(host.textContent).toContain(i18n.global.t("sqlFileTree.searching"));
await vi.waitFor(() => expect(load).toHaveBeenCalledTimes(1));
await typeQuery(host, "other");
host.querySelector<HTMLInputElement>("[data-sql-library-search]")!.dispatchEvent(new KeyboardEvent("keydown", { key: "Enter" }));
await nextTick();
expect(load).toHaveBeenCalledTimes(1);
complete();
await vi.waitFor(() => expect(host.textContent).toContain(i18n.global.t("sqlLibrary.searchContentIncomplete", { count: 1 })));
expect(host.textContent).not.toContain(i18n.global.t("grid.noSearchResults"));
load.mockImplementationOnce(async () => {
store.files = store.files.map((entry) => ({ ...entry, sqlLoaded: true }));
});
const retry = [...host.querySelectorAll("button")].find((button) => button.textContent?.trim() === i18n.global.t("common.retry"));
retry!.click();
await vi.waitFor(() => expect(host.textContent).toContain(i18n.global.t("grid.noSearchResults")));
expect(load).toHaveBeenCalledTimes(2);
});
});
describe("SQL library locate and search preferences", () => {
it("remembers content mode across remounts without restoring a query or loading SQL", async () => {
const first = await mountPanel();
await changeSearchMode(first.host, "content");
await typeQuery(first.host, "needle");
const mountedFirst = mounted.pop()!;
mountedFirst.app.unmount();
mountedFirst.host.remove();
const second = await mountPanel();
expect(second.host.querySelector<HTMLSelectElement>("[data-search-mode]")!.value).toBe("content");
expect(second.host.querySelector<HTMLInputElement>("[data-sql-library-search]")!.value).toBe("");
expect(second.load).not.toHaveBeenCalled();
await changeSearchMode(second.host, "name");
expect(localStorage.getItem("dbx-sql-library-search-mode")).toBe("name");
});
it("locates the current nested file, clears a blocking search and preserves its mode", async () => {
const { host, store } = await mountPanel();
store.folders = [
{ id: "root", name: "Root", connectionId: "", createdAt: timestamp, updatedAt: timestamp },
{ id: "child", parentFolderId: "root", name: "Child", connectionId: "", createdAt: timestamp, updatedAt: timestamp },
];
store.files[0]!.folderId = "child";
useQueryStore().openSavedSql(store.files[0]!);
await nextTick();
expect(visibleFiles(host)).not.toContain("name");
await changeSearchMode(host, "content");
await typeQuery(host, "unmatched");
const scroll = vi.spyOn(HTMLElement.prototype, "scrollIntoView").mockImplementation(() => {});
host.querySelector<HTMLButtonElement>("[data-sidebar-locate-button]")!.click();
await nextTick();
expect(visibleFiles(host)).toContain("name");
expect(host.querySelector<HTMLInputElement>("[data-sql-library-search]")!.value).toBe("");
expect(host.querySelector<HTMLSelectElement>("[data-search-mode]")!.value).toBe("content");
expect(scroll.mock.instances.at(-1)).toBe(host.querySelector('[data-sql-library-file="name"]'));
expect(useQueryStore().tabs).toHaveLength(1);
});
it("keeps a search that already includes the active unfiled SQL", async () => {
const { host, store } = await mountPanel();
useQueryStore().openSavedSql(store.files[0]!);
await typeQuery(host, "needle");
const scroll = vi.spyOn(HTMLElement.prototype, "scrollIntoView").mockImplementation(() => {});
host.querySelector<HTMLButtonElement>("[data-sidebar-locate-button]")!.click();
await nextTick();
expect(host.querySelector<HTMLInputElement>("[data-sql-library-search]")!.value).toBe("needle");
expect(scroll).toHaveBeenCalledOnce();
});
it("disables locate without an existing saved SQL file", async () => {
const { host, store } = await mountPanel();
const button = host.querySelector<HTMLButtonElement>("[data-sidebar-locate-button]")!;
expect(button.disabled).toBe(true);
useQueryStore().openSavedSql(store.files[0]!);
await nextTick();
expect(button.disabled).toBe(false);
store.files = [];
await nextTick();
expect(button.disabled).toBe(true);
});
it("handles locateRequest prop, uncollapses ancestors, scrolls into view and emits locate-handled", async () => {
const onLocateHandled = vi.fn();
const pinia = createPinia();
setActivePinia(pinia);
const store = useSavedSqlStore();
store.loadState = "loaded";
store.folders = [
{ id: "root", name: "Root", connectionId: "", createdAt: timestamp, updatedAt: timestamp },
{ id: "child", parentFolderId: "root", name: "Child", connectionId: "", createdAt: timestamp, updatedAt: timestamp },
];
store.files = [file("unrelated", "unrelated.sql", "SELECT 1"), { ...file("nested-file", "nested.sql", "SELECT 42"), folderId: "child" }];
vi.spyOn(store, "ensureAllFilesLoaded").mockResolvedValue(undefined);
const scroll = vi.spyOn(HTMLElement.prototype, "scrollIntoView").mockImplementation(() => {});
const host = document.createElement("div");
document.body.appendChild(host);
const app = createApp(SqlLibraryPanel, {
locateRequest: { id: 42, fileId: "nested-file" },
"onLocate-handled": onLocateHandled,
});
app.use(pinia);
app.use(i18n);
app.mount(host);
mounted.push({ app, host });
await vi.waitFor(() => expect(onLocateHandled).toHaveBeenCalledWith(42));
expect(visibleFiles(host)).toContain("nested-file");
expect(scroll.mock.instances.at(-1)).toBe(host.querySelector('[data-sql-library-file="nested-file"]'));
});
});