Function useExecuteSQL

frontend/src/react/hooks/useExecuteSQL.ts:45–423

()

const QUERY_INTERVAL_LIMIT = 1000;

export const useExecuteSQL = () => {
  const { t } = useTranslation();
  const lastQueryTimeRef = useRef<number | undefined>(undefined);
  // Eagerly fetch the subscription so the batch-query / database-group
  // gates below see the licensed plan when the user clicks Run. The hook
  // is mounted by `EditorMain` on every tab open, so this fires once per
  // tab; `loadSubscription` itself dedupes via an in-flight request.
  const loadSubscription = useAppStore((s) => s.loadSubscription);
  useEffect(() => {
    void loadSubscription();
  }, [loadSubscription]);
  const notify = (
    type: BBNotificationStyle,
    title: string,
    description?: string
  ) => {
    useAppStore.getState().notify({
      module: "bytebase",
      style: type,
      title,
      description,
    });
  };

  const preflight = useCallback(
    async (params: SQLEditorQueryParams) => {
      lastQueryTimeRef.current = Date.now();

      const tabsState = getSQLEditorTabsState();
      const tab = tabsState.tabsById.get(tabsState.currentTabId);
      if (!tab) {
        return false;
      }

      // Mirrors `useIsDisconnected` selector logic without a hook
      // (preflight runs inside a callback, not during render).
      if (!isConnectedSQLEditorTab(tab)) {
        notify("CRITICAL", t("sql-editor.select-connection"));
        return false;
      }

      if (isEmpty(params.statement)) {
        notify("CRITICAL", t("sql-editor.notify-empty-statement"));
        return false;
      }

      if (!tab.databaseQueryContexts) {
        tabsState.updateTab(tab.id, { databaseQueryContexts: new Map() });
      }
      return true;
    },
    [t]
  );

  // Propagates the status change to the Zustand store via
  // `updateDatabaseQueryContext` (the path that drives React re-renders).
  // For ad-hoc contexts that aren't tracked under `(database, ctx.id)` —
  // e.g. the ephemeral context in `getExplainTokenForMSSQL` — the store