Hide edit tables for unsupported databases

shanhexi · shanhexi · commit 1d37d3b3e877 · 2023-10-14T11:18:21.000+08:00
diff --git a/chat2db-client/src/blocks/DatabaseTableEditor/ColumnList/index.tsx b/chat2db-client/src/blocks/DatabaseTableEditor/ColumnList/index.tsx
@@ -409,22 +409,6 @@ const ColumnList = forwardRef((props: IProps, ref: ForwardedRef<IColumnListRef>)
             />
           </Form.Item>
         )}
-        {editingConfig?.supportDefaultValue && (
-          <Form.Item labelCol={labelCol} label={i18n('editTable.label.defaultValue')} name="defaultValue">
-            <CustomSelect
-              options={[
-                {
-                  label: 'EMPTY_STRING',
-                  value: 'EMPTY_STRING',
-                },
-                {
-                  label: 'NULL',
-                  value: 'NULL',
-                },
-              ]}
-            />
-          </Form.Item>
-        )}
         {editingConfig?.supportCharset && (
           <Form.Item labelCol={labelCol} label={i18n('editTable.label.characterSet')} name="charSetName">
             <CustomSelect options={databaseSupportField.charsets} />
diff --git a/chat2db-client/src/components/ConnectionEdit/config/dataSource.ts b/chat2db-client/src/components/ConnectionEdit/config/dataSource.ts
@@ -360,7 +360,6 @@ export const dataSourceFormConfigs: IConnectionConfig[] = [
       ],
       pattern: /jdbc:postgresql:\/\/(.*):(\d+)(\/(\w+))?/,
       template: 'jdbc:postgresql://{host}:{port}/{database}',
-      excludes: [OperationColumn.EditTable]
     },
     ssh: sshConfig,
   },
@@ -612,7 +611,6 @@ export const dataSourceFormConfigs: IConnectionConfig[] = [
       ],
       pattern: /jdbc:h2:tcp:\/\/(.*):(\d+)(\/(\w+))?/,
       template: 'jdbc:h2:tcp://{host}:{port}/{database}',
-      excludes: [OperationColumn.EditTable]
     },
     ssh: sshConfig,
   },
@@ -1015,7 +1013,7 @@ export const dataSourceFormConfigs: IConnectionConfig[] = [
       ],
       pattern: /jdbc:clickhouse:\/\/(.*):(\d+)(\/(\w+))?/,
       template: 'jdbc:clickhouse://{host}:{port}/{database}',
-      excludes: [OperationColumn.ExportDDL, OperationColumn.CreateTable]
+      excludes: [OperationColumn.ExportDDL, OperationColumn.CreateTable,OperationColumn.EditTable]
       //排除掉导出ddl 和 创建表功能 支持的功能见 ./enum.ts => OperationColumn
     },
     ssh: sshConfig,
@@ -1124,6 +1122,8 @@ export const dataSourceFormConfigs: IConnectionConfig[] = [
       ],
       pattern: /jdbc:dm:\/\/(.*):(\d+)(\/(\w+))?/,
       template: 'jdbc:dm://{host}:{port}/{database}',
+      excludes: [OperationColumn.EditTable]
+
     },
     ssh: sshConfig,
     extendInfo: [
@@ -1249,6 +1249,8 @@ export const dataSourceFormConfigs: IConnectionConfig[] = [
       ],
       pattern: /jdbc:db2:\/\/(.*):(\d+)(\/(\w+))?/,
       template: 'jdbc:db2://{host}:{port}/{database}',
+      excludes: [OperationColumn.EditTable]
+
     },
     ssh: sshConfig,
     extendInfo: [
@@ -1371,6 +1373,8 @@ export const dataSourceFormConfigs: IConnectionConfig[] = [
       ],
       pattern: /jdbc:presto:\/\/(.*):(\d+)(\/(\w+))?/,
       template: 'jdbc:presto://{host}:{port}/{database}',
+      excludes: [OperationColumn.EditTable]
+
     },
     ssh: sshConfig,
     extendInfo: [
@@ -1493,6 +1497,8 @@ export const dataSourceFormConfigs: IConnectionConfig[] = [
       ],
       pattern: /jdbc:oceanbase:\/\/(.*):(\d+)(\/(\w+))?/,
       template: 'jdbc:oceanbase://{host}:{port}/{database}',
+      excludes: [OperationColumn.EditTable]
+
     },
     ssh: sshConfig,
     extendInfo: [
@@ -1737,6 +1743,8 @@ export const dataSourceFormConfigs: IConnectionConfig[] = [
       ],
       pattern: /jdbc:hive2:\/\/(.*):(\d+)(\/(\w+))?/,
       template: 'jdbc:hive2://{host}:{port}/{database}',
+      excludes: [OperationColumn.EditTable]
+
     },
     ssh: sshConfig,
     extendInfo: [
@@ -1859,6 +1867,8 @@ export const dataSourceFormConfigs: IConnectionConfig[] = [
       ],
       pattern: /jdbc:kingbase8:\/\/(.*):(\d+)(\/(\w+))?/,
       template: 'jdbc:kingbase8://{host}:{port}/{database}',
+      excludes: [OperationColumn.EditTable]
+
     },
     ssh: sshConfig,
     extendInfo: [
diff --git a/chat2db-client/src/pages/main/workspace/components/TableList/index.tsx b/chat2db-client/src/pages/main/workspace/components/TableList/index.tsx
@@ -9,7 +9,7 @@ import { IConnectionModelType } from '@/models/connection';
 import { IWorkspaceModelType } from '@/models/workspace';
 import Tree from '../Tree';
 import { treeConfig } from '../Tree/treeConfig';
-import { TreeNodeType, WorkspaceTabType, ConsoleStatus, ConsoleOpenedStatus } from '@/constants';
+import { TreeNodeType, WorkspaceTabType, ConsoleStatus, ConsoleOpenedStatus, OperationColumn } from '@/constants';
 import { approximateTreeNode } from '@/utils';
 import { useUpdateEffect } from '@/hooks/useUpdateEffect';
 import { v4 as uuidV4 } from 'uuid';
@@ -18,6 +18,7 @@ import styles from './index.less';
 import { ExportTypeEnum } from '@/typings/resultTable';
 import historyService from '@/service/history';
 import { debounce } from 'lodash';
+import { dataSourceFormConfigs } from '@/components/ConnectionEdit/config/dataSource';
 
 interface IOption {
   value: TreeNodeType;
@@ -72,8 +73,8 @@ const TableList = dvaModel((props: any) => {
     props.onExport && props.onExport(exportType);
   };
 
-  const items: MenuProps['items'] = useMemo(
-    () => [
+  const items: MenuProps['items'] = useMemo(() => {
+    const list = [
       {
         label: (
           <div className={styles.operationItem}>
@@ -177,9 +178,14 @@ const TableList = dvaModel((props: any) => {
           },
         ],
       },
-    ],
-    [curWorkspaceParams],
-  );
+    ];
+    const dataSourceFormConfig = dataSourceFormConfigs.find((item) => item.type === curWorkspaceParams.databaseType);
+
+    if (dataSourceFormConfig?.baseInfo.excludes?.includes(OperationColumn.EditTable)) {
+      list.splice(1, 1);
+    }
+    return list;
+  }, [curWorkspaceParams]);
 
   useUpdateEffect(() => {
     setCurList([]);
