3
D`                 @   s    d dl mZ dd Zdd ZdS )    )
sqlConnectc           	   C   s   t j } d}| j|}d}| j|}d}| j|}| j  |d |d t|d t|d t|d t|d	 |d
 |d d}|S )NzSELECT FORMAT(COUNT(DISTINCT ncbi_taxon_id),0) species_num, FORMAT(COUNT(DISTINCT disease),0) disease_num FROM mbodymap_species_to_sampleszSELECT SUM(run_num) run_num, SUM(loaded_run_num) loaded_run_num, SUM(QC_0_num) QC_0_num, SUM(QC_1_num) QC_1_num, COUNT(DISTINCT BodySite) site_num FROM mbodymap_introuM   SELECT COUNT(DISTINCT `NCBI Project ID`) project_num FROM mbodymap_projectsspecies_numdisease_numrun_numloaded_run_numQC_0_numQC_1_numsite_numproject_num)r   r   r   r   r   r   r	   r
   )r   MySQLConnectionZqueryOnecloseint)connectZsqlIntroZspeciesAndDiseaseNumZsqlTotaltotalZsqlProjectsr
   result r   9/var/www/html/mybodymap/server/service/homePageService.py	introData   s"    






r   c           	   C   s  t j } d } } } } } } }}dddg}	ddg}
g }d}| j|}xL|D ]B}|d }d	| }| j|}d }}x*|D ]"}|d
 dkr|d7 }q|d7 }qW ||	kr
||7 }||7 }||d 7 }|d7 }|t|	kr|jddj|dj||||d qT||
krl||7 }||7 }||d 7 }|d7 }|t|
kr|jddj|dj||||d qT|j|d dj|dj||||d d qTW |S )Nr   ZRectumZColonZCecumZIleumZDuodenumz,SELECT BodySite, run_num FROM mbodymap_introZBodySitez8SELECT disease FROM mbodymap_samples WHERE BodySite="%s"ZdiseaseZD006262   r   zLarge intestinez{:,})siteZnormalStringZabnormalStringnormalabnormalZrun_num_totalzSmall intestine)r   r   querylenappendformat)r   Z
largeTotalZ
smallTotalZlargeNZlargeAnZsmallNZsmallAnlsZlargeZsmallr   Z	sql_sitesZfindSiteitemr   Zsql_diseaseZfindDiseaser   r   itr   r   r   picAndTblData   sd     






r    N)utilsr   r   r    r   r   r   r   <module>   s   