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.8 KB
Raw Blame
import { describe, expect, it } from "vitest";
import { aiTableMentionFromTableReference } from "@/lib/ai/aiTableReferenceDrop";
import { createTableReferencePayload } from "@/lib/editor/queryEditorTableDrop";

describe("ai table reference drop", () => {
  it("maps a table payload to a table mention", () => {
    const payload = createTableReferencePayload({
      connectionId: "conn-1",
      database: "app-db",
      schema: "public",
      tableName: "users",
      databaseType: "postgres",
    });

    expect(aiTableMentionFromTableReference(payload)).toEqual({
      raw: "@public.users",
      schema: "public",
      table: "users",
    });
  });

  it("quotes mention parts that are not simple identifiers", () => {
    const payload = createTableReferencePayload({
      connectionId: "conn-1",
      database: "app-db",
      tableName: "order items",
      databaseType: "mysql",
    });

    expect(aiTableMentionFromTableReference(payload)).toEqual({
      raw: '@"order items"',
      schema: undefined,
      table: "order items",
    });
  });

  it("ignores database references", () => {
    const payload = createTableReferencePayload({
      connectionId: "conn-1",
      database: "app-db",
      referenceType: "database",
      databaseType: "mysql",
    });

    expect(aiTableMentionFromTableReference(payload)).toBeNull();
  });

  it("ignores column references", () => {
    const payload = createTableReferencePayload({
      connectionId: "conn-1",
      database: "app-db",
      schema: "public",
      tableName: "users",
      columnName: "email",
      databaseType: "postgres",
    });

    expect(aiTableMentionFromTableReference(payload)).toBeNull();
  });

  it("ignores empty payloads", () => {
    expect(aiTableMentionFromTableReference(null)).toBeNull();
    expect(aiTableMentionFromTableReference(undefined)).toBeNull();
  });
});