ó
gbc           @   sO   d  Z  d d l m Z d d l m Z d d l m Z d d l Z d   Z d S(   s,   
Created on 25 sept. 2010

@author: coissac
i˙˙˙˙(   t   NucSequence(   t   progressBar(   t   alreadyIdentifiedNc         c   sö   |  j  j   } | j d |  j  | j } t d | t d |  j x£ | D] \ } } } t | j d | d |  j |  j	 s t
 | |   rÍ t | |  } | | d <t j d I| j d I| VqL t j d I| j d IqL Wt j Jd  S(   Ns>  
                      select s.id,sum(o.count),s.sequence
                      from rawdata.sequence      s,
                           rawdata.occurrences   o
                      where o.sequence= s.id
                        and s.primers = '%s'
                      group by s.id,s.sequence
                   i   t   headt   counts    +s    @(   t   ecobarcodedbt   cursort   executet   primert   rowcountR   t   Truet   dbnamet	   rownumbert   updatedbR   R    t   syst   stderr(   t   optionsR   t   nbseqt   idR   t   sequencet   s(    (    s:   lib/python2.7/site-packages/obitools/ecobarcode/rawdata.pyt   sequenceIterator   s    	
(	   t   __doc__t   obitoolsR    t   obitools.utilsR   t   obitools.ecobarcode.ecotagR   R   R   (    (    (    s:   lib/python2.7/site-packages/obitools/ecobarcode/rawdata.pyt   <module>   s
   