Function buildTree

frontend/src/views/sql-editor/Sheet/context.ts:572–618

(
  view: SheetViewMode,
  parent: WorksheetFolderNode,
  worksheetsByFolder: Map<string, WorksheetLikeItem[]>,
  hideEmpty: boolean
)

};

const buildTree = (
  view: SheetViewMode,
  parent: WorksheetFolderNode,
  worksheetsByFolder: Map<string, WorksheetLikeItem[]>,
  hideEmpty: boolean
): WorksheetFolderNode => {
  const folderContext = getFolderContext(view);
  const subfolders: WorksheetFolderNode[] = folderContext
    .listSubFolders(parent.key)
    .map((folder) => ({
      isLeaf: false,
      children: [],
      key: folder,
      label: folder.split("/").slice(-1)[0],
      editable: true,
    }));

  let empty = true;
  for (const childNode of subfolders) {
    const subtree = buildTree(view, childNode, worksheetsByFolder, hideEmpty);
    if (!subtree.empty || !hideEmpty) {
      parent.children.push(subtree);
    }
    if (!subtree.empty) {
      empty = false;
    }
  }

  const sheets = orderBy(
    worksheetsByFolder.get(parent.key) ?? [],
    (item) => item.title
  ).map<WorksheetFolderNode>((worksheet) => ({
    isLeaf: true,
    key: getKeyForWorksheet(view, worksheet),
    label: worksheet.title,
    worksheet,
    editable: true,
    children: [],
  }));

  parent.children.push(...sheets);
  parent.empty = sheets.length === 0 && empty;
  if (parent.key !== folderContext.rootPath) {
    parent.isLeaf = parent.children.length === 0;
  }
  return parent;
};

const worksheetsForView = (view: SheetViewMode): Worksheet[] => {
  if (view !== "my" && view !== "shared") return [];