ɪWc@srddklZddklZddklZddklZddklZddkZddkZddk Z ddk Z ddk Z ddk Z ddk Z ddkZddkZddklZddklZdd klZdd klZdd klZdd klZd efdYZdZdZedjoeiddZendS(i(t BaseClass(tCommon(t InstallHelper(tContentClassHandler(tDaoN(tInstallComponentCollector(tInstallComponent(tCMSVersionDeploymentPolicy(tFileSync(t SSHCommander(tEnhancementRulesettRollbackcBseZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZedZdZdZdZRS(cCsOti||i||itii|_|ii|_ dS(N( Rt__init__tloadJsonConfigt initPolicyRtgetPrepackDepolymentPolicytgetDatabaseConnectiont_Rollback__conntcursort_Rollback__cursor(tselftsystemInfoFile((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pyR 's    cCsHdGH|iidti|i|iddd|iidS(NsRollback template versions=update JBPM_PROCESSDEFINITION set PROCESSDEFINITIONTYPEID = 1ttemplateVersionstJBPM_PROCESSDEFINITIONtID_(RtexecuteRtupdatet getConfigRtcommit(R((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pytrollbackTemplate.s"c CsM|djptii| odS|d}ti|||d}d|GH|id|||ti|idd|idd}|i |}|i |}g} |D]} | |jo | | qq~ } d| GH|i | |i ||i |||t i|i|id d d d |iidS( Ns _orig_.xmls _export_.xmlsexport current ruleset to s-101tcmstusertpasswordsto be delete rule set ids: %st ruleSetStatust TRE_RULESETt RULESETIDtRULENAME(tNonetostpathtexiststshutiltcopyfilet exportRulestRulesetstconfigtgetUuidsFromXmltdeleteRulSetsByUuidtupdateProfileIdtimportRulesFromXmlRRRRRR( Rt origFilePathtusernameR torgRuleSetExportPathtcurRuleSetExportPathtruleSetst orgRuleSetIdst curRuleSetIdst_[1]tidttoBeDeleteRuleSetIds((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pytrollbackRuleSet4s"!   (2   %cCst}|i|dS(sU Description: Update the ME profile id with the actual profile name N(R treplaceWithProfileId(Rt rulesetPatht enhancement((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pyR0Ms c CsVdGHy|id}ti|id}g}|D]}||dq7~}g}|D]"}|d|jo ||q\q\~}x|D]}}|i|d ob|ddjoQd|dGH|iid|ddt|GHti|i|d dqqW|ii Wn2t j o&}t i GHd GH|ii nXdS( Nsrollback resource grouptresourceGroupss2SELECT RESOURCEGROUPID,NAME FROM TTV_RESOURCEGROUPtRESOURCEGROUPIDtNAMEtClustersDUPDATE jbpm_node SET resourcegroupid=NULL WHERE resourcegroupid = %ssdelete resource group: tTTV_RESOURCEGROUPs FAILED TO ROLLBACK RESOURCEGROUP(RRtexportRt/_Rollback__existsRelativeRecordForResourceGroupRtstrtdeleteRRt Exceptiont tracebackt format_exctrollback( Rtorg_recourceGroupstcur_recourceGroupsR9trgt org_rgIdst_[2]tdurtyRecourceGroupste((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pytrollbackRecourceGroupTs$%6& ! cCsLdGHy|i|idWn&tj o}tiGHdGHdSXdS(Ns#rollback resource groups allocationtresourceGroupsAllocations,FAILED TO ROLLBACK RESOURCEGROUPS ALLOCATION(tupdateResourceGroupsAllocationRRIRJRK(RRS((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pyt rollbackResourceGroupsAllocationhs cCsd|}|ii||iid}|djotSd|}|ii||iid}|djotStSdS(NseSELECT COUNT(*) FROM JBPM_TOKEN WHERE NODE_ IN (SELECT ID_ FROM JBPM_NODE WHERE RESOURCEGROUPID = %s)is7SELECT COUNT(*) FROM JBPM_LOG WHERE RESOURCEGROUPID =%s(RRtfetchonetTruetFalse(RtresourceGruopIdtsqltrowCount((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pyt&__existsRelativeRecordForResourceGroupqs    c Cs1ydGH|id}ti|id}g}|D]}||dq7~}g}|D]"}|d|jo ||q\q\~}x`|D]X}|i|d o=|ddjo,dt|GHti|i|ddqqW|iiWn2t j o&}t i GHd GH|ii nXdS( Nsrollback resource typet resourceTypessIselect RESOURCETYPEID,NAME,RESOURCECONNECTIONTYPEID from TTV_RESOURCETYPEtRESOURCETYPEIDRBRCsdelete resource type: tTTV_RESOURCETYPEsFAILED TO ROLLBACK RESOURCETYPE( RRRERt._Rollback__existsRelativeRecordForResourceTypeRGRHRRRIRJRKRL( Rtorg_recourceTypestcur_recourceTypesR9trtt org_rtIdsRQtdurtyRecourceTypesRS((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pytrollbackResourceTypes %6&! cCs7d|}|ii||iid}|djS(Ns@SELECT COUNT(*) FROM TTV_RESOURCEGROUP WHERE RESOURCETYPEID = %si(RRRX(RtresourceTypeIdR\R]((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pyt%__existsRelativeRecordForResourceTypes cCsti|iidS(N(RtgetReportInstallerR-tconfigureCategoryAndReports(R((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pytrollBackReportssc CscdGH|id}|oDg}|D]4}ttid|dtio ||q&q&~}g}|D]4}ttid|dtio ||qnqn~}g}|D]4}ttid|dtio ||qq~}g} |D]5}ttid|dti o | |qq~ } | |||}|i|ndS(Nsrollback queriestrollBackQueriess drop viewtQUERYs drop sequences drop tabletdrop(RtbooltretmatchtItconfigureDatabase( RtsqlsR9tqtdrop_view_sqlsRQtdrop_sequence_sqlst_[3]tdrop_table_sqlst_[4]t others_qls((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pytrollbackQueriessHHHIcCsqdGH|id}|GH|oMx9|D]1}ti|i|d|dt|dq'W|iindS(Nsrollback QueriesDatat queriesDatatdatatTABLEt ID_COLUMNS(RRRRttupleRR(RRtdictObj((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pytrollbackQueriesDatas/cCs]dGH|id}|o>x;|D]/}ti||idd|iddq"WndS(Nsrollback content classestcontentClassBackupPathsRRR (RRtimportContentClassR-(RtcontentClassPathstxmlPath((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pytrollbackContentClassess cCs|id}|owt|dtxd|D]X}yti||dGHWq-tj o)}|itijo |dGHqq-Xq-WndS(NtdirectoriesToRemovetreverses directory was deleteds directory not empty(RtsortedRYR&trmdirtOSErrorterrnot ENOTEMPTY(RRtdtex((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pytrollbackCreatedDirectoriess  cCs |i}|id|dS(s2 roll back prepack info files tprepackVersionInfoFileToDeleteN(tgetPrepackInfoBackupDirt_rollbackFiles(RtprepackInfoBackupDir((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pytrollbackPrepackVersionInfos c CsdGH|id}|djodSd}x|D]}|d}|d}|i|}|djpt|djotd|nti|}tii|}tii |pti |nt i |i ||x|D]} d| dGHzyt| d| d | d }d ||f} |i| | d \} } | GH| djo td |d| dnWntj o nXWd|o|inXqWtii|oti|q3t i|dtq3WdS(NsRollback remote filestremoteFilesToRestoret remotePathtremoteNodeConfigNameis%Required config entry has not found: s$Start to rollback a file to remote: tipRR ssu root -c "\cp -rf %s %s"t rootPasswdsFailed to rollback file [s] on t ignore_errors(RR%tlenRIRtCOMMON_SHARED_FOLDERR&R'tdirnameR(tmakedirsR)R*tgetFileBackupDirR texecute_interactivetlogouttisfiletremovetrmtreeRY( RtitemstcmdtitrmtPathtcfgNamet remoteNodest shared_fileRtrndt rollback_cmdtstatustoutput((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pytrollbackRemoteFilessF       $ cCst|i|dt|iti|id|i|i|i|id|idddg|i dddg|i |i |i |i |id|i|id|i|id tid jo|i|id n|i|i|i|i|i|i|iddg|i|i|i|id |i|id |i|i |id|i!dd|i!dd|i"|id|i#|id|ido|id p8|idi$djo|idi$djo|idGHd}|t%i&d}t%i'i(|pst%i'i)|pt%i*|nt%i'i+t%i'i,t-}t%i'i+|t%i&d}t.i/||nt0|idi1}|pt2Sn|idddg|i3dddg|idtS(NtmergeWithExistings Rollback for s Rtworkflowttomcatt selectorKeyst customFieldst resourcesg@talertstpartnerst meprofilestruleSetsBackupPathRR tsitestrollbackPostScriptstcluster_app_nodestignoreFileSycntYtYESs+/opt/tandbergtv/cms/prepack/filesync/scriptssync.pysGcomponents/BASE/conf/opt/tandbergtv/cms/prepack/filesync/script/sync.pysRollback complete.(4R RYtinitParametersRt setOverrideRtnamet backupVersiontstopServiceInClusterNodeststopLocalServicest rollbackFilesRRtinsertSelectorKeysRtinsertCustomFieldsGroupstinsertResourcesRt getCMSVersiont insertAlertst restartAlertsRTRhRWRR~trestartLocalServicestwaitForOtherServersAvailableRmtinsertPartnersthandleMeSubsProfilesRR<R-t insertSitestexecuteScriptstupperR&tsepR'R(tisdirRRtrealpatht__file__R)R*RtdosyncRZtrestartServiceInClusterNodes(RtrollbackJsonConfigtsync_script_dirt sync_scripttrunning_script_dirtto_copy_scripttsync_successed((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pyt _rollbacksf               2  cCstiidGHdS(Nsclean database connection(RRtcleanDatabaseConnection(R((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pytcleanCscCs|iip|idtS|ii|_|ii|i\}}|o!|id|d|dnnti|idtid|i tid|i |iti|ii dptS|i d |i }|iiti|itiy^|i|}|o@|iiti|iti|i|ii|in|SWntj otiGHtSXdS( NsXNo backup is currently available for roll back, please contact the system administrator.s4System is rolling back current Prepack from version s to version t.sYSystem will roll back from current status to last snapshot, please refer below as detail:sCurrent Prepack Status: sLast Snapshot Prepack Status: sNAre you sure you want to proceed? Type 'yes' to proceed, type 'no' to skip... t/(thelpertgetLatestBackupVersionRRZRtgetUpgradeFromToRtprintSeperateLinetprintHighlightMessaget printCurrentPrepackInstallStatustprintBackupPrepackInstallStatust promptYesOrNot getBackupDirt ROLLBACK_JSONt logActionstROLLBACKtSTARTRtFINISHRtrollBackToLastVersionRIRJRK(Rtautot fromVersiont toVersiontrollbackJsonConfigPathtresult((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pyRLGs8 !        cCsD|ii}|ii}|ii}|i|||dS(N(RtgetCurrentPrepackVersiont"getPatchesForCurrentPrepackVersiontloadInstalledComponentstprintInstallStatus(RtprepackVersiontpatchestinstalledComponents((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pyRjscCsM|ii|}|ii|}|ii|}|i|||dS(N(RtgetBackupPrepackVersiont!getPatchesForBackupPrepackVersiontloadBackupInstalledComponentsR(RRRRR((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pyRpscCs{d}|o |}nd|GHd}|odi|}nd|GHdGH|otiti|ndGHdS(NtScratchsPrepack Version: R%t,sInstalled Patches: sInstalled Components: (tjoinRtprintInstallComponentsRtfromJsonObject(RRRRtpreparckVersionDisplaytpatchesDisplay((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pyRvs   (t__name__t __module__R RR<R0RTRWRFRhRbRmR~RRRRRRRRZRLRRR(((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pyR %s,            + H  #  cCs |GHdS(N((t outputstr((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pyRsc Csatiid}|djo%tdtdtidnti}|idddd d d d d dd|i \}}di |GHd}zyAt |i }|i}|ptdtidnWnQtj o(tdtdtidntj otiGHnXWd|o|inXtiddS(NtLOGNAMEtrootsYou must run this as user root.s Exiting...is-is --sys-infotactiontstorettypetstringtdestRthelps%Configuration for system information.s options: {0}sRollback Failed Or Skipped.its-C detected...Exiting...i(R&tenvirontgetRtsystexittoptparset OptionParsert add_optiont parse_argstformatR%R RRLtKeyboardInterruptRIRJRKR(t userlogint optparsertoptionstargstrolR((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pytmains8        t__main__s rollback.logta(RRRt FileAssemblerRtdbutilsRR,tTeeRR&RR RrR)RJRRRtfilesyncRR R R RR+RtlogFile(((sb/home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/rollback.pyts4         f  !