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。

1.2 KB
Raw Blame
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");
  });
});