ó
<­^c           @   s{  d  Z  d d l Z d d l Z d d l Z d d l Z e Z e e j _ d e j d <e j	 j
 e j	 j e   d Z e j	 j d e  d d l Z d d l m Z e j Z e d k rÄ d	 Z n& e d k rŮ d Z n e j d e  e j d  Z e j e j  Z e j d  Z e j e  e j e  e j e j  d   Z  d   Z! d d d d  Z" d d d  Z$ d S(   s5   Library used by other scripts under tools/ directory.i˙˙˙˙Nt   Ct   LC_ALLs   /../i    (   t	   iredutilst   ldapt   mysqlt   pgsqlt   postgress    Error: Unsupported backend (%s).t	   iredadmins   * %(message)sc         C   s   d |  GHd  S(   Ns
   < ERROR > (    (   t   msg(    (    s1   /opt/www/iredadmin/tools/../tools/ira_tool_lib.pyt   print_error(   s    c         C   s  t  d k rb |  d k rb d d l m } | d t j d t j d t  } | d r[ | d	 Sd  Sn  y~ t j	 d
 t
 d t j |  d d t t j |  d  d t j |  d d t j |  d d t j |  d  } t | _ | SWn t k
 r˙ } t |  n Xd  S(   NR   t   vmaili˙˙˙˙(   t   verify_bind_dn_pwt   dnt   passwordt   close_connectioni    i   t   dbnt   hostt   _db_hostt   portt   _db_portt   dbt   _db_namet   usert   _db_usert   pwt   _db_password(   R   R
   (   t   backendt   libs.ldaplib.authR   t   settingst   ldap_bind_dnt   ldap_bind_passwordt   Falset   Nonet   webt   databaset   sql_dbnt   __dict__t   intt   Truet   supports_multiple_insertt	   ExceptionR	   (   R   R   t   qrt   connt   e(    (    s1   /opt/www/iredadmin/tools/../tools/ira_tool_lib.pyt   get_db_conn,   s&    		
	t    t   infoc         C   sa   t  d  } yG | j d d | d | d | d | d t |   d d	 d
 t j   Wn n Xd  S(   NR   t   logt   admint   usernamet   eventt   loglevelR   t   ips	   127.0.0.1t	   timestamp(   R,   t   insertt   strR   t   get_gmttimeR    (   R   R2   R0   R1   R3   R*   (    (    s1   /opt/www/iredadmin/tools/../tools/ira_tool_lib.pyt   log_to_iredadminF   s    t   idc         C   sa   | r( |  j  | d d | d | } n |  j  | d d | } | rW | d j } n d } | S(   Nt   whats   count(%s) as totalt   wherei    (   t   selectt   total(   R*   t   tablet   columnR<   R)   R>   (    (    s1   /opt/www/iredadmin/tools/../tools/ira_tool_lib.pyt   sql_count_idX   s    
(   R   R   (   R   (%   t   __doc__t   ost   syst   loggingR!   R   t   debugt   configt   environt   patht   abspatht   dirnamet   __file__t   rootdirR6   R   t   libsR   R   R#   t   exitt	   getLoggert   loggert   StreamHandlert   stdoutt   _cht	   Formattert
   _formattert   setFormattert
   addHandlert   setLevelt   INFOR	   R,   R9   R    RA   (    (    (    s1   /opt/www/iredadmin/tools/../tools/ira_tool_lib.pyt   <module>   s6   "					