3
‹FQaÛ
  ã               @   s(   d dl mZ dd„ Zdd„ Zdd„ ZdS )	é    )Ú
sqlConnectc              C   s0   t jƒ } d}| j|ƒ}d}| j|ƒ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 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
 }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)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ÚvalidÚfailedÚsql_loaded_runsÚloaded_runsr   Ú
loaded_runÚsql_speciesÚspeciesÚsql_associationr   r	   r	   r
   Ú
detailData   sB    





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
   ÚgetName9   s    
r*   N)Úutilsr   r   r&   r*   r	   r	   r	   r
   Ú<module>   s   	,