3
D€Ù`Ç  ã               @   s(   d dl mZ dd„ Zdd„ Zdd„ ZdS )	é    )Ú
sqlConnectc              C   s   t jƒ } d}| j|ƒ}|S )Nz€SELECT disease, disease_name, site_num, run_num, processed_num, valid_num, failed_num, species_num FROM mbodymap_phenotype_index)r   ÚMySQLConnectionÚquery)ÚconnectÚsql_phenotypesÚ
phenotypes© r   ú?/var/www/html/mybodymap/server/service/phenotypeIndexService.pyÚgetData   s    
r
   c          	   C   sà   t jƒ }dj| ƒ}|j|ƒ}g }xº|D ]²}dj| |d ƒ}|j|ƒd }d}d}	dj| |d ƒ}
|j|
ƒ}t|ƒ}x*|D ]"}|d dkr’|d7 }qx|	d7 }	qxW d	j|d | ƒ}|j|ƒd
 }|j|d ||||	|dœƒ q&W |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))ÚsiteÚrun_numÚprocessed_numÚ	valid_numZ
failed_numÚspecies_num)r   r   Úformatr   ÚqueryOneÚlenÚappend)Údiseaser   Ú	sql_sitesZsitesÚsite_resultr   Úsql_runsÚruns_numÚvalidÚfailedÚsql_loaded_runsÚloaded_runsr   Ú
loaded_runÚsql_speciesÚspeciesr   r   r	   Ú
detailData   s:    





r$   c             C   s$   t jƒ }dj| ƒ}|j|ƒd }|S )Nz)SELECT term FROM mesh_data WHERE uid="{}"Úterm)r   r   r   r   )r   r   Úsql_nameÚnamer   r   r	   ÚgetName1   s    
r(   N)Úutilsr   r
   r$   r(   r   r   r   r	   Ú<module>   s   &