Ñò ýɪWc@svddkZddkZddklZddklZdeifd„ƒYZd„Zedjo eƒndS(iÿÿÿÿN(t parseString(tCMSVersionDeploymentPolicytCustomFieldsGroupscBsYeZd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Z d„Z RS( cCs0tii|ƒd|_d|_|iƒdS(NsDISPLAY_NAME, ASSET_PATH, UUIDtMDM_CUSTOM_FIELD_GROUP(t BaseClasst__init__tcolumnsttabletsetSelectStatement(tself((sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pyR s  c Cs|d}|d}tiƒdjoK|iid||fƒ|iiƒ}t|ƒo |ddStSnžtddƒiƒ}t |ƒ}t d„|i dƒƒ}t d „|ƒ}|d jo|i d d ƒ}ny||i|ƒSWntj otSXdS( Niig@sWSELECT GROUP_ID FROM MDM_CUSTOM_FIELD_GROUP WHERE DISPLAY_NAME='%s' AND ASSET_PATH='%s's\/opt/tandbergtv/cms/plugins/content/com.tandbergtv.metadata.ecmf.ui/resources/definition.xmltrcSs|idƒdjS(tnamet CustomFields(t getAttribute(tvariable((sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pyt"sRcSs|iiiiiiS((t parentNodet firstChildt nextSiblingt nodeValue(telement((sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pyR#stPACKAGEsPACKAGE/t(Rt getCMSVersiontcursortexecutetfetchalltlentFalsetfiletreadRtfiltertgetElementsByTagNametmaptreplacetindext ValueError( R tdatat groupNamet assetPathtrowstftdomt customFieldstpaths((sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pytcheckExistences$      cCsAtiƒdjo&|iidƒ|iiƒddSdSdS(Ng@s7SELECT WFS.MDM_CUSTOM_FIELD_GROUP_SEQ.NEXTVAL FROM DUALii(RRRRR(R ((sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pyt getNextId-sc sÌtiƒdjo±t|ƒdjo|d}n|i|d|dƒ}yNd|i|gt|d ƒ|gƒ}|GH|ii|ƒ|iƒSWqÈt j o}|GH|i ƒSXnt ddƒi ƒ}t |ƒ}|did ƒd ‰t‡fd †|id ƒƒd}td „|iƒd} |idƒ} | iddƒ| iddƒ| iddƒ| i|idƒƒ| i| ƒt ddƒ} |i| ddƒ| iƒdS(Ng@iiiisWINSERT INTO MDM_CUSTOM_FIELD_GROUP (GROUP_ID, DISPLAY_NAME, ASSET_PATH, UUID) VALUES %ss\/opt/tandbergtv/cms/plugins/content/com.tandbergtv.metadata.ecmf.ui/resources/definition.xmlR t/iÿÿÿÿcs|iiiiˆjS((RRR(R(t assetName(sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pyRHsttitlecSs |idjS(tmetadata(tnodeName(R((sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pyRIsRR R t displayNamesmetadata.customFieldssxsi:typetcomplexVariableTypes twtencodingsUTF-8(RRRt generateUUIDt tupleToStrtlistRRtcommitt ExceptiontrollbackRRRtsplitRR t childNodest createElementt setAttributet appendChildtcreateTextNodetwritexmltclose( R tid_R%tut statementtetfinR*tassetR2t cfElementtfout((R0sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pytinsert4s4+ % cCsžtiƒdjo‡t|ƒdjop|d}y>d||d|df}|GH|ii|ƒ|iƒSWq–tj o}|GH|iƒSXqšndS(Ng@iisWUPDATE MDM_CUSTOM_FIELD_GROUP SET UUID='%s' WHERE DISPLAY_NAME='%s' AND ASSET_PATH='%s'ii(RRRRRR;R<R=(R R%RGRHRI((sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pytupdateXs cCs©|d}|d}|i|ƒ}|tjodSyLd|}|GH|ii|ƒd|}|GH|ii|ƒ|iƒSWn!tj o}|GH|iƒSXdS(s$delete the custom field group from table 'MDM_CUSTOM_FIELD_GROUP'. if the custom field group has custom fields, all the custom fields under this group will be deleted as well. data[0]: display name data[1]: asset path for example, delete('Custom Fields', 'PACKAGE/PREVIEW') iiNs2DELETE FROM MDM_CUSTOM_FIELD WHERE GROUP_ID = '%s's8DELETE FROM MDM_CUSTOM_FIELD_GROUP WHERE GROUP_ID = '%s'(R-RRRR;R<R=(R R%R&R'tgroupIdRHRI((sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pytdeletejs     cGsttitit|ƒƒƒS(N(tstrtuuidtuuid5t NAMESPACE_DNS(R R%((sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pyR8‹scCsWd}t|ƒdjo:|ii||d|dfƒ|iiƒ}|dSdS(NsmSELECT DISPLAY_NAME, ASSET_PATH, UUID FROM MDM_CUSTOM_FIELD_GROUP WHERE DISPLAY_NAME='%s' AND ASSET_PATH='%s'iiiR(RRRR(R targsRHR(((sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pytbackUpExistings " cGs™t|dƒttƒƒjo|d}n|i|ƒp!|i|dt|ƒd!ƒo%t|i|dt|ƒd!ƒfSt|dd!fSdS(Niii(ttypettupletisDeleteR-RRRWtTrue(R RV((sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pytbackup˜s  1%( t__name__t __module__RR-R.RNRORQR8RWR\(((sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pyR s   $  !  cCstƒ}|idƒdS(Ns Custom FieldssPACKAGE/ENCRYPTEDtasdfasfasfasdfasdfsa(s Custom FieldssPACKAGE/ENCRYPTEDR_(Rtadd(tcfg((sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pytmain s t__main__(RRStxml.dom.minidomRRRRbR](((sl/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFieldsGroups.pyts  –