PowerDesigner导入mysql文件注释丢失问题解决

布满荆棘的人生 2023-02-12 06:29 2阅读 0赞

问题，将数据库中的表导入PowerDesigner后，发现没有注释

不要心慌，注释其实存在

操作步骤

![è¿éåå¾çæè¿°][SouthEast]

![è¿éåå¾çæè¿°][SouthEast 1]

### 放入相关代码 ###

Option   Explicit 
    ValidationMode   =   True 
    InteractiveMode   =   im_Batch
     
    Dim   mdl   '   the   current   model
     
    '   get   the   current   active   model 
    Set   mdl   =   ActiveModel 
    If   (mdl   Is   Nothing)   Then 
      MsgBox   "There   is   no   current   Model " 
    ElseIf   Not   mdl.IsKindOf(PdPDM.cls_Model)   Then 
      MsgBox   "The   current   model   is   not   an   Physical   Data   model. " 
    Else 
      ProcessFolder   mdl 
    End   If
     
    Private   sub   ProcessFolder(folder) 
    On Error Resume Next
      Dim   Tab   'running table 
      for   each   Tab   in   folder.tables 
    if   not   tab.isShortcut   then 
      tab.name   =   tab.comment
      Dim   col   '   running   column 
      for   each   col   in   tab.columns 
      if col.comment="" then
      else
    col.name=   col.comment 
      end if
      next 
    end   if 
      next
     
      Dim   view   'running   view 
      for   each   view   in   folder.Views 
    if   not   view.isShortcut   then 
      view.name   =   view.comment 
    end   if 
      next
     
      '   go   into   the   sub-packages 
      Dim   f   '   running   folder 
      For   Each   f   In   folder.Packages 
    if   not   f.IsShortcut   then 
      ProcessFolder   f 
    end   if 
      Next 
    end   sub

博主强烈推荐：https://blog.csdn.net/persistencegoing/article/details/84376427

希望大家关注我一波,防止以后迷路,有需要的可以加群讨论互相学习java ,学习路线探讨,经验分享与java求职

群号:721 515 304

[SouthEast]: https://img-blog.csdn.net/20171205171329199?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQva3VuX3phaQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast
[SouthEast 1]: https://img-blog.csdn.net/20171205171341120?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQva3VuX3phaQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast