Function parseESHitsArray

frontend/src/utils/sqlResult.ts:335–352

(result: QueryResult)

// Parses the hits array from an Elasticsearch _search QueryResult's "hits" column.
const parseESHitsArray = (result: QueryResult): unknown[] | undefined => {
  const hitsColIdx = result.columnNames.indexOf("hits");
  if (hitsColIdx === -1 || result.rows.length === 0) return undefined;

  const hitsCell = result.rows[0]?.values[hitsColIdx];
  if (hitsCell?.kind.case !== "stringValue") return undefined;

  let hitsObj: Record<string, unknown>;
  try {
    hitsObj = JSON.parse(hitsCell.kind.value);
  } catch {
    return undefined;
  }

  const hitsArray = hitsObj?.hits;
  if (!Array.isArray(hitsArray) || hitsArray.length === 0) return undefined;
  return hitsArray;
};

// Discovers columns from ES hits: _id, _score, then sorted _source field keys.
const discoverESColumns = (hitsArray: unknown[]) => {