如何在Powerdesigner中使用VBScript？

Question

在Powerdesigner中，想要创建VBscript来重命名/重新格式化以下Conceptual或Physical模型名称： Alternative/Unique Key Name:

UQ {table_name} {tablecolumnname} /////// 例如 = UQ_Account_AccountNumber

Relationship Name:

FK_{table_name}_{reference_table_name}_{reference_column_name} //////例如 = FK_Account_AccountPhone_HomePhoneID

问题是，如何获取“table_column_name”和“reference_column_name”？

- 001

---

有用的：http://blogs.conchango.com/danperrin/archive/2008/07/11/sybase-powerdesigner-scripting.aspx - 001

Answer 1

这是我用来重命名所有引用的“友好名称”和约束名称的东西，也许对你有帮助。

Option Explicit
ValidationMode  = True
InteractiveMode = im_Batch

Dim mdl 
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 a Physical Data model."
Else
   ProcessFolder mdl
End If

Private sub ProcessFolder(folder)
   Dim Tab, Key, Rel
   for each Rel in Folder.References
      Rel.ForeignKeyConstraintName = "FK_" + UCASE(Rel.ParentTable.Name) + "_" + UCASE(Rel.ParentKeyColumnList) + "_" + UCASE(Rel.ChildTable.Name) + "_" + UCASE(Rel.ForeignKeyColumnList)
      Rel.Name = "FK_" + UCASE(Rel.ParentTable.Name) + "_" + UCASE(Rel.ParentKeyColumnList) + "_" + UCASE(Rel.ChildTable.Name) + "_" + UCASE(Rel.ForeignKeyColumnList)
   next
end sub

- Calvin Allen