Ñò ýɪWc@svddkZddkZddklZddklZdeifd„ƒYZd„Zedjo eƒndS(iÿÿÿÿN(t parseString(tCMSVersionDeploymentPolicyt CustomFieldscBsbeZd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Z d„Z d „Z RS( cCs&tii|ƒd|_d|_dS(NstNAME, GROUP_NAME, ASSET_PATH, DATA_TYPE, JOB_PARAMETER, JOB_SCHEDULE_PARAMETER, DISPLAY_NAME, MULTIVALUE, FIELD_TYPEsSELECT CF.NAME, CFG.DISPLAY_NAME AS GROUP_NAME, CFG.ASSET_PATH, CF.DATA_TYPE, CF.JOB_PARAMETER, CF.JOB_SCHEDULE_PARAMETER, CF.DISPLAY_NAME, CF.MULTIVALUE, CF.FIELD_TYPE FROM MDM_CUSTOM_FIELD CF JOIN MDM_CUSTOM_FIELD_GROUP CFG ON (CF.GROUP_ID = CFG.GROUP_ID)(t BaseClasst__init__tcolumnstselectStatement(tself((sf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pyRs c s±ytiƒ}WntidƒnXtiƒdjo|ˆd}|iˆdˆdƒ|_|itjotS|iid||ifƒt|ii ƒƒot StSnø|iˆdˆdƒ|_t ddƒi ƒ}t |ƒ}ˆd‰ˆd joˆid d ƒ‰nt‡fd †|id ƒƒd‰td„ˆiƒd}td„|iƒd}t‡‡fd†|iƒ}y |dSWntSXdS(Ns3.0g@iiisLSELECT CUSTOM_FIELD_ID FROM MDM_CUSTOM_FIELD WHERE NAME='%s' AND GROUP_ID=%ss\/opt/tandbergtv/cms/plugins/content/com.tandbergtv.metadata.ecmf.ui/resources/definition.xmltrtPACKAGEsPACKAGE/tcs|iiiiˆjS((t firstChildt nextSiblingt nodeValue(telement(t assetName(sf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pyt1sttitlecSs |idjS(tmetadata(tnodeName(R((sf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pyR2scSs#|idjo|idƒdjS(tvariabletnameR(Rt getAttribute(R((sf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pyR3scs.|iˆijo|idƒdˆdjS(RsCustomField[@name=%s]i(tnodeTypet ELEMENT_NODER(R(tdatatasset(sf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pyR5s(Rt getCMSVersiont setCMSVersiont getGroupIdtgroupIdtFalsetcursortexecutetlentfetchalltTruetfiletreadRtreplacetfiltertgetElementsByTagNamet childNodes( RRtversiont fieldNametftdomRt cfVariablet customFields((RRRsf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pytcheckExistences6    % cCsAtiƒdjo&|iidƒ|iiƒddSdSdS(Ng@s1SELECT WFS.MDM_CUSTOM_FIELD_SEQ.NEXTVAL FROM DUALii(RRR R!R#(R((sf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pyt getNextId<sc sÉtiƒdjo|yTd|i||d|igt|dƒƒ}|GH|ii|ƒ|iƒSWqÅtj o}|GH|i ƒSXn7d|dGHt ddƒi ƒ}t |ƒ}|d‰ˆd joˆi d d ƒ‰nt‡fd †|id ƒƒd}td„|iƒd}td„|iƒd} |idƒ} | idd|dƒ| id|dƒ| iddƒ| iddƒ|idƒ} | iddƒ| id|dƒ| iddƒ| idd|diƒƒ| i| ƒ| i| ƒt ddƒ} |i| ddƒ| iƒt ddƒi ƒ}|id |dƒd!joOd"|dGHt ddƒ} | id#|d|diƒfƒ| iƒndS($Ng@s INSERT INTO MDM_CUSTOM_FIELD (CUSTOM_FIELD_ID, NAME, GROUP_ID, DATA_TYPE, JOB_PARAMETER, JOB_SCHEDULE_PARAMETER, DISPLAY_NAME, MULTIVALUE, FIELD_TYPE) VALUES %siis-Adding custom field '%s' to definition.xml...s\/opt/tandbergtv/cms/plugins/content/com.tandbergtv.metadata.ecmf.ui/resources/definition.xmlRiR sPACKAGE/R cs|iiiiˆjS((R R R (R(R(sf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pyRXsRcSs |idjS(R(R(R((sf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pyRYscSs#|idjo|idƒdjS(RRR(RR(R((sf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pyRZsRRsCustomField[@name=%s]t displayNameit showCollapsedttruesxsi:typetcomplexVariableTypet attributetvalues%sVariableTypetwtencodingsUTF-8s[/opt/tandbergtv/cms/plugins/content/com.tandbergtv.metadata/resources/cfDataTypeMapping.dats1/Fields/CustomFields/CustomField[@name=%s]/@valueiÿÿÿÿs4Adding custom field '%s' to cfDataTypeMapping.dat...s6 /Fields/CustomFields/CustomField[@name=%s]/@value, %s(RRt tupleToStrRtlistR R!tcommitt ExceptiontrollbackR%R&RR'R(R)R*t createElementt setAttributetlowert appendChildtwritexmltclosetfindtwrite( Rtid_Rt statementtetfinR.RRR/t cfElementtcfChildElementtfout((Rsf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pytinsertCsP.    %    %c Cs£tiƒdjoŒydd|d|d|d|d|d|d|d |if}|GH|ii|ƒ|iƒSWqŸtj o}|GH|iƒSXndS( Ng@s°UPDATE MDM_CUSTOM_FIELD SET DATA_TYPE='%s', JOB_PARAMETER='%s', JOB_SCHEDULE_PARAMETER='%s', DISPLAY_NAME='%s', MULTIVALUE='%s', FIELD_TYPE='%s' WHERE NAME='%s' AND GROUP_ID=%siiiiiii(RRRR R!R=R>R?(RRRIRJ((sf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pytupdatexs>cCsÏ|i|ƒo»y“|d}d||if}|GH|ii|ƒ|iiƒ}t|ƒdjo1|dd}d|}|GH|ii|ƒn|iƒSWqËtj o}|GH|iƒSXndS(s€Delete custom fields if exists. Only work for CMS3.0 or higher data[0]: fieldName data[1]: groupName data[2]: assetPath isOSELECT CUSTOM_FIELD_ID FROM MDM_CUSTOM_FIELD WHERE NAME='%s' AND GROUP_ID='%s' is7DELETE FROM MDM_CUSTOM_FIELD WHERE CUSTOM_FIELD_ID='%s'N( R1RR R!R#R"R=R>R?(RRR,RItrowtfieldIdRJ((sf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pytdelete‰s   cGstiƒi|ƒS(s getGroupId(groupName, assetPath)(tCustomFieldsGroupsR1(RR((sf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pyR¡scCsdS(s select cf.name, cfg.display_name as GROUP_NAME, cfg.asset_path, cf.data_type, cf.job_parameter, cf.JOB_SCHEDULE_PARAMETER, cf.display_name, cf.multivalue, cf.field_type from mdm_custom_field cf join mdm_custom_field_group cfg on (cf.group_id = cfg.group_id)N((R((sf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pytgetCustomFields¥scCsod}t|ƒdjoM|i|ƒo9|ii||d|ifƒ|iiƒ}|dSndGHdS(sA args[0]: NAME args[1]: DISPLAY_NAME args[2]: ASSET_PATH s™SELECT NAME, DATA_TYPE, JOB_PARAMETER, JOB_SCHEDULE_PARAMETER, DISPLAY_NAME, MULTIVALUE, FIELD_TYPE FROM MDM_CUSTOM_FIELD WHERE NAME='%s'AND GROUP_ID=%siisDCustomFields::backUpExisting:The number of parameters is not correctR (R"R1R R!RR#(RtargsRItrows((sf/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/CustomFields.pytbackUpExisting¬s! c Csg}dddddddg}d}t|ƒd joØtiƒ}|i|ƒ}|ii||ƒ|iiƒ}x—|D]‹}t|ƒt|ƒjolh} xRtd t|ƒƒD];} || d jod | || s  Ó