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 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);
});
});