Ñò
ýÉªWc           @   sV   d  d k  Z  d  d k Z d e  i  f d „  ƒ  YZ d „  Z e d j o e ƒ  n d S(   iÿÿÿÿNt   MeSubsProfileParameterc           B   sq   e  Z d  Z d „  Z d „  Z d „  Z d „  Z d „  Z d „  Z d „  Z	 d „  Z
 d	 „  Z d
 „  Z d „  Z RS(   sS   
		data[0]: meProfileName	SD
		data[1]: NAME			PackageType
		data[2]: VALUE			MOD
	c         C   s   t  i  i |  ƒ d  S(   N(   t	   BaseClasst   __init__(   t   self(    (    sp   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfileParameter.pyR      s    c         C   s€   | d } | d } |  i  | ƒ } | t j o t S|  i i d | | f ƒ |  i i ƒ  } t | ƒ o | d d St Sd S(   s5   
		data[0]: parameter name
		data[1]: profile name
		i    i   sJ   SELECT ID FROM ME_SUBS_PROFILE_PARAMETER WHERE PROFILE_ID=%d AND NAME='%s'N(   t   getMeProfileIdt   Falset   cursort   executet   fetchallt   len(   R   t   datat   paraNamet   meProfileNamet   meProfileIdt   rows(    (    sp   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfileParameter.pyt   checkExistence   s    

c         C   s   d S(   Ni   (    (   R   (    (    sp   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfileParameter.pyt	   getNextId    s    c         C   s¤   t  | ƒ d j oˆ | d } | d } |  i | ƒ } | t j o t Sd | | f } |  i i | ƒ |  i i ƒ  } t  | ƒ d j o g  S| d Sn d GHd S(   s•   
		data[0]: Parameter Name
		data[1]: ME Profile Name
		
		return an array contains (NAME,VAlUE) of the given profile name specified by data[1]
		
		i   i    i   sS   SELECT NAME, VALUE FROM ME_SUBS_PROFILE_PARAMETER WHERE PROFILE_ID=%d AND NAME='%s'sN   MeSubsProfileParameter::backUpExisting:The number of parameters is not correctN(   R	   R   R   R   R   R   (   R   R
   R   R   R   t   profileParStatementR   (    (    sp   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfileParameter.pyt   backUpExisting#   s    

c   
      C   só   |  i  | ƒ } | t j o d | GHg  Sd d g } d | } |  i i | ƒ |  i i ƒ  } t | ƒ oƒ g  } xz | D]n } h  } xR t d t | ƒ ƒ D]; }	 | |	 d j o d | | |	 <q› | |	 | | |	 <q› W| i | ƒ qy Wn | S(   s2   
		backup all the parameters of a given profile
		sG   [Error]MeSubsProfileParameter::backUpAllExisting: profile %s not found!t   NAMEt   VALUEsS   SELECT PP.NAME, PP.VALUE FROM ME_SUBS_PROFILE_PARAMETER PP WHERE PP.PROFILE_ID = %di    t    N(	   R   R   R   R   R   R	   t   ranget   Nonet   append(
   R   t   profileNamet	   profileIdt   parameterKeyArrayt	   statementR   t
   parameterst   rowt	   parametert   i(    (    sp   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfileParameter.pyt   backUpAllExisting=   s*    	  c   	      C   s¦   y~ | d } | d } | d } |  i  | ƒ } | t j o t Sd |  i | | | g ƒ } | GH|  i i | ƒ |  i ƒ  SWn! t j
 o } | GH|  i ƒ  SXd S(   sU   
		data[0]: Parameter Name
		data[1]: ME Profile Name
		data[2]: Parameter Value		
		i    i   i   sI   INSERT INTO ME_SUBS_PROFILE_PARAMETER (PROFILE_ID, NAME, VALUE) VALUES %sN(   R   R   t
   tupleToStrR   R   t   committ	   Exceptiont   rollback(	   R   t   id_R
   R   R   t	   paraValueR   R   t   e(    (    sp   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfileParameter.pyt   insertY   s    


c         C   s   yu | d } | d } | d } |  i  | ƒ } | t j o t Sd | | | f } | GH|  i i | ƒ |  i ƒ  SWn! t j
 o } | GH|  i ƒ  SXd S(   sU   
		data[0]: Parameter Name
		data[1]: ME Profile Name
		data[2]: Parameter Value		
		i    i   i   sQ   UPDATE ME_SUBS_PROFILE_PARAMETER SET VALUE='%s' WHERE PROFILE_ID=%d AND NAME='%s'N(   R   R   R   R   R#   R$   R%   (   R   R
   R   R   R'   R   R   R(   (    (    sp   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfileParameter.pyt   updatep   s    


c         C   s”   | d } | d } | d } |  i  | ƒ } | t j o d Sd | } | GHy |  i i | ƒ |  i ƒ  SWn! t j
 o } | GH|  i ƒ  SXd S(   sU   
		data[0]: Parameter Name
		data[1]: ME Profile Name
		data[2]: Parameter Value		
		i    i   i   Ns3   DELETE FROM ME_SUBS_PROFILE_PARAMETER WHERE ID = %d(   R   R   R   R   R#   R$   R%   (   R   R
   R   R   R'   t   parameterIdR   R(   (    (    sp   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfileParameter.pyt   delete†   s    



c         C   s#   d | } | GH|  i  i | ƒ d S(   s;   
		Description: delete all the parameters of the profile
		s;   DELETE FROM ME_SUBS_PROFILE_PARAMETER WHERE PROFILE_ID = %dN(   R   R   (   R   R   R   (    (    sp   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfileParameter.pyt	   deleteAllž   s    
c         G   s   t  i  ƒ  i | ƒ S(   N(   t   MeSubsProfileR   (   R   R
   (    (    sp   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfileParameter.pyR   §   s    c         C   s-   | i  d ƒ p t S| d i ƒ  d j Sd  S(   Nt	   IS_DELETEt   true(   t   has_keyR   t   lower(   R   t   item(    (    sp   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfileParameter.pyt   getIsDeleteª   s    (   t   __name__t
   __module__t   __doc__R   R   R   R   R!   R)   R*   R,   R-   R   R4   (    (    (    sp   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfileParameter.pyR       s   											c          C   s    t  ƒ  }  |  i d d d ƒ d  S(   Nt   SDt   PackageTypet   MOD(   R    t   add(   t   meSubsPP(    (    sp   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfileParameter.pyt   main°   s    	t   __main__(   R   R.   R    R=   R5   (    (    (    sp   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfileParameter.pyt   <module>   s
   «	