B
    #5PaÛ
  ã               @   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	   ú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 | ¡}| |¡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)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  ¡ }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   	,