Ñò
ýÉªWc           @   sb   d  d k  Z  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
   AlertNamesc           B   sY   e  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(    (    sd   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/AlertNames.pyR      s    c         C   sO   | d } |  i  i d | ƒ |  i  i ƒ  } t | ƒ o | d d St Sd  S(   Ni    s/   SELECT * FROM ALERT_NAMES WHERE ALERT_NAME='%s'(   t   cursort   executet   fetchallt   lent   False(   R   t   datat   keyt   rows(    (    sd   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/AlertNames.pyt   checkExistence   s    
c         C   s   d S(   Ni   (    (   R   (    (    sd   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/AlertNames.pyt	   getNextId   s    c         C   s„   | d } | d } t  i  ƒ  } y< d |  i | | g ƒ } | GH|  i i | ƒ |  i ƒ  SWn! t j
 o } | GH|  i ƒ  SXd S(   s>   
		data[0]: ALERT_NAME
		data[1]: PATTERN
		data[2]: ALERTS
		i    i   s7   INSERT INTO ALERT_NAMES (ALERT_NAME, PATTERN) VALUES %sN(   t   AlertActionst
   tupleToStrR   R   t   committ	   Exceptiont   rollback(   R   t   id_R	   t	   alertNamet   alertPatternt   aast	   statementt   e(    (    sd   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/AlertNames.pyt   insert   s    

c         C   s   | d } | d } y3 d | | f } | GH|  i  i | ƒ |  i ƒ  SWnA t j
 o } | GH|  i ƒ  St j
 o } | GH|  i ƒ  SXd S(   s>   
		data[0]: ALERT_NAME
		data[1]: PATTERN
		data[2]: ALERTS
		i    i   s;   UPDATE ALERT_NAMES SET PATTERN = '%s' WHERE ALERT_NAME='%s'N(   R   R   R   R   R   (   R   R	   R   R   R   R   (    (    sd   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/AlertNames.pyt   update2   s    

c   
      C   sã   | d } t  i  ƒ  } t i ƒ  } y™ d | } | GH|  i i | ƒ |  i i ƒ  } x; | D]3 } | d } | i | g ƒ | i | | g ƒ qZ Wd | } | GH|  i i | ƒ |  i ƒ  SWn! t j
 o }	 |	 GH|  i	 ƒ  SXd S(   s:    delete the alert and its actions
		data[0]: alert name
		i    s5   SELECT IDENTIFIER FROM ALERTS WHERE ALERT_NAME = '%s's-   DELETE FROM ALERT_NAMES WHERE ALERT_NAME='%s'N(
   R   t   Alertst   AlertPolicyForCMS3XR   R   R   t   deleteR   R   R   (
   R   R	   R   R   t   alsR   t   alertIdst   at   alertIdR   (    (    sd   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/AlertNames.pyR   K   s(    

 

c         C   s  t  i ƒ  } t i ƒ  } xù | D]ñ } | i | d | | d | d | d | d d |  i | ƒ ƒ y@ | d d  j	 o+ | i | d d | d |  i | ƒ ƒ n Wn t j
 o n Xy@ | d	 d  j	 o+ | i | d d
 | d	 |  i | ƒ ƒ n Wq t j
 o q Xq Wd  S(   Nt
   IDENTIFIERt   THRESH_COUNTt   THRESH_SECSt
   FREQ_COUNTt	   FREQ_SECSt   LOGt   EMAILi    t	   SNMP_TRAPi   (   R   R   R   t   handlet   getIsDeletet   Nonet   KeyError(   R   R   t   alertsR   R   R    (    (    sd   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/AlertNames.pyt   createAlertsh   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(    (    sd   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/AlertNames.pyR+   y   s    c         C   sF   d } t  | ƒ o+ |  i i | | d ƒ |  i i ƒ  } n | d S(   s^   
		Input:
			args[0]: ALERT_NAME
		Output:
			A sequence value of ["ALERT_NAME", "PATTERN"]
		sA   SELECT ALERT_NAME, PATTERN FROM ALERT_NAMES WHERE ALERT_NAME='%s'i    (   R   R   R   R   (   R   t   argsR   R   (    (    sd   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/AlertNames.pyt   backUpExisting   s
    (   t   __name__t
   __module__R   R   R   R   R   R   R/   R+   R6   (    (    (    sd   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/AlertNames.pyR       s   									c          C   s   t  ƒ  }  |  i d d ƒ d  S(   Nt   testNames   .*testPattern.*(   R    t   add(   t   an(    (    sd   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/AlertNames.pyt   main   s    	t   __main__(   R   R   R   R    R<   R7   (    (    (    sd   /home/jenkins/workspace/prepack-aio-release-4.2/prepack-aio/src/main/resources/scripts/AlertNames.pyt   <module>   s   ‡	