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。

2.2 KB
Raw Blame
export interface DocumentQueryTotals {
  total: number;
  totalIsExact: boolean;
  paginationTotal: number | undefined;
}

export interface DocumentQueryTotalsPageOptions {
  page?: number;
  pageSize?: number;
  rowCount?: number;
}

export interface DocumentQueryTotalCountRequest {
  connectionId: string;
  database: string;
  collection: string;
  filter: string | undefined;
  generation: number;
}

export function isSameDocumentQueryTotalCountRequest(left: DocumentQueryTotalCountRequest, right: DocumentQueryTotalCountRequest): boolean {
  return left.connectionId === right.connectionId && left.database === right.database && left.collection === right.collection && left.filter === right.filter && left.generation === right.generation;
}

/** When the current page is short, the true total is exactly offset + rowCount. */
export function exactTotalFromIncompleteDocumentPage(options: DocumentQueryTotalsPageOptions): number | undefined {
  const page = options.page ?? 0;
  const pageSize = options.pageSize;
  const rowCount = options.rowCount;
  if (!Number.isInteger(page) || page < 0 || typeof pageSize !== "number" || !Number.isInteger(pageSize) || pageSize <= 0 || typeof rowCount !== "number" || !Number.isInteger(rowCount) || rowCount < 0 || rowCount >= pageSize || (page > 0 && rowCount === 0)) {
    return undefined;
  }
  return page * pageSize + rowCount;
}

export function resolveDocumentQueryTotals(total: number, totalIsExact: boolean, pageOptions?: DocumentQueryTotalsPageOptions): DocumentQueryTotals {
  if (!totalIsExact) {
    const exactFromPage = exactTotalFromIncompleteDocumentPage(pageOptions ?? {});
    if (typeof exactFromPage === "number") {
      return {
        total: exactFromPage,
        totalIsExact: true,
        paginationTotal: exactFromPage,
      };
    }
  }
  return {
    total,
    totalIsExact,
    paginationTotal: totalIsExact ? total : undefined,
  };
}

export function canGoNextDocumentPage(options: { page: number; pageSize: number; rowCount: number; paginationTotal?: number }): boolean {
  if (typeof options.paginationTotal === "number") {
    return (options.page + 1) * options.pageSize < options.paginationTotal;
  }
  return options.rowCount >= options.pageSize;
}