Ńň
ýÉŞ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   ContentClassPartnersc           B   s>   e  Z d    Z d   Z d   Z d   Z d   Z d   Z RS(   c         C   s&   t  i  i |   d |  _ d |  _ d  S(   Ns   PROVIDERID, CONTENTCLASSNAMEsĚ   SELECT P.PROVIDERID AS PROVIDERID, CC.NAME AS CONTENTCLASSNAME FROM PMM_CONTENT_CLASS_PARTNER CCP JOIN PMM_CONTENT_CLASS CC ON (CCP.CONTENT_CLASS_ID = CC.ID) JOIN PMM_PARTNER P ON (CCP.PARTNER_ID = P.ID_)(   t	   BaseClasst   __init__t   columnst   selectStatement(   t   self(    (    sn   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ContentClassPartners.pyR      s    	c         C   s   t  i    i | d f  |  _ |  i i d | d  |  i i   d d |  _ |  i i d |  i |  i f  t |  i i    o t St	 Sd S(   s,   checkExistence(providerId, contentClassName)i    s0   SELECT ID FROM PMM_CONTENT_CLASS WHERE NAME='%s'i   sS   SELECT * FROM PMM_CONTENT_CLASS_PARTNER WHERE CONTENT_CLASS_ID=%s AND PARTNER_ID=%sN(
   t   Partnerst   checkExistencet	   partnerIdt   cursort   executet   fetchallt   contentClassIdt   lent   Truet   False(   R   t   data(    (    sn   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ContentClassPartners.pyR      s     c         C   s   d S(   Ni   (    (   R   (    (    sn   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ContentClassPartners.pyt	   getNextId   s    c         C   sj   yB d |  i  |  i |  i g  } | GH|  i i |  |  i   SWn! t j
 o } | GH|  i   SXd  S(   NsN   INSERT INTO PMM_CONTENT_CLASS_PARTNER (CONTENT_CLASS_ID, PARTNER_ID) VALUES %s(   t
   tupleToStrR   R   R	   R
   t   committ	   Exceptiont   rollback(   R   t   id_R   t	   statementt   e(    (    sn   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ContentClassPartners.pyt   insert    s    c         C   s   d  S(   N(    (   R   R   (    (    sn   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ContentClassPartners.pyt   update+   s    c         C   sw   t  i    i | d f  |  _ y0 d |  i } | GH|  i i |  |  i   SWn! t j
 o } | GH|  i   SXd S(   s    
		data[0]: providerId
		i    s9   DELETE FROM PMM_CONTENT_CLASS_PARTNER WHERE PARTNER_ID=%sN(   R   R   R   R	   R
   R   R   R   (   R   R   R   R   (    (    sn   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ContentClassPartners.pyt   delete/   s    (   t   __name__t
   __module__R   R   R   R   R   R   (    (    (    sn   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ContentClassPartners.pyR       s   					c          C   s   t    }  |  i d  d  S(   Ns   /tmp/ccp.tdf(   R    t   export(   t   ccp(    (    sn   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ContentClassPartners.pyt   main?   s    	t   __main__(   R   R   R    R    R   (    (    (    sn   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/ContentClassPartners.pyt   <module>   s
   :	