美文网首页
PowerDesigner导入mysql文件注释丢失问题解决

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

作者: 莫非的老公 | 来源:发表于2019-07-26 10:26 被阅读0次
    image.png image.png
    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 
    

    相关文章

      网友评论

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

          本文链接:https://www.haomeiwen.com/subject/vtbpfctx.html