Ñò
ýÉª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   SelectorKeysc           B   sG   e  Z d  „  Z d „  Z d „  Z d „  Z d „  Z d „  Z d „  Z RS(   c         C   s/   t  i  i |  ƒ d |  _ d |  _ d |  _ d  S(   Ns!   SELECTIONKEY, PROCESSDEFINITIONIDt   TTV_SELECTORsv   SELECT S.SELECTIONKEY, PD.NAME_ FROM TTV_SELECTOR S JOIN JBPM_PROCESSDEFINITION PD ON (S.PROCESSDEFINITIONID = PD.ID_)(   t	   BaseClasst   __init__t   columnst   tablet   selectStatement(   t   self(    (    sf   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SelectorKeys.pyR   
   s    		c         C   sO   | d } |  i  i d | ƒ |  i  i ƒ  } t | ƒ o | d d St Sd  S(   Ni    s2   SELECT * FROM TTV_SELECTOR WHERE SELECTIONKEY='%s'(   t   cursort   executet   fetchallt   lent   False(   R   t   datat   keyt   rows(    (    sf   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SelectorKeys.pyt   checkExistence   s    
c         C   s   d S(   Ni   (    (   R   (    (    sf   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SelectorKeys.pyt	   getNextId   s    c         C   sŠ   yb t  i  ƒ  i t | d g ƒ ƒ } d |  i | d | g ƒ } | GH|  i i | ƒ |  i ƒ  SWn! t j
 o } | GH|  i ƒ  SXd  S(   Ni   sF   INSERT INTO TTV_SELECTOR (SELECTIONKEY, PROCESSDEFINITIONID) VALUES %si    (	   t   ProcessDefinitionsR   t   tuplet
   tupleToStrR   R	   t   committ	   Exceptiont   rollback(   R   t   id_R   t   processDefinitionIdt	   statementt   e(    (    sf   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SelectorKeys.pyt   insert"   s    "c         C   s—   yo |  i  | ƒ t i ƒ  i t | d g ƒ ƒ } d |  i | d | g ƒ } | GH|  i i | ƒ |  i ƒ  SWn! t j
 o } | GH|  i	 ƒ  SXd  S(   Ni   sF   INSERT INTO TTV_SELECTOR (SELECTIONKEY, PROCESSDEFINITIONID) VALUES %si    (
   t   deleteR   R   R   R   R   R	   R   R   R   (   R   R   R   R   R   (    (    sf   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SelectorKeys.pyt   update.   s    "c         C   s_   y7 | d } d | } | GH|  i  i | ƒ |  i ƒ  SWn! t j
 o } | GH|  i ƒ  SXd S(   sl   delete the association between selector keys and template
		data[0]: selctor key
		data[1]: template name
		i    s0   DELETE FROM TTV_SELECTOR WHERE SELECTIONKEY='%s'N(   R   R	   R   R   R   (   R   R   R   R   R   (    (    sf   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SelectorKeys.pyR   ;   s    

c         C   sZ   | d  j p t | ƒ o d  Sd | d } | GH|  i i | ƒ |  i i ƒ  } | d S(   Nsz   SELECT SELECTIONKEY, NAME_ FROM TTV_SELECTOR,JBPM_PROCESSDEFINITION WHERE PROCESSDEFINITIONID = ID_ AND SELECTIONKEY ='%s'i    (   t   NoneR   R   R	   R
   (   R   t   argsR   R   (    (    sf   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SelectorKeys.pyt   backUpExistingL   s    (	   t   __name__t
   __module__R   R   R   R   R   R   R!   (    (    (    sf   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SelectorKeys.pyR       s   							c          C   s   t  ƒ  }  |  i d ƒ d  S(   Ns   /tmp/selectorkeys.tdf(   R    t   export(   t   sk(    (    sf   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SelectorKeys.pyt   mainV   s    	t   __main__(   R   R   R    R&   R"   (    (    (    sf   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/SelectorKeys.pyt   <module>   s
   Q	