Function useLazyFileLoader

frontend/src/hooks/useLazyFileLoader.ts:9–144

()

import { DataLoadWithDuckDBResult } from '@/components/layout/Sidebar';

export function useLazyFileLoader() {
  const [loadingFileId, setLoadingFileId] = useState<string | null>(null);
  const [error, setError] = useState<string | null>(null);
  
  const { getNodeById, updateFileData, markFileAsLoaded } = useFolderStore();
  const { processFileStreaming, processFile } = useDirectFileImport();
  const { addFile: addToAppStore, setActiveFile } = useAppStore();

  const loadFile = useCallback(async (
    node: FolderNode,
    onDataLoad?: (result: DataLoadWithDuckDBResult) => void
  ) => {
    if (node.type !== 'file' || !node.fileData) {
      setError('Invalid file node');
      return false;
    }

    // If file is already loaded, just switch to it
    if (node.fileData.isLoaded && node.fileData.tableName) {
      console.log(`[LazyLoader] File already loaded: ${node.name} (${node.fileData.tableName})`);
      
      // Find the file in app store and set it active
      const appFiles = useAppStore.getState().files;
      const existingFile = appFiles.find(f => f.fileName === node.name);
      if (existingFile) {
        setActiveFile(existingFile.id);
        return true;
      }
    }

    setLoadingFileId(node.id);
    setError(null);

    try {
      console.log(`[LazyLoader] Loading file: ${node.name}`);
      
      let result: DataLoadWithDuckDBResult | undefined;

      // Check if we have a file handle for streaming
      if (node.fileData.handle) {
        // Try to get the file from handle
        try {
          const file = await node.fileData.handle.getFile();
          
          // Check if file still exists and matches
          if (file.name === node.name) {
            console.log(`[LazyLoader] Using file handle for streaming import`);
            result = await processFileStreaming(node.fileData.handle, file, onDataLoad);
          } else {
            throw new Error('File name mismatch');
          }
        } catch (handleError) {
          console.warn(`[LazyLoader] File handle failed, prompting user:`, handleError);
          
          // Prompt user to re-select the file
          if ('showOpenFilePicker' in window) {
            const fileHandleArray = await window.showOpenFilePicker({
              types: [