;ò
î¸ŭCc           @   si   d  k  Td k l Z e   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z	 d	   Z
 d
 S(   (   s   *(   s   DateTimec         C   ss   |  t j p t t |    d j o d Sn |  d j o |  Sn d t t t t |    d d  d d  Sd  S(   Ns   NULLs   now()s   '%s's   \'s   's   ''(   s   values   Nones   uppers   strs   replaces   strip(   s   value(    (    s   sqlcommon.pys	   sqlFilter   s
    &c         C   sc   |  t j p |  d j p
 |  d j o t Sn |  d d j o t |  d d !d d  Sn |  Sd  S(   Ns    s   NULLi    s   'i   i˙˙˙˙s   ''(   s   values   Nones   replace(   s   value(    (    s   sqlcommon.pys   unSqlFilter   s
    'c         C   sm   h  d d <d d <} xJ | i   D]< } t |  |  d j o  t t |  |  | |  }  q% q% W|  Sd  S(   Ns   's   ''s   \s   \\i    (   s
   quote_dicts   keyss   dkeys   finds   vs   joins   split(   s   vs   dkeys
   quote_dict(    (    s   sqlcommon.pys	   sql_quote   s     $c         C   s˘   d } x |  i   D] \ } } t |  t t  j o/ d | } t |  d j o | d  } qg n | t j	 o | d | t	 |  f 7} q q W| d  Sd S(   sP   
	Retourne la chaine prop1='val1',...,propn='valn'
	(pour construire l'update)
	s    s   %si
   iú˙˙˙s   %s=%s,i˙˙˙˙N(
   s   ress   dicts   itemss   keys   values   types   const_dateTimes   lens   Nones	   sqlFilter(   s   dicts   ress   values   key(    (    s   sqlcommon.pys   names_values_for_update   s      
"c         C   s   d t  |  i   d  Sd S(   sD   
	Retourne la chaine (prop1,...,propn)
	(pour construire l'insert)
	s   (%s)s   ,N(   s   joins   dicts   keys(   s   dict(    (    s   sqlcommon.pys   names_for_insert+   s     c         C   s   d } xp |  i   D]b } t |  t t  j o/ d | } t |  d j o | d  } qa n | d t |  7} q W| d  d Sd S(	   sH   
	Retourne la chaine ('value1',...,valuen)
	(pour construire l'insert)
	s   (s   %si
   iú˙˙˙s   %s,i˙˙˙˙s   )N(   s   ress   dicts   valuess   values   types   const_dateTimes   lens	   sqlFilter(   s   dicts   ress   value(    (    s   sqlcommon.pys   values_for_insert2   s      
c         C   s!   d |  t |  t |  f Sd S(   s!   
	construit la requete d'insert
	s   insert into %s %s values %s;N(   s   tables   names_for_inserts   dicts   values_for_insert(   s   tables   dict(    (    s   sqlcommon.pys
   sql_insertA   s     c         C   s   d |  t |  | d f Sd S(   s!   
	construit la requete d'update
	s   update %s set %s where uid=%s;s   uidN(   s   tables   names_values_for_updates   dict(   s   tables   dict(    (    s   sqlcommon.pys
   sql_updateG   s     N(   s   strings   DateTimes   const_dateTimes	   sqlFilters   unSqlFilters	   sql_quotes   names_values_for_updates   names_for_inserts   values_for_inserts
   sql_inserts
   sql_update(
   s   names_values_for_updates   const_dateTimes   DateTimes   names_for_inserts
   sql_updates	   sqlFilters
   sql_inserts   values_for_inserts	   sql_quotes   unSqlFilter(    (    s   sqlcommon.pys   ?   s   								
