Powerdesigner 学习笔记

一、Powerdesigner设置MySql默认的存储引擎、字符集及字段从1开始自增

①、点击：工具栏-》database-》edit current DBMS

②、MySql5.0：Script/Objects/Table/Options

③、在options末尾添加： 

ENGINE = %s : list = BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM, default = InnoDB

DEFAULT CHARACTER SET = %s : list = utf8 | gbk, default = utf8 
COLLATE = %s : list = utf8_bin | utf8_general_ci | gbk_bin | gbk_chinese_ci, default = utf8_bin

auto_increment = 1

第一个：存储引擎 
第二个：字符集 
第三个：带bin是区分大小写，ci不区分

reference：http://blog.csdn.net/waterlxj/article/details/8638350

二、Powerdesigner设置name和Comment关联

①、代码一:将Name中的字符COPY至Comment中

Option   ExplicitValidationMode   =   TrueInteractiveMode   =   im_BatchDim   mdl   '   the   current   model'   get   the   current   active   modelSet   mdl   =   ActiveModelIf   (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   mdlEnd   If'   This   routine   copy   name   into   comment   for   each   table,   each   column   and   each   view'   of   the   current   folderPrivate   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      Nextend   sub

②、代码二:将Comment中的字符COPY至Name中

Option   ExplicitValidationMode   =   TrueInteractiveMode   =   im_BatchDim   mdl   '   the   current   model'   get   the   current   active   modelSet   mdl   =   ActiveModelIf   (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   mdlEnd   IfPrivate   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      Nextend   sub

以上两段代码都是VB脚本，在PowerDesigner中使用方法为： 

PowerDesigner->Tools->Execute Commands->Edit/Run Scripts

将代码Copy进去执行就可以了，是对整个CDM或PDM进行操作