ɪWc@sbddkZddkZddkZdeifdYZdZedjo endS(iNtResourceGroupMembershipcBs>eZdZdZdZdZdZdZRS(cCs&tii|d|_d|_dS(NsRESOURCENAME, RESOURCEGROUPNAMEsSELECT R.NAME AS RESOURCENAME, RG.NAME AS RESOURCEGROUPNAME FROM TTV_RESOURCEGROUPMEMBERSHIP RGM JOIN TTV_RESOURCE R ON (RGM.RESOURCEID = R.RESOURCEID) JOIN TTV_RESOURCEGROUP RG ON (RGM.RESOURCEGROUPID = RG.RESOURCEGROUPID)(t BaseClasst__init__tcolumnstselectStatement(tself((sq/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ResourceGroupMembership.pyRs cCs|d}tii|g|_|d}tiit|g|_|iid|i|if|ii}t |ot St SdS(NiisTSELECT * FROM TTV_RESOURCEGROUPMEMBERSHIP WHERE RESOURCEID=%s AND RESOURCEGROUPID=%s( t ResourcestcheckExistencet resourceIdtResourceGroupsttupletgroupIdtcursortexecutetfetchalltlentTruetFalse(Rtdatat resourceNamet groupNametrows((sq/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ResourceGroupMembership.pyRs  !  cCs0dSy|iidddSWndSXdS(Nii(R R(R((sq/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ResourceGroupMembership.pyt getNextIds cCsjyBd|i|i|ig}|GH|ii||iSWn!tj o}|GH|iSXdS(NsOINSERT INTO TTV_RESOURCEGROUPMEMBERSHIP (RESOURCEID, RESOURCEGROUPID) VALUES %s(t tupleToStrRR R R tcommitt Exceptiontrollback(Rtid_Rt statementte((sq/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ResourceGroupMembership.pytinsert%scCsdS(N((RR((sq/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ResourceGroupMembership.pytupdate0scCs|d}tii|g|_|itjoXy0d|i}|GH|ii||iSWqtj o}|GH|iSXndS(sV delete the membership between resource and resource group data[0]: resource name is=DELETE FROM TTV_RESOURCEGROUPMEMBERSHIP WHERE RESOURCEID = %sN( RRRRR R RRR(RRRRR((sq/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ResourceGroupMembership.pytdelete4s  (t__name__t __module__RRRRRR (((sq/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ResourceGroupMembership.pyRs   cCst}|iddS(Ns /tmp/rgm.tdf(Rtexport(trgm((sq/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ResourceGroupMembership.pytmainEs t__main__(RRR RR%R!(((sq/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ResourceGroupMembership.pyts   ?