fix stale transaction error

Matt Rothenberg · Matt Rothenberg · commit e0b17f44f808 · 2022-05-12T14:31:26.000-04:00
diff --git a/src/components/db-explorer.tsx b/src/components/db-explorer.tsx
@@ -28,7 +28,7 @@ const VALID_EXTENSIONS = ["csv", "json"];
 
 function DBExplorerInner(props: DBExplorerInnerProps) {
   const { content, extension, filename, sha } = props;
-  const connectionRef = useRef<duckdb.AsyncDuckDBConnection>();
+  const connectionRef = useRef<duckdb.AsyncDuckDBConnection | null>(null);
   const [query, setQuery] = useState("");
   const [debouncedQuery] = useDebounce(query, 500);
   const [dbStatus, setDbStatus] = useState<"error" | "idle" | "success">(
@@ -98,9 +98,11 @@ function DBExplorerInner(props: DBExplorerInnerProps) {
     return () => {
       if (connectionRef.current) {
         connectionRef.current.close();
+        connectionRef.current = null;
+        setDbStatus("idle");
       }
     };
-  }, [content]);
+  }, [content, sha, filename]);
 
   const sqlSchema = useMemo(() => {
     if (!content) return [];
