Function flattenNoSQLColumn

frontend/src/utils/sqlResult.ts:50–116

(value: unknown)

};

const flattenNoSQLColumn = (value: unknown): unknown => {
  if (typeof value !== "object") {
    return value;
  }
  if (value === null) {
    return value;
  }
  if (Array.isArray(value)) {
    return value.map(flattenNoSQLColumn);
  }

  const dict = value as { [key: string]: unknown };
  if (Object.keys(dict).length === 1 && Object.keys(dict)[0].startsWith("$")) {
    // Used by the MongoDB response.
    // https://www.mongodb.com/zh-cn/docs/manual/reference/mongodb-extended-json/#bson-data-types-and-associated-representations
    const key = Object.keys(dict)[0];
    switch (key) {
      case "$oid":
        return dict[key];
      case "$date":
        if (typeof dict[key] !== "object" || dict[key] === null) {
          return dict[key];
        }
        const dateObj = dict[key] as Record<string, unknown>;
        if (!dateObj["$numberLong"]) {
          return dict[key];
        }
        return new Date(parseInt(dateObj["$numberLong"] as string));
      case "$numberLong":
        // Return as string to preserve precision for large integers (> 2^53-1)
        return dict[key] as string;
      case "$numberDouble":
        return parseFloat(dict[key] as string);
      case "$numberInt":
        return parseInt(dict[key] as string);
      case "$numberDecimal":
        return Number(dict[key]);
      case "$timestamp":
        return (dict[key] as { t: number; i: number }).t;
      case "$binary": {
        // https://www.mongodb.com/zh-cn/docs/manual/reference/bson-types/#binary-data
        const { base64, subType } = dict[key] as {
          base64: string;
          subType: string;
        };
        switch (subType) {
          case "03":
          case "04":
            try {
              return decodeBase64ToUUID(base64);
            } catch {
              return dict[key];
            }
          default:
            return dict[key];
        }
      }
      default: