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 { extractSqlParameters, substituteSqlParameters } from "@/lib/sql/sqlParameters";
import { expandSqlVariables } from "@/lib/sql/sqlVariables";

describe.each(["oracle", "oceanbase-oracle"] as const)("%s remote object parameters", (databaseType) => {
  it.each([
    "BEGIN MERGE INTO local_t t USING app.remote_t@LINK s ON (t.id=s.id) WHEN MATCHED THEN UPDATE SET t.v=@value; END;",
    "SELECT seq.NEXTVAL@LINK, @value FROM dual",
    "SELECT app.seq.CURRVAL@LINK, @value FROM dual",
    "CREATE SYNONYM local_t FOR app.remote_t@LINK; SELECT @value FROM dual",
    "MERGE INTO local_t t USING app.remote_t@LINK s ON (t.id=s.id) WHEN MATCHED THEN UPDATE SET t.v=@value",
  ])("preserves database links in %s", (sql) => {
    const options = { databaseType };
    expect(extractSqlParameters(sql, options)).toEqual(["value"]);
    expect(substituteSqlParameters(sql, { value: { kind: "number", value: "7" }, LINK: { kind: "string", value: "wrong" } }, options)).toContain("@LINK");
    const expanded = expandSqlVariables(`@set LINK = wrong;\n@set value = 7;\n${sql}`, options);
    expect(expanded.sql).toBe(sql.replace("@value", "7"));
  });
});