o
    ‹FQaÛ
  ã                   @   s(   d dl mZ dd„ Zdd„ Zdd„ ZdS )	é    )Ú
sqlConnectc                  C   s0   t  ¡ } d}|  |¡}d}|  |¡d }||fS )Nz‹SELECT disease, disease_name, site_num, run_num, processed_num, valid_num, failed_num, species_num, genus_num FROM mbodymap_phenotype_indexz@SELECT COUNT(1) FROM mbodymap_phenotype_index WHERE valid_num!=0zCOUNT(1))r   ÚMySQLConnectionÚqueryÚqueryOne)ÚconnectÚsql_phenotypesÚ
phenotypesZsql_phenotypesWithValidRunsZtotal_valid© r	   ú?/var/www/html/mybodymap/server/service/phenotypeIndexService.pyÚgetData   s   
r   c                 C   sø   t  ¡ }d | ¡}| |¡}g }|D ]g}d | |d ¡}| |¡d }d}d}	d | |d ¡}
| |
¡}t|ƒ}|D ]}|d dkrG|d7 }q:|	d7 }	q:d	 |d | ¡}| |¡d
 }d |d | ¡}| |¡d }| |d ||||	||dœ¡ q|S )NzASELECT DISTINCT BodySite FROM mbodymap_samples WHERE disease="{}"zZSELECT COUNT(run_id) run_id_num FROM mbodymap_samples WHERE disease="{}" AND BodySite="{}"ÚBodySiteÚ
run_id_numr   zžSELECT accession_id,QCStatus,uid FROM mbodymap_loaded_samples WHERE accession_id IN (SELECT run_id From mbodymap_samples WHERE disease="{}" AND BodySite="{}")ÚQCStatusé   zjSELECT COUNT(DISTINCT ncbi_taxon_id) from mbodymap_species_to_samples WHERE BodySite="{}" AND disease="{}"zCOUNT(DISTINCT ncbi_taxon_id)zbselect association from mbodymap_bodysite_disease_association where bodysite="{}" and disease="{}"Úassociation)ÚsiteÚrun_numÚprocessed_numÚ	valid_numZ
failed_numÚspecies_numr   )r   r   Úformatr   r   ÚlenÚappend)Údiseaser   Ú	sql_sitesZsitesÚsite_resultr   Úsql_runsÚruns_numÚvalidZfailedÚsql_loaded_runsÚloaded_runsr   Ú
loaded_runÚsql_speciesÚspeciesÚsql_associationr   r	   r	   r
   Ú
detailData   sL   

ÿÿ


ÿÿ
ù	r%   c                 C   s$   t  ¡ }d | ¡}| |¡d }|S )Nz)SELECT term FROM mesh_data WHERE uid="{}"Úterm)r   r   r   r   )r   r   Úsql_nameÚnamer	   r	   r
   ÚgetName9   s   
r)   N)Úutilsr   r   r%   r)   r	   r	   r	   r
   Ú<module>   s    	,