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.7 KB
Raw Blame
import { describe, expect, it } from "vitest";
import type { QueryResult, QueryTab } from "@/types/database";
import { hasQueryOutput } from "../queryOutput";

const emptyResult: QueryResult = { columns: ["id"], rows: [], affected_rows: 0, execution_time_ms: 1 };

describe("hasQueryOutput", () => {
  it("does not reserve output space for an idle query", () => {
    expect(hasQueryOutput(undefined)).toBe(false);
    expect(hasQueryOutput({ isExecuting: false, results: [], resultRuns: [] })).toBe(false);
  });

  it.each<[string, Partial<QueryTab>]>([
    ["running query", { isExecuting: true }],
    ["running EXPLAIN", { isExplaining: true }],
    ["zero-row SELECT", { result: emptyResult }],
    ["DML summary", { result: { ...emptyResult, columns: [], affected_rows: 3 } }],
    ["DDL summary", { result: { ...emptyResult, columns: [] } }],
    ["query error", { result: { ...emptyResult, columns: ["Error"], rows: [["syntax error"]] } }],
    ["multiple results", { results: [emptyResult] }],
    ["retained result run", { resultRuns: [{ id: "run-1", title: "Result 1", sequence: 1, sql: "SELECT 1", createdAt: 1 }] }],
    ["EXPLAIN plan", { explainPlan: { databaseType: "mysql", raw: {}, nodes: [] } }],
    ["EXPLAIN table", { explainTableResult: emptyResult }],
    ["EXPLAIN error", { explainError: "syntax error" }],
    ["EXPLAIN table error", { explainTableError: "unsupported" }],
    ["cached result", { resultEvicted: true, resultCacheState: "disk" }],
    ["missing cached result", { resultEvicted: true, resultCacheState: "missing" }],
  ])("retains output space for %s", (_, state) => {
    expect(hasQueryOutput({ isExecuting: false, ...state })).toBe(true);
  });
});