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。

2.6 KB
Raw Blame
import { describe, expect, it } from "vitest";
import { SQL_FILE_CLOSE_ON_SUCCESS_STORAGE_KEY, readSqlFileCloseOnSuccess, writeSqlFileCloseOnSuccess } from "../sqlFileExecutionOptions";

describe("sqlFileExecutionOptions", () => {
  function createMockStorage(initial: Record<string, string> = {}): Storage {
    const store = new Map<string, string>(Object.entries(initial));
    return {
      getItem: (key: string) => store.get(key) ?? null,
      setItem: (key: string, value: string) => store.set(key, value),
      removeItem: (key: string) => store.delete(key),
      clear: () => store.clear(),
      key: (index: number) => Array.from(store.keys())[index] ?? null,
      get length() {
        return store.size;
      },
    };
  }

  describe("readSqlFileCloseOnSuccess", () => {
    it("defaults to true when storage is unpopulated", () => {
      const storage = createMockStorage();
      expect(readSqlFileCloseOnSuccess(storage)).toBe(true);
    });

    it("defaults to true when storage is undefined", () => {
      expect(readSqlFileCloseOnSuccess(undefined)).toBe(true);
    });

    it("returns true when stored value is true", () => {
      const storage = createMockStorage({ [SQL_FILE_CLOSE_ON_SUCCESS_STORAGE_KEY]: "true" });
      expect(readSqlFileCloseOnSuccess(storage)).toBe(true);
    });

    it("returns false when stored value is false", () => {
      const storage = createMockStorage({ [SQL_FILE_CLOSE_ON_SUCCESS_STORAGE_KEY]: "false" });
      expect(readSqlFileCloseOnSuccess(storage)).toBe(false);
    });

    it("falls back to true when storage throws an exception", () => {
      const errorStorage = {
        getItem: () => {
          throw new Error("SecurityError: access denied");
        },
      } as unknown as Storage;
      expect(readSqlFileCloseOnSuccess(errorStorage)).toBe(true);
    });
  });

  describe("writeSqlFileCloseOnSuccess", () => {
    it("persists true to storage", () => {
      const storage = createMockStorage();
      writeSqlFileCloseOnSuccess(true, storage);
      expect(storage.getItem(SQL_FILE_CLOSE_ON_SUCCESS_STORAGE_KEY)).toBe("true");
    });

    it("persists false to storage", () => {
      const storage = createMockStorage();
      writeSqlFileCloseOnSuccess(false, storage);
      expect(storage.getItem(SQL_FILE_CLOSE_ON_SUCCESS_STORAGE_KEY)).toBe("false");
    });

    it("gracefully catches storage exceptions", () => {
      const errorStorage = {
        setItem: () => {
          throw new Error("QuotaExceededError");
        },
      } as unknown as Storage;
      expect(() => writeSqlFileCloseOnSuccess(false, errorStorage)).not.toThrow();
    });
  });
});