Ñò
ýÉªWc           @   sŠ   d  d k  Z  d  d k l Z d  d k l Z d  d k l Z d  d k l Z d e  i  f d „  ƒ  YZ d „  Z e d	 j o e ƒ  n d S(
   iÿÿÿÿN(   t   MeIdentifierCriteria(   t   MeEnhancedField(   t   MeSubsProfileParameter(   t   MeFieldDefinitiont   MeSubsProfilec           B   sb   e  Z d  „  Z d „  Z d „  Z d „  Z d „  Z d „  Z d „  Z d „  Z	 d „  Z
 d	 „  Z RS(
   c         C   s   t  i  i |  ƒ d  S(   N(   t	   BaseClasst   __init__(   t   self(    (    sg   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfile.pyR      s    c         C   sO   | d } |  i  i d | ƒ |  i  i ƒ  } t | ƒ o | d d St Sd  S(   Ni    s.   SELECT ID FROM ME_SUBS_PROFILE WHERE NAME='%s'(   t   cursort   executet   fetchallt   lent   False(   R   t   datat   namet   rows(    (    sg   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfile.pyt   checkExistence   s    
c         C   sL   |  i  i d | ƒ |  i  i ƒ  } d } t | ƒ o | d d } n | S(   sl   
		returns the profile name of the given profile id. If no profile found,
		then returns an empty string.
		s,   SELECT NAME FROM ME_SUBS_PROFILE WHERE ID=%dt    i    (   R   R	   R
   R   (   R   t	   profileIdR   t   profileName(    (    sg   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfile.pyt   getProfileNameById   s    c         C   s   |  i  | g ƒ S(   sb   
		returns the profile id of the given profile name. If no profile found,
		then returns False.
		(   R   (   R   R   (    (    sg   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfile.pyt   getProfileIdByName(   s    c         C   s   d S(   Ni   (    (   R   (    (    sg   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfile.pyt	   getNextId/   s    c         C   sW   | d } d | } |  i  i | ƒ |  i  i ƒ  } t | ƒ d j o g  S| d Sd S(   s[   
		data[0]: NAME
		
		output: return the (NAME, PLUGIN_NAME) of the give ME profile name
		i    s?   SELECT NAME, PLUGIN_NAME FROM ME_SUBS_PROFILE WHERE NAME = '%s'N(   R   R	   R
   R   (   R   R   R   t	   statementR   (    (    sg   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfile.pyt   backUpExisting2   s    

c         C   sx   | d } | d } y< d |  i  | | g ƒ } | GH|  i i | ƒ |  i ƒ  SWn! t j
 o } | GH|  i ƒ  SXd S(   s*   
		data[0]: NAME
		data[1]: PLUGIN_NAME
		i    i   s9   INSERT INTO ME_SUBS_PROFILE (NAME, PLUGIN_NAME) VALUES %sN(   t
   tupleToStrR   R	   t   committ	   Exceptiont   rollback(   R   t   id_R   R   t
   pluginNameR   t   e(    (    sg   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfile.pyt   insertC   s    

c         C   so   | d } | d } y3 d | | f } | GH|  i  i | ƒ |  i ƒ  SWn! t j
 o } | GH|  i ƒ  SXd S(   s*   
		data[0]: NAME
		data[1]: PLUGIN_NAME
		i    i   s=   UPDATE ME_SUBS_PROFILE SET PLUGIN_NAME = '%s' WHERE NAME='%s'N(   R   R	   R   R   R   (   R   R   R   R   R   R   (    (    sg   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfile.pyt   updateX   s    

c         C   sâ   | d } | d } |  i  | ƒ } | t j o d Sy… t ƒ  } | i | ƒ t ƒ  } | i | ƒ t ƒ  } | i | ƒ t ƒ  } | i | ƒ d | }	 |	 GH|  i i	 |	 ƒ |  i
 ƒ  SWn! t j
 o }
 |
 GH|  i ƒ  SXd S(   s*   
		data[0]: NAME
		data[1]: PLUGIN_NAME
		i    i   Ns)   DELETE FROM ME_SUBS_PROFILE WHERE ID = %d(   R   R   R    t	   deleteAllR   R   t   deleteByProfileR   R   R	   R   R   R   (   R   R   R   R   R   t   criteriaFieldt   enhanceFieldt   fieldDefinitiont
   parametersR   R   (    (    sg   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfile.pyt   deletek   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(    (    sg   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfile.pyt   getIsDelete’   s    (   t   __name__t
   __module__R   R   R   R   R   R   R    R!   R(   R.   (    (    (    sg   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfile.pyR   	   s   										'c          C   s   t  ƒ  }  |  i d d ƒ d  S(   Nt   testMeProfileNamet   testMePlugin(   R   t   add(   t   profile(    (    sg   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfile.pyt   main˜   s    	t   __main__(   R   R    R   R   R   R   R5   R/   (    (    (    sg   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/MeSubsProfile.pyt   <module>   s   	