Function hydrateProjectTabs

frontend/src/react/stores/sqlEditor/tab.ts:412–468

(project: string)

// it with in-flight dedup; uses the store's external setState/getState
// (immer-enabled) rather than the action closure's set/get.
const hydrateProjectTabs = async (project: string): Promise<void> => {
  await migrateDraftsFromCache(project);
  migrateTabViewState(project);

  // Ensure the current user is loaded so tab storage is scoped to the
  // right email — the SQL editor route doesn't otherwise populate it.
  await useAppStore.getState().loadCurrentUser();
  const state = useAppStore.getState();
  const email = state.currentUser?.email ?? "";
  const wsScope = workspaceCacheScope(
    state.isSaaSMode(),
    state.currentUser?.workspace ?? ""
  );

  const storedTabs = readOpenTabs(wsScope, project, email);

  const hydratedTabs: SQLEditorTab[] = [];
  const validPersistent: PersistentTab[] = [];
  const seen = new Set<string>();

  for (const persisted of storedTabs) {
    if (seen.has(persisted.id)) continue;
    if (!persisted.worksheet) continue;

    const worksheet = await useAppStore
      .getState()
      .getOrFetchWorksheetByName(persisted.worksheet, true);
    if (!worksheet) continue;

    const statement = getSheetStatement(worksheet);
    const connection = await extractWorksheetConnection(worksheet);

    const fullTab: SQLEditorTab = {
      ...defaultSQLEditorTab(),
      ...omitBy(persisted, isUndefined),
      connection,
      worksheet: worksheet.name,
      title: worksheet.title,
      statement,
      status: "CLEAN",
      databaseQueryContexts: undefined,
    };

    seen.add(persisted.id);
    validPersistent.push(persisted);
    hydratedTabs.push(fullTab);
  }

  useSQLEditorTabsStore.setState({
    tabsById: new Map(hydratedTabs.map((t) => [t.id, t])),
    openTmpTabList: validPersistent,
    currentTabId: head(validPersistent)?.id ?? "",
  });

  persistOpenTabs(validPersistent);
  persistCurrentTabId(useSQLEditorTabsStore.getState().currentTabId);
};