Function reloadFromStorage

frontend/src/views/sql-editor/Sheet/context.ts:294–356

()

  "showDraft" in v;

const reloadFromStorage = () => {
  const scope = currentScope();
  if (!scope) return;

  const filter = safeReadJSON(
    storageKeySqlEditorWorksheetFilter(
      scope.wsScope,
      scope.project,
      scope.email
    ),
    (v) => (isWorksheetFilter(v) ? v : undefined)
  ) ?? { ...INITIAL_FILTER };

  const expandedArray = safeReadJSON<string[]>(
    storageKeySqlEditorWorksheetTree(scope.wsScope, scope.project, scope.email),
    (v) =>
      Array.isArray(v) && v.every((entry) => typeof entry === "string")
        ? (v as string[])
        : undefined
  );
  const expandedKeys = expandedArray
    ? new Set(expandedArray)
    : new Set<string>([
        rootPathFor("my"),
        rootPathFor("shared"),
        rootPathFor("draft"),
      ]);
  expandedKeys.add(rootPathFor("my"));
  expandedKeys.add(rootPathFor("shared"));
  expandedKeys.add(rootPathFor("draft"));

  const viewStates: Record<SheetViewMode, ViewState> = {
    my: emptyViewState("my"),
    shared: emptyViewState("shared"),
    draft: emptyViewState("draft"),
  };

  for (const view of ["my", "shared", "draft"] as const) {
    const folders = safeReadJSON<string[]>(
      storageKeySqlEditorWorksheetFolder(
        scope.wsScope,
        scope.project,
        view,
        scope.email
      ),
      (v) =>
        Array.isArray(v) && v.every((entry) => typeof entry === "string")
          ? (v as string[])
          : undefined
    );
    const set = new Set(folders ?? []);
    set.add(rootPathFor(view));
    viewStates[view].folders = sortBy([...set]);
  }

  useSheetContextStore.getState().hydrate({
    filter,
    expandedKeys,