Ñò ýɪWc@sVddkZddkZdeifd„ƒYZd„Zedjo eƒndS(iÿÿÿÿNtSiteParameterscBsPeZd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Z RS(cCs/tii|ƒd|_d|_d|_dS(NsSITE_NAME, NAME, VALUEtSITES_DIST_CONF_PARAMSsnSELECT S.NAME SITE_NAME, P.NAME, P.VALUE FROM SITES_DIST_CONF_PARAMS P JOIN SITES_SITE S ON (P.SITEID = S.ID_)(t BaseClasst__init__tcolumnsttabletselectStatement(tself((sh/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SiteParameters.pyRs  cCsŒtiƒi|dfƒ|_|itjotS|d}|iid|i|fƒ|iiƒ}t|ƒo |ddStSdS(NiisFSELECT VALUE FROM SITES_DIST_CONF_PARAMS WHERE SITEID=%s AND NAME='%s'(tSitestcheckExistencetsiteIdtFalsetcursortexecutetfetchalltlen(Rtdatatnametrows((sh/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SiteParameters.pyR s   cCsdS(Ni((R((sh/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SiteParameters.pyt getNextIdsc CsyyNd|i|ig|d|dgƒ}|GH|ii|ƒ|iƒWn$tj o}|GH|iƒnXdS(NsBINSERT INTO SITES_DIST_CONF_PARAMS (SITEID, NAME, VALUE) VALUES %sii(t tupleToStrR R R tcommitt Exceptiontrollback(Rtid_Rt statementte((sh/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SiteParameters.pytinserts+cCslyAd|d|i|df}|GH|ii|ƒ|iƒWn$tj o}|GH|iƒnXdS(NsJUPDATE SITES_DIST_CONF_PARAMS SET VALUE='%s' WHERE SITEID=%s AND NAME='%s'ii(R R R RRR(RRRR((sh/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SiteParameters.pytupdate*scCsÊ|d}t|ƒdjo|d}ntiƒi|dfƒ}y[|tjo!|djod||f}n d|}|GH|ii|ƒ|iƒSWn!tj o}|GH|i ƒSXdS(s{ delete the site parameter from table 'SITES_DIST_CONF_PARAMS' if only site Name specified, all the site parameters under this site will be deleted. otherwise, only delete that specified parameter 1. delete all the parameter under the site data[1]: siteName 2. only delete one site parameter data[0]: parameter name data[1]: siteName data[...]: not care iisBDELETE FROM SITES_DIST_CONF_PARAMS WHERE SITEID='%s' AND NAME='%s's4DELETE FROM SITES_DIST_CONF_PARAMS WHERE SITEID='%s'N( RRR R tNoneR R RRR(RRtparmNametsiteNameR RR((sh/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SiteParameters.pytdelete5s  cCsbd}d}t|ƒdjo?|ii||d|dfƒ|iiƒ}|d}n|S(s, args[0]: paraName args[1]: siteName sˆSELECT SP.NAME, SP.VALUE FROM SITES_DIST_CONF_PARAMS SP JOIN SITES_SITE SS ON (SP.SITEID = SS.ID_) WHERE SS.NAME='%s' AND SP.NAME='%s'tiii(RR R R(RtargstsiteOneParametersStatementtresulttsiteParameterRows((sh/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SiteParameters.pytbackUpExistingUs"cCsÏg}d}|dj o²t|ƒo¥|ii||ƒ|iiƒ}x|D]s}h}|ddjod|ds  w