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 { formatSqlSnapshotForSave } from "@/lib/sql/sqlFormatOnSave";
function deferred<T>() {
let resolve!: (value: T) => void;
const promise = new Promise<T>((resolvePromise) => {
resolve = resolvePromise;
});
return { promise, resolve };
}
describe("formatSqlSnapshotForSave", () => {
it("does not overwrite edits made while formatting loads", async () => {
const formatting = deferred<string>();
let sql = "select 1";
const pending = formatSqlSnapshotForSave(
sql,
() => sql,
() => formatting.promise,
(formatted) => {
sql = formatted;
},
);
sql = "select 2";
formatting.resolve("SELECT 1");
await expect(pending).resolves.toBe("select 2");
expect(sql).toBe("select 2");
});
it("applies and returns formatted SQL when the snapshot is unchanged", async () => {
let sql = "select 1";
await expect(
formatSqlSnapshotForSave(
sql,
() => sql,
async () => "SELECT 1",
(formatted) => {
sql = formatted;
},
),
).resolves.toBe("SELECT 1");
expect(sql).toBe("SELECT 1");
});
});