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。

5.0 KB
Raw Blame
import { describe, it, expect } from "vitest";
import { appendQueryResultSegment } from "@/stores/queryStore";
import type { QueryResult } from "@/types/database";

function make(rows: number, spatial?: QueryResult["spatial_columns"]): QueryResult {
  return {
    columns: ["geom"],
    column_types: ["geometry"],
    spatial_columns: spatial,
    rows: Array.from({ length: rows }, (_, i) => [`POINT(${i} ${i})`]),
    affected_rows: 0,
    execution_time_ms: 0,
  } as unknown as QueryResult;
}

describe("appendQueryResultSegment spatial merge", () => {
  it("rebases original key and pending preview metadata and excludes capped rows", () => {
    const previous = { ...make(1), raw_key_cells: [{ row_index: 0, column_index: 0, value: "raw A" }] };
    const segment = {
      ...make(2),
      raw_key_cells: [
        { row_index: 0, column_index: 0, value: "raw B" },
        { row_index: 1, column_index: 0, value: "discard" },
      ],
      large_value_cells: [{ row_index: 0, column_index: 0, original_bytes: 20000, pending_decode: true }],
    };
    const merged = appendQueryResultSegment(previous, segment, 2);
    expect(merged.raw_key_cells).toEqual([
      { row_index: 0, column_index: 0, value: "raw A" },
      { row_index: 1, column_index: 0, value: "raw B" },
    ]);
    expect(merged.large_value_cells).toEqual([{ row_index: 1, column_index: 0, original_bytes: 20000, pending_decode: true }]);
  });
  it("sums client request wait across loaded pages", () => {
    const previous = { ...make(1), client_request_wait_ms: 45 };
    const segment = { ...make(1), client_request_wait_ms: 30 };
    const merged = appendQueryResultSegment(previous, segment, 100);
    expect(merged.client_request_wait_ms).toBe(75);
    expect(merged.rows).toHaveLength(2);
  });
  it("does not report a partial wait when either loaded page lacks a sample", () => {
    const sampled = { ...make(1), client_request_wait_ms: 40 };
    expect(appendQueryResultSegment(make(1), sampled, 100).client_request_wait_ms).toBeUndefined();
    expect(appendQueryResultSegment(sampled, make(1), 100).client_request_wait_ms).toBeUndefined();
  });
  it("keeps the first non-null SRID per column across pages", () => {
    const previous = make(2, [{ column_index: 0, srid: 4326 }]);
    const segment = make(2, [{ column_index: 0, srid: 3857 }]);
    const merged = appendQueryResultSegment(previous, segment, 100);
    expect(merged.spatial_columns).toEqual([{ column_index: 0, srid: 4326 }]);
    expect(merged.rows).toHaveLength(4);
  });

  it("adopts the segment SRID when the previous page was unknown", () => {
    const previous = make(1, [{ column_index: 0, srid: null }]);
    const segment = make(1, [{ column_index: 0, srid: 4490 }]);
    const merged = appendQueryResultSegment(previous, segment, 100);
    expect(merged.spatial_columns).toEqual([{ column_index: 0, srid: 4490 }]);
  });

  it("concatenates per-cell SRIDs across pages without collapsing", () => {
    const previous = make(2, [{ column_index: 0, srid: 4326 }]);
    previous.spatial_values = [[4326], [3857]];
    const segment = make(2, [{ column_index: 0, srid: null }]);
    segment.spatial_values = [[3857], [4490]];

    const merged = appendQueryResultSegment(previous, segment, 100);
    // Every row keeps its own SRID; a later page does not overwrite earlier cells.
    expect(merged.spatial_values).toEqual([[4326], [3857], [3857], [4490]]);
  });

  it("raises the structured segment error instead of reconstructing from the Error row", () => {
    const previous = make(1);
    const segment = {
      ...make(0),
      execution_error: true as const,
      rows: [["legacy row text"]],
      error: {
        version: 1 as const,
        code: "DBX-JDBC-4001",
        messageKey: "backendErrors.jdbc.sqlFailed",
        messageParams: { stage: "execute" },
        source: "jdbcAgent" as const,
        operationOutcome: "unknown" as const,
        detail: "relation missing_table does not exist",
      },
    } as unknown as QueryResult;

    expect(() => appendQueryResultSegment(previous, segment, 100)).toThrow("relation missing_table does not exist");
  });
});

describe("appendQueryResultSegment OceanBase audit timing", () => {
  it("uses the terminal audit for the whole JDBC cursor without summing page samples", () => {
    const first = { ...make(100), session_id: "cursor-1", has_more: true };
    const last = { ...make(50), server_execute_time_us: 370, has_more: false };
    expect(appendQueryResultSegment(first, last, 1000).server_execute_time_us).toBe(370);
  });

  it("sums independent SQL pages only when each page has an audit sample", () => {
    const first = { ...make(100), server_execute_time_us: 200 };
    const sampledNext = { ...make(100), server_execute_time_us: 150 };
    expect(appendQueryResultSegment(first, sampledNext, 1000).server_execute_time_us).toBe(350);
    expect(appendQueryResultSegment(make(100), sampledNext, 1000).server_execute_time_us).toBeUndefined();
    expect(appendQueryResultSegment(first, make(100), 1000).server_execute_time_us).toBeUndefined();
  });
});