o
    FQa8                     @   s0   d dl mZ dd Zdd Zdd Zdd	 Zd
S )    )
sqlConnectc              	   C      t  }d|}||d }d||}||d }d||}||d }	d||}
||
d }d	||| }||d
 }d| }||d }d|}||d }|||d|d|	d|d|d}|S )N)SELECT note FROM mesh_data WHERE uid="{}"noteTSELECT COUNT(1) run_total FROM mbodymap_samples WHERE disease="{}" AND BodySite="{}"	run_totalSELECT COUNT(1) run_processed FROM mbodymap_samples t1, mbodymap_loaded_samples t2 WHERE disease="{}" AND BodySite="{}" AND t1.run_id=t2.accession_idrun_processedSELECT COUNT(1) run_valid FROM mbodymap_samples t1, mbodymap_loaded_samples t2 WHERE disease="{}" AND BodySite="{}" AND t1.run_id=t2.accession_id AND t2.QCStatus=1	run_validztSELECT loaded_uid_num_QC1 FROM mbodymap_species_to_samples WHERE disease="{}" AND BodySite="{}" AND ncbi_taxon_id={}loaded_uid_num_QC16select name from biosql_taxon_2 where ncbi_taxon_id={}name)select term from mesh_data where uid="{}"term{:,}species_namedisease_namedesc_diseaseintro_disease_totalintro_disease_processedintro_disease_validintro_species_inDisease_validr   MySQLConnectionformatqueryOnencbi_taxon_idsitediseaseconnectZsql_desc_diseaser   Zsql_intro_disease_totalr   Zsql_intro_disease_processedr   Zsql_intro_disease_validr   Z!sql_intro_species_inDisease_validr   Zsql_species_namer   sql_disease_namer   result r%   @/var/www/html/mybodymap/server/service/taxonsFinalPageService.pygetSpeciesIntroData   @   


	r'   c                 C   s8  t  }|dkr|g}nd|g}g }g }d||| }||d }t|dk r/g g d}	|	S |D ]}
d|
|}||d }d|
}||d }d	| ||
}||}|d u r_d
}n||d }d||
| }||}t|}|d d
kr|d7 }n|d7 }g }|dkrtdddD ]}|| qntd|d dD ]}|| qg }g }|D ]%}d
}|D ]}||d  |d |kr|d7 }q||t| d  q|
dkr|d|||dddiddid |d||dddddiddid q1|d|||dd |d||ddd q1||d}	|	S )ND006262SELECT COUNT(1) total FROM mbodymap_relative_species_abundances t1, mbodymap_samples t2, mbodymap_loaded_samples t3 WHERE t2.BodySite="{}" AND t2.disease="{}" AND t2.run_id=t3.accession_id AND t1.loaded_uid=t3.uid AND t1.ncbi_taxon_id={}total
   linePlotboxPlotSELECT COUNT(1) total FROM mbodymap_samples t1, mbodymap_loaded_samples t2 WHERE disease="{}" AND BodySite="{}" AND t1.run_id=t2.accession_id AND t2.QCStatus=1)SELECT term FROM mesh_data WHERE uid="{}"r   zxSELECT relative_abundance_max FROM mbodymap_species_to_samples WHERE ncbi_taxon_id={} AND BodySite="{}" AND disease="{}"r   relative_abundance_maxSELECT t1.relative_abundance ra FROM mbodymap_relative_species_abundances t1, mbodymap_samples t2, mbodymap_loaded_samples t3 WHERE t2.BodySite="{}" AND t2.disease="{}" AND t2.run_id=t3.accession_id AND t1.loaded_uid=t3.uid AND t1.ncbi_taxon_id={}      d   e   rascatterlines+markerscolorgreentypexyr   modemarkerlineboxOutliers      ?r>   r?   r   	boxpointswidth	fillcolorrB   rC   r>   r?   r@   r   rA   r>   r?   r   rH   rI   )r   r   r   r   intqueryrangeappendr   r    r!   r"   ZdiseaseListlinePlot_resultsboxPlot_resultsZsql_runs_totalZ
runs_totalresultsitem"sql_total_disease_of_taxon_in_sitetotal_disease_of_taxon_in_siter#   r   Z
sql_max_raZmax_rasql_all_reiative_abundanceall_reiative_abundancemax_relative_abundanceroundXiroundY	box_valuerule
rule_valuerelative_abundancer%   r%   r&   getSpeciesPlotData'   s   \





rb   c              	   C   r   )Nr   r   r   r   r   r	   r
   r   zrSELECT loaded_uid_num_QC1 FROM mbodymap_genus_to_samples WHERE disease="{}" AND BodySite="{}" AND ncbi_taxon_id={}r   r   r   r   r   r   r   r   r   r%   r%   r&   getGenusIntroData   r(   rc   c                 C   sB  t  }|dkr|g}nd|g}g }g }d||| }||d }t|dk r/g g d}	|	S |D ]}
d|
|}||d }d|
}||d }d	| ||
}t| ||}|d u rcd
}n||d }d||
| }||}t|}|d d
kr|d7 }n|d7 }g }|dkrtdddD ]}|| qntd|d dD ]}|| qg }g }|D ]%}d
}|D ]}||d  |d |kr|d7 }q||t| d  q|
dkr|d|||dddiddid |d||dddddiddid q1|d|||dd |d||ddd q1||d}	|	S )Nr)   r*   r+   r,   r-   r0   r1   r   zvSELECT relative_abundance_max FROM mbodymap_genus_to_samples WHERE ncbi_taxon_id={} AND BodySite="{}" AND disease="{}"r   r2   r3   r4   r5   r6   r7   r8   r9   r:   r;   r<   r=   rD   rE   rF   rG   rK   rL   )	r   r   r   r   rM   printrN   rO   rP   rQ   r%   r%   r&   getGenusPlotData   s   \






re   N)utilsr   r'   rb   rc   re   r%   r%   r%   r&   <module>   s
    #l$