Function openWorksheetByName

frontend/src/views/sql-editor/Sheet/context.ts:1110–1162

({
  worksheet,
  forceNewTab,
  mode,
}: {
  worksheet: string;
  forceNewTab: boolean;
  mode?: SQLEditorTabMode;
})

// ---- openWorksheetByName (unchanged behavior) ------------------------------

export const openWorksheetByName = async ({
  worksheet,
  forceNewTab,
  mode,
}: {
  worksheet: string;
  forceNewTab: boolean;
  mode?: SQLEditorTabMode;
}) => {
  const sheet = await useAppStore
    .getState()
    .getOrFetchWorksheetByName(worksheet);
  if (!sheet) return undefined;

  if (!isWorksheetReadableV1(sheet)) {
    useAppStore.getState().notify({
      module: "bytebase",
      style: "CRITICAL",
      title: i18n.t("common.access-denied"),
    });
    return undefined;
  }

  const tabsState = getSQLEditorTabsState();
  const openingSheetTab = (() => {
    for (const persisted of tabsState.openTmpTabList) {
      const tab = tabsState.tabsById.get(persisted.id);
      if (tab?.worksheet === sheet.name) return tab;
    }
    return undefined;
  })();

  if (openingSheetTab && !forceNewTab) {
    tabsState.setCurrentTabId(openingSheetTab.id);
    if (mode && mode !== openingSheetTab.mode) {
      tabsState.updateTab(openingSheetTab.id, { mode });
    }
    return openingSheetTab;
  }

  const statement = getSheetStatement(sheet);
  const connection = await extractWorksheetConnection(sheet);
  const newTab: Partial<SQLEditorTab> = {
    connection,
    worksheet: sheet.name,
    title: sheet.title,
    statement,
    status: "CLEAN",
    mode: mode ?? "WORKSHEET",
  };

  return tabsState.addTab(newTab, forceNewTab /* beside */);
};

// Touch the editor store import so it's eagerly evaluated alongside the
// tab store (matches the historical Pinia-era load order).