fix:edit table bug

shanhexi · shanhexi · commit a4b77bf637a7 · 2023-10-11T18:14:02.000+08:00
diff --git a/chat2db-client/src/blocks/DatabaseTableEditor/index.tsx b/chat2db-client/src/blocks/DatabaseTableEditor/index.tsx
@@ -100,7 +100,7 @@ export default memo((props: IProps) => {
 
   useEffect(() => {
     if (tableName) {
-      getTableDetails({});
+      getTableDetails();
     }
     getDatabaseFieldTypeList();
   }, []);
@@ -155,20 +155,23 @@ export default memo((props: IProps) => {
       });
   };
 
-  const getTableDetails = ({ tableNameProps }: { tableNameProps?: string }) => {
-    if (!tableName) return;
-    const params = {
-      databaseName,
-      dataSourceId,
-      tableName: tableNameProps || tableName,
-      schemaName,
-      refresh: true,
-    };
-    sqlService.getTableDetails(params).then((res) => {
-      const newTableDetails = lodash.cloneDeep(res);
-      setTableDetails(newTableDetails || {});
-      setOldTableDetails(res);
-    });
+  const getTableDetails = (myParams?: { tableNameProps?: string }) => {
+    const { tableNameProps } = myParams || {};
+    const myTableName = tableNameProps || tableName;
+    if (myTableName) {
+      const params = {
+        databaseName,
+        dataSourceId,
+        tableName: myTableName,
+        schemaName,
+        refresh: true,
+      };
+      sqlService.getTableDetails(params).then((res) => {
+        const newTableDetails = lodash.cloneDeep(res);
+        setTableDetails(newTableDetails || {});
+        setOldTableDetails(res);
+      });
+    }
   };
 
   function submit() {
diff --git a/chat2db-client/src/components/ExecuteSQL/index.tsx b/chat2db-client/src/components/ExecuteSQL/index.tsx
@@ -16,7 +16,7 @@ interface IProps {
   databaseType: DatabaseTypeCode;
   databaseName: string;
   dataSourceId: number;
-  schemaName: string | undefined;
+  schemaName?: string | null;
   tableName?: string;
   executeSuccessCallBack: () => void;
   executeSqlApi?: 'executeUpdateDataSql'; // 两个地方用到了这个组件，但是两个需要的执行sql的接口不一样
diff --git a/chat2db-client/src/service/sql.ts b/chat2db-client/src/service/sql.ts
@@ -15,7 +15,7 @@ export interface IExecuteSqlParams {
   consoleId?: number;
   dataSourceId?: number;
   databaseName?: string;
-  schemaName?: string;
+  schemaName?: string | null;
   tableName?: string;
   pageNo?: number;
   pageSize?: number;
@@ -192,7 +192,7 @@ const getDatabaseFieldTypeList = createRequest<{
 const getTableDetails = createRequest<{
   dataSourceId: number;
   databaseName: string;
-  schemaName?: string;
+  schemaName?: string | null;
   tableName: string;
   refresh: boolean;
 }, IEditTableInfo>('/api/rdb/table/query', { method: 'get' });
