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
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();
});
});
});