Ńň ýÉŞWc@svddkZddkZddklZddklZdeifd„ƒYZd„Zedjo eƒndS(i˙˙˙˙N(tfnmatch(tCMSVersionDeploymentPolicytPartnerscBsPeZd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Z RS(cCs?tii|ƒd|_d|_|iƒ|id7_dS(Ns(NAME, PARTNERTYPE, PROVIDERID, LOOKUPKEYt PMM_PARTNERs$ WHERE PARTNERTYPE!=1 AND ISACTIVE=1(t BaseClasst__init__tcolumnsttabletsetSelectStatementtselectStatement(tself((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/Partners.pyRs    cCsa|d}|djotS|iid|ƒ|iiƒ}t|ƒo |ddStSdS(Nits@SELECT ID_ FROM PMM_PARTNER WHERE PROVIDERID='%s' AND ISACTIVE=1(tFalsetcursortexecutetfetchalltlen(R tdatat providerIdtrows((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/Partners.pytcheckExistences    cCsE|iidƒ|iidƒ|iidƒ|iiƒddS(Ns,SELECT WFS.PMM_CONTEXT_SEQ.NEXTVAL FROM DUALs,SELECT WFS.PMM_PARTNER_SEQ.NEXTVAL FROM DUALs,SELECT WFS.PMM_CONTACT_SEQ.NEXTVAL FROM DUALi(R RR(R ((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/Partners.pyt getNextIdsc Csdtiƒ}y0|d}d|}|GH|ii|ƒtiƒdjo>d|i|gdd|gt|d ƒdgƒ}n0d |i|gdt|d ƒdgƒ}|GH|ii|ƒd ||f}|GH|ii|ƒx<|dD]0}|i||fƒp|i||ƒqýqýW|i ƒSWn!t j o}|GH|i ƒSXd S( sHdata: (PROVIDERID,NAME,PARTNERTYPE,LOOKUPKEY,CONTENTCLASSNAME,IS_DELETE)is=INSERT INTO PMM_CONTEXT (ID_, CONTAINERTYPEID) VALUES (%s, 1)g@sxINSERT INTO PMM_PARTNER (ID_, CONTEXTID, AFFILIATION_CODE, PROVIDERID, NAME, PARTNERTYPE, LOOKUPKEY, ISACTIVE) VALUES %sis%05diisfINSERT INTO PMM_PARTNER (ID_, CONTEXTID, PROVIDERID, NAME, PARTNERTYPE, LOOKUPKEY, ISACTIVE) VALUES %ss8INSERT INTO PMM_CONTACT (ID_, PARTNERID) VALUES (%s, %s)N( tContentClassPartnersR RRt getCMSVersiont tupleToStrtlistRtinserttcommitt Exceptiontrollback(R tid_RtcpRt statementt contentClasste((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/Partners.pyR$s0   ;, cCsŇtiƒ}yž|d}d|d|d|d|f}|GH|ii|ƒ|i|gƒx<|dD]0}|i||fƒp|i||ƒqkqkW|iƒSWn!tj o}|GH|iƒSXdS(sIdata: (PROVIDERID, NAME,PARTNERTYPE,LOOKUPKEY,CONTENTCLASSNAME,IS_DELETE)isYUPDATE PMM_PARTNER SET NAME='%s', PARTNERTYPE='%s', LOOKUPKEY='%s' WHERE PROVIDERID='%s' iiiiN( RR RtdeleteRRRRR(R RRRR R!R"((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/Partners.pytupdateDs  " c Cs=|d}|i|fƒ}|tjodSyçd|}|GH|ii|ƒd|}|GH|ii|ƒ|iiƒ}t|ƒo|d}nd}tiƒ}|i|gƒd|}|GH|ii|ƒ|djo#d|}|GH|ii|ƒn|iƒSWn!t j o}|GH|i ƒSXdS(s data[0]: Provider Id iNs,DELETE FROM PMM_CONTACT WHERE PARTNERID='%s's0SELECT CONTEXTID FROM PMM_PARTNER WHERE ID_='%s'i˙˙˙˙s&DELETE FROM PMM_PARTNER WHERE ID_='%s's&DELETE FROM PMM_CONTEXT WHERE ID_='%s'( RR R RtfetchoneRRR#RRR( R RRt partnerIdR trowt contextIdRR"((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/Partners.pyR#[s8         cCs yád||f}|GH|ii|ƒ|iiƒ}|d}d|}|GH|ii|ƒd|}|GH|ii|ƒ|iiƒ}|d}d|}|GH|ii|ƒd|}|GH|ii|ƒ|iƒSWn!tj o}|GH|iƒSXdS(sTthis delete method is only used to delete partner whose partner type is DISTRIBUTIONsDSELECT ID_ FROM PMM_PARTNER WHERE NAME = '%s' AND PARTNERTYPE = '%s'is,DELETE FROM PMM_CONTACT WHERE PARTNERID='%s's0SELECT CONTEXTID FROM PMM_PARTNER WHERE ID_='%s's&DELETE FROM PMM_PARTNER WHERE ID_='%s's&DELETE FROM PMM_CONTEXT WHERE ID_='%s'N(R RR%RRR(R t partnerNamet partnerTypeR R'R&R(R"((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/Partners.pytdeleteDistributionPartner‰s0      c Csd}d}|ddjpt|dƒ odS|d}|ii||ƒg}|iiƒ}x|D]}|i|dƒqnW|ii||ƒ|iiƒ}d} d} t|ƒo7t|dƒdjo |dd} |dd} n|gg| | g|g} | S(s# Input: args[0]: ProviderId sTSELECT ID_, NAME, PARTNERTYPE FROM PMM_PARTNER WHERE PROVIDERID='%s' AND ISACTIVE=1sČSELECT CC.NAME AS CONTENTCLASSNAME FROM PMM_CONTENT_CLASS_PARTNER CCP JOIN PMM_CONTENT_CLASS CC ON (CCP.CONTENT_CLASS_ID = CC.ID) JOIN PMM_PARTNER P ON (CCP.PARTNER_ID = P.ID_) WHERE P.PROVIDERID='%s'iNR ii(tNoneRR RRtappend( R targstpartnersStatementtcontentClassStatementRtcontentClassestcontentClassNamesRowstcontentClassRowtpartnerR)R*tresult((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/Partners.pytbackUpExistingŞs(# $( t__name__t __module__RRRRR$R#R+R6(((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/Partners.pyRs    . !cCs9tƒ}|iddddƒ|iddddƒdS(Ntindemandis indemand.comistestscript.com(RR#tadd(tp((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/Partners.pytmainŮs t__main__(RRRRRR<R7(((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/Partners.pyts  Ň