fix:bug

shanhexi · shanhexi · commit 55cd9754ad1c · 2023-12-05T15:00:02.000+08:00
diff --git a/chat2db-client/src/blocks/Tree/index.tsx b/chat2db-client/src/blocks/Tree/index.tsx
@@ -90,11 +90,23 @@ const TreeNode = memo((props: TreeNodeIProps) => {
           setTimeout(() => {
             console.log(res);
             if (res.data) {
-              setTreeNodeData({
-                ...treeNodeData,
-                children: res.data,
-                total: res.total,
-              });
+              // res.data每次只插入200条数据，间隔30ms
+              const count = res.data.length / 200;
+              for (let i = 0; i < count; i++) {
+                setTimeout(() => {
+                  setTreeNodeData({
+                    ...treeNodeData,
+                    children: res.data.slice(0, (i + 1) * 50),
+                    total: res.total,
+                  });
+                }, 100 * i);
+              }
+
+              // setTreeNodeData({
+              //   ...treeNodeData,
+              //   children: res.data,
+              //   total: res.total,
+              // });
             } else {
               setTreeNodeData({
                 ...treeNodeData,
diff --git a/chat2db-client/src/blocks/Tree/treeConfig.tsx b/chat2db-client/src/blocks/Tree/treeConfig.tsx
@@ -243,6 +243,8 @@ export const treeConfig: { [key in TreeNodeType]: ITreeConfigItem } = {
     getChildren: (params, options) => {
       const _extraParams = params.extraParams;
       delete params.extraParams;
+      params.pageNo = 1;
+      params.pageSize = 1000;
       return new Promise((r, j) => {
         mysqlServer
           .getTableList(params, options)
diff --git a/chat2db-client/src/components/SearchResult/components/TableBox/index.tsx b/chat2db-client/src/components/SearchResult/components/TableBox/index.tsx
@@ -105,7 +105,7 @@ export default function TableBox(props: ITableProps) {
   const { className, outerQueryResultData, tableBoxId } = props;
   const [viewTableCellData, setViewTableCellData] = useState<IViewTableCellData | null>(null);
   const [, contextHolder] = message.useMessage();
-  const { activeTabIdRef } = useContext(Context);
+  const { activeTabId } = useContext(Context);
   const [paginationConfig, setPaginationConfig] = useState<IResultConfig>(defaultPaginationConfig);
   // sql查询结果
   const [queryResultData, setQueryResultData] = useState<IManageResultData>(outerQueryResultData);
@@ -1098,7 +1098,7 @@ export default function TableBox(props: ITableProps) {
 
   return (
     <div className={classnames(className, styles.tableBox, { [styles.noDataTableBox]: !tableData.length })}>
-      {activeTabIdRef?.current === tableBoxId && renderContent()}
+      {activeTabId === tableBoxId && renderContent()}
       <Modal
         title={viewTableCellData?.name}
         open={!!viewTableCellData?.name}
diff --git a/chat2db-client/src/components/SearchResult/index.tsx b/chat2db-client/src/components/SearchResult/index.tsx
@@ -46,7 +46,7 @@ export interface ISearchResultRef {
 
 interface IContext {
   // 这里不用ref的话，会导致切换时闪动
-  activeTabIdRef: React.MutableRefObject<null | string>;
+  activeTabId: string;
 }
 
 export const Context = createContext<IContext>({} as any);
@@ -56,7 +56,7 @@ export default forwardRef((props: IProps, ref: ForwardedRef<ISearchResultRef>) =
   const [resultDataList, setResultDataList] = useState<IManageResultData[]>();
   const [tableLoading, setTableLoading] = useState(false);
   const controllerRef = useRef<AbortController>();
-  const activeTabIdRef = useRef<null | string>(null);
+  const [activeTabId, setActiveTabId] = useState<string>('');
 
   useEffect(() => {
     if (sql) {
@@ -102,7 +102,8 @@ export default forwardRef((props: IProps, ref: ForwardedRef<ISearchResultRef>) =
   };
 
   const onChange = useCallback((uuid) => {
-    activeTabIdRef.current = uuid;
+    // activeTabIdRef.current = uuid;
+    setActiveTabId(uuid);
   }, []);
 
   const renderResult = (queryResultData) => {
@@ -189,7 +190,7 @@ export default forwardRef((props: IProps, ref: ForwardedRef<ISearchResultRef>) =
   return (
     <Context.Provider
       value={{
-        activeTabIdRef: activeTabIdRef,
+        activeTabId: activeTabId,
       }}
     >
       <div className={classnames(className, styles.searchResult)}>
