B
    vGÔ`Ç  ã               @   s(   d dl mZ dd„ Zdd„ Zdd„ ZdS )	é    )Ú
sqlConnectc              C   s   t  ¡ } d}|  |¡}|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   úXC:\Users\Administrator\Desktop\mbodymap\mbodymap-server\service\phenotypeIndexService.pyÚgetData   s    
r
   c          
   C   sà   t  ¡ }d | ¡}| |¡}g }xº|D ]²}d | |d ¡}| |¡d }d}d}	d | |d ¡}
| |
¡}t|ƒ}x*|D ]"}|d dkr’|d7 }qx|	d7 }	qxW d	 |d | ¡}| |¡d
 }| |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  ¡ }d | ¡}| |¡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   &