powerDesigner的name和comment转化
2024-08-28 08:34:16
name2comment.vbs
'******************************************************************************
'* File: name2comment.vbs
'* Title: Name to Comment Conversion
'* Model: Physical Data Model
'* Objects: Table, Column, View
'* Author: steveguoshao
'* Created: 2013-11-29
'* Mod By:
'* Modified:
'* Version: 1.0
'* Memo: Modify from name2code.vbs
'****************************************************************************** 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 ' This routine copy name into comment for each table, each column and each view
' of the current folder
Private sub ProcessFolder(folder)
Dim Tab 'running table
for each Tab in folder.tables
if not tab.isShortcut then
tab.comment = tab.name
Dim col ' running column
for each col in tab.columns
col.comment= col.name
next
end if
next Dim view 'running view
for each view in folder.Views
if not view.isShortcut then
view.comment = view.name
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
name2comment_if.vbs
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 'This routine copy name into code for each table, each column and each view
'of the current folder
Private sub ProcessFolder(folder)
Dim Tab 'running table
for each Tab in folder.tables
if not tab.isShortcut then Dim col 'running column
for each col in tab.columns
If (col.comment="") Then '已存在的comment则不更新
col.comment= col.name
end if
next
end if
next Dim view 'running view
for each view in folder.Views
if not view.isShortcut then
view.comment = view.name
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
最新文章
- rsync同步
- React-Native性能优化点
- 何时使用Swift Structs和Classes
- C# 通用验证类 支持 WPF,MVC,Winform
- poj 3625 Building Roads
- MapReduce扩展:应用程序如何运行于Hadoop Yarn之上
- SharePoint2010 部署步骤“激活功能”中出现错误:无法启动计算机“PCName”上的服务SPUserCodeV4
- iot表和heap表排序规则不同
- C#中String和stringBuilder的区别
- mysql中变量character_set_connection的具体作用
- BAYESIAN STATISTICS AND CLINICAL TRIAL CONCLUSIONS: WHY THE OPTIMSE STUDY SHOULD BE CONSIDERED POSITIVE(转)
- powerdesigner将name的名字赋给comment
- B/S架构与C/S架构
- Volterra方程的不动点
- django rest framework ViewSets &; Routers
- sticky footer 模板
- jenkins卡在等待界面解决方法
- 利用python脚本(xpath)抓取数据
- CentOS7中使用yum安装Nginx的方法
- Storm中关于Topology的设计
热门文章
- 「网络流24题」「LuoguP4015」 运输问题
- RadioGroup和RadioButton
- qq截图原理
- centos7安装xtrabackup
- 【WIP】客户端JavaScript Web Object
- python 类对象和实例对象动态添加方法
- bzoj 3230: 相似子串【SA+st表+二分】
- 洛谷P3537 [POI2012]SZA-Cloakroom(背包)
- AFNetworking https自签名证书 -1012 解决方案
- Nginx的location配置概述【转】