fix:表备注不显示

shanhexi · shanhexi · commit 256861e7dc80 · 2023-08-07T23:27:41.000+08:00
diff --git a/chat2db-client/src/pages/main/workspace/components/Tree/index.tsx b/chat2db-client/src/pages/main/workspace/components/Tree/index.tsx
@@ -35,7 +35,6 @@ function Tree(props: IProps) {
   const [treeData, setTreeData] = useState<ITreeNode[] | undefined>();
   const [searchedTreeData, setSearchedTreeData] = useState<ITreeNode[] | null>(null);
 
-
   useEffect(() => {
     setTreeData(initialData);
   }, [initialData])
diff --git a/chat2db-client/src/pages/main/workspace/components/Tree/treeConfig.tsx b/chat2db-client/src/pages/main/workspace/components/Tree/treeConfig.tsx
@@ -178,6 +178,7 @@ export const treeConfig: { [key in TreeNodeType]: ITreeConfigItem } = {
               treeNodeType: TreeNodeType.TABLE,
               key: t.name,
               pinned: t.pinned,
+              comment: t.comment,
               extraParams: {
                 ...params.extraParams,
                 tableName: t.name
@@ -239,6 +240,7 @@ export const treeConfig: { [key in TreeNodeType]: ITreeConfigItem } = {
               key: item.name,
               isLeaf: true,
               columnType: item.columnType,
+              comment: item.comment,
             }
           })
           r(tableList);
diff --git a/chat2db-client/src/service/sql.ts b/chat2db-client/src/service/sql.ts
@@ -64,6 +64,7 @@ export interface IColumn {
   numericPrecision: number;
   numericScale: number;
   characterMaximumLength: number;
+  comment: string;
 }
 
 export interface ISchemaParams {
diff --git a/chat2db-client/src/typings/tree.ts b/chat2db-client/src/typings/tree.ts
@@ -18,5 +18,5 @@ export interface ITreeNode {
   columnType?: string; // 列的类型
   extraParams?: IExtraParams;
   pinned?: boolean; // 是否置顶
-  comment: string; // 表列的注释
+  comment?: string; // 表列的注释
 }

Original file line number	Diff line number	Diff line change
`@@ -64,6 +64,7 @@ export interface IColumn {`
`64`	`64`	`numericPrecision: number;`
`65`	`65`	`numericScale: number;`
`66`	`66`	`characterMaximumLength: number;`
	`67`	`+ comment: string;`
`67`	`68`	`}`
`68`	`69`
`69`	`70`	`export interface ISchemaParams {`
Original file line number	Diff line number	Diff line change
`@@ -18,5 +18,5 @@ export interface ITreeNode {`
`18`	`18`	`columnType?: string; // 列的类型`
`19`	`19`	`extraParams?: IExtraParams;`
`20`	`20`	`pinned?: boolean; // 是否置顶`
`21`		`- comment: string; // 表列的注释`
	`21`	`+ comment?: string; // 表列的注释`
`22`	`22`	`}`