eMatrix MQL 语句书写和执行实例

1.用MQL菜单连接到eMatrix set context user creator; verbose on; trigger off;

2.对象删除语句 Del bus "USER" "DANM-ZS" "-" ;

Del bus "USER" "DANM-SZ" "-" ; Del bus "USER" "DANM-BK" "-" ;Del bus "USER" "DANM-PW" "-" ;Del bus "USER" "DANM-LG1" "-" ;Del bus "USER" "DANM-LG2" "-" ;Del bus "USER" "DANM-LG3" "-" ;Del bus "USER" "DANM-LG4" "-" ;Del bus "USER" "DANM-SL" "-" ;Del bus "USER" "DANM-01" "-" ;Del bus "USER" "DANM-02" "-" ;Del bus "USER" "DANM-03" "-" ;Del bus "USER" "DANM-04" "-" ;Del bus "USER" "DANM-05" "-" ;Del bus "USER" "DANM-06" "-" ;Del bus "USER" "DANM-07" "-" ;Del bus "USER" "DANM-08" "-" ; ###○テストケース1Del bus "MODEL" "DANM-MA1" "-" ;Del bus "ASSEMBLY" "DANM-AA1" "-" ;Del bus "DOC_MANAGEMENT" "DANM-CA1" "-" ;Del bus "ENG_DRAWING" "DANM-EA1" "A" ;Del bus "PE_DRAWING" "DANM-PA1" "A" ;Del bus "DCN" "DANM-DA1" "-" ;Del bus "DCN" "DANM-DA2" "-" ; ###○テストケース2Del bus "MODEL" "DANM-MB1" "-" ;Del bus "ASSEMBLY" "DANM-AB1" "-" ;Del bus "DOC_MANAGEMENT" "DANM-CB1" "-" ;Del bus "FAN" "DANM-FB1" "-" ;Del bus "ENG_DRAWING" "DANM-EB1" "A" ;Del bus "ENG_DRAWING" "DANM-EB2" "A" ;Del bus "DCN" "DANM-DB1" "-" ;Del bus "DCN" "DANM-DB2" "-" ;Del bus "DCN" "DANM-DB3" "-" ; ###○テストケース3Del bus "MODEL" "DANM-MC1" "-" ;Del bus "ASSEMBLY" "DANM-AC1" "-" ;Del bus "DOC_MANAGEMENT" "DANM-CC1" "-" ;Del bus "ENG_DRAWING" "DANM-EC1" "A" ;Del bus "DCN" "DANM-DC1" "-" ; ###○テストケース4Del bus "MODEL" "DANM-MD1" "-" ;Del bus "ASSEMBLY" "DANM-AD1" "-" ;Del bus "DOC_MANAGEMENT" "DANM-CD1" "-" ;Del bus "ENG_DRAWING" "DANM-ED1" "A" ;Del bus "DCN" "DANM-DD1" "-" ; ###○テストケース5Del bus "MODEL" "DANM-ME1" "-" ;Del bus "ASSEMBLY" "DANM-AE1" "-" ;Del bus "DOC_MANAGEMENT" "DANM-CE1" "-" ;Del bus "ENG_DRAWING" "DANM-EE1" "A" ;Del bus "DCN" "DANM-DE1" "-" ; ###○テストケース6Del bus "MODEL" "DANM-MF1" "-" ;Del bus "ASSEMBLY" "DANM-AF1" "-" ;Del bus "DOC_MANAGEMENT" "DANM-CF1" "-" ;Del bus "ENG_DRAWING" "DANM-EF1" "A" ;Del bus "DCN" "DANM-DF1" "-" ; ###○テストケース7Del bus "MODEL" "DANM-MG1" "-" ;Del bus "ASSEMBLY" "DANM-AG1" "-" ;Del bus "DOC_MANAGEMENT" "DANM-CG1" "-" ;Del bus "ENG_DRAWING" "DANM-EG1" "A" ;Del bus "ENG_DRAWING" "DANM-EG2" "A" ;Del bus "DCN" "DANM-DG1" "-" ;Del bus "DCN" "DANM-DG2" "-" ; ###○テストケース8Del bus "MODEL" "DANM-MH1" "-" ;Del bus "ASSEMBLY" "DANM-AH1" "-" ;Del bus "DOC_MANAGEMENT" "DANM-CH1" "-" ;Del bus "ENG_DRAWING" "DANM-EH1" "A" ;Del bus "DCN" "DANM-DH1" "-" ; ###○テストケース9Del bus "MODEL" "DANM-MI1" "-" ;Del bus "ASSEMBLY" "DANM-AI1" "-" ;Del bus "DOC_MANAGEMENT" "DANM-CI1" "-" ;Del bus "ENG_DRAWING" "DANM-EI1" "A" ;Del bus "DCN" "DANM-DI1" "-" ; ###○テストケース10Del bus "MODEL" "DANM-MJ1" "-" ;Del bus "ASSEMBLY" "DANM-AJ1" "-" ;Del bus "DOC_MANAGEMENT" "DANM-CJ1" "-" ;Del bus "ENG_DRAWING" "DANM-EJ1" "A" ;Del bus "DCN" "DANM-DJ1" "-" ; 3.对象添加语句   ###sst5ECC.xlsadd bus "USER" "DANR-ZS" "-" vault "COMMON" owner "creator" policy "USER" "UR_Full_Name_Kanji" "部門管理者" "UR_English_Name" "TU" "UR_Group_Category" "|CAR|OEMTESTPrj1|" "UR_Role" "|SECTION_ADMIN|";tcl;set strTagetState "Work"while { [ mql print bus "USER" "DANR-ZS" "-" select current dump ] != $strTagetState } {set appList [split [mql print policy "USER" select state/[[ mql print bus "USER" "DANR-ZS" "-" select current dump ]/].signature dump |] |];foreach ap $appList {mql approve bus "USER" "DANR-ZS" "-" signature $ap}mql promote bus "USER" "DANR-ZS" "-" }exitadd bus "USER&#