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。

3.9 KB
Raw Blame
import { createPinia, setActivePinia } from "pinia";
import { beforeEach, describe, expect, it, vi } from "vitest";
import * as api from "@/lib/backend/api";
import { useSavedSqlStore } from "@/stores/savedSqlStore";

const mocks = vi.hoisted(() => ({
  syncDir: { value: "/workspace/dbx-sql-sync" as string | null },
}));

vi.mock("@/lib/backend/tauriRuntime", () => ({ isTauriRuntime: () => true }));
vi.mock("@/stores/settingsStore", () => ({
  useSettingsStore: () => ({
    desktopSettings: { saved_sql_sync_dir: mocks.syncDir.value },
  }),
}));
vi.mock("@/lib/backend/api", () => ({
  loadSavedSqlLibrary: vi.fn(),
  loadSavedSqlFilesForSync: vi.fn(),
  loadSavedSqlFile: vi.fn(),
  saveSavedSqlFile: vi.fn(),
  syncSavedSqlDirectory: vi.fn(),
}));

function library(sqlLoaded: boolean) {
  return {
    folders: [
      {
        id: "folder-1",
        connectionId: "connection-1",
        name: "Reports",
        orderIndex: 0,
        createdAt: "2026-08-14T00:00:00.000Z",
        updatedAt: "2026-08-14T00:00:00.000Z",
      },
    ],
    files: [
      {
        id: "file-1",
        connectionId: "connection-1",
        folderId: "folder-1",
        name: "daily.sql",
        database: "",
        sql: sqlLoaded ? "SELECT 1;" : "",
        sqlLoaded,
        orderIndex: 0,
        openCount: 0,
        createdAt: "2026-08-14T00:00:00.000Z",
        updatedAt: "2026-08-14T00:00:00.000Z",
      },
      {
        id: "file-2",
        connectionId: "connection-1",
        folderId: "folder-1",
        name: "weekly.sql",
        database: "",
        sql: sqlLoaded ? "SELECT 7;" : "",
        sqlLoaded,
        orderIndex: 1,
        openCount: 0,
        createdAt: "2026-08-14T00:00:00.000Z",
        updatedAt: "2026-08-14T00:00:00.000Z",
      },
    ],
  };
}

describe("savedSqlStore directory sync", () => {
  beforeEach(() => {
    const storage = new Map<string, string>();
    vi.stubGlobal("localStorage", {
      getItem: (key: string) => storage.get(key) ?? null,
      setItem: (key: string, value: string) => storage.set(key, value),
      removeItem: (key: string) => storage.delete(key),
      clear: () => storage.clear(),
    });
    setActivePinia(createPinia());
    vi.clearAllMocks();
    mocks.syncDir.value = "/workspace/dbx-sql-sync";
    vi.mocked(api.loadSavedSqlLibrary).mockResolvedValue(library(false));
    vi.mocked(api.loadSavedSqlFilesForSync).mockResolvedValue(library(true).files);
    vi.mocked(api.saveSavedSqlFile).mockImplementation(async (file) => file);
    vi.mocked(api.syncSavedSqlDirectory).mockResolvedValue(undefined);
  });

  it("hydrates an unloaded library with one batch request and reuses it", async () => {
    const store = useSavedSqlStore();
    await store.initFromStorage();

    await store.syncToLocalDirectory();
    await store.syncToLocalDirectory();

    expect(api.loadSavedSqlFilesForSync).toHaveBeenCalledTimes(1);
    expect(api.loadSavedSqlFile).not.toHaveBeenCalled();
    expect(api.syncSavedSqlDirectory).toHaveBeenCalledTimes(2);
    expect(api.syncSavedSqlDirectory).toHaveBeenLastCalledWith({
      targetDir: "/workspace/dbx-sql-sync",
      entries: [
        { folderName: "Reports", fileName: "daily.sql", sql: "SELECT 1;" },
        { folderName: "Reports", fileName: "weekly.sql", sql: "SELECT 7;" },
      ],
    });
  });

  it("does not add a sync read or request when directory sync is disabled", async () => {
    mocks.syncDir.value = null;
    const store = useSavedSqlStore();
    await store.initFromStorage();

    await store.saveFile({
      id: "file-1",
      connectionId: "connection-1",
      folderId: "folder-1",
      name: "daily.sql",
      database: "",
      sql: "SELECT 2;",
    });

    expect(api.saveSavedSqlFile).toHaveBeenCalledTimes(1);
    expect(api.loadSavedSqlFilesForSync).not.toHaveBeenCalled();
    expect(api.loadSavedSqlFile).not.toHaveBeenCalled();
    expect(api.syncSavedSqlDirectory).not.toHaveBeenCalled();
  });
});