3 C€Ù`¤ã@s0ddlmZdd„Zdd„Zdd„Zdd „Zd S) é)Ú sqlConnectc Cshtjƒ}dj|ƒ}|j|ƒ}||dt|dƒdjt|dƒƒdjt|dƒƒdjt|dƒƒdœ}|S) NzÝSELECT name, COUNT(DISTINCT BodySite) site_num, COUNT(DISTINCT disease) disease_num, SUM(loaded_uid_num) total_runs, SUM(loaded_uid_num_QC1) valid_runs FROM mbodymap_species_to_samples WHERE ncbi_taxon_id={} GROUP BY nameÚnameÚsite_numz{:,}Ú total_runsÚ valid_runsÚ disease_num)Ú ncbi_taxon_idrrrrr)rÚMySQLConnectionÚformatÚqueryOneÚint)rÚconnectÚ sql_introÚintroÚresult©rú=/var/www/html/mybodymap/server/service/taxonsToSiteService.pyÚgetSpeciesIntros  rcCs$tjƒ}dj|||ƒ}|j|ƒ}|S)Nz_SELECT * FROM mbodymap_species_to_site_relative_abundance WHERE ncbi_taxon_id={} ORDER BY {} {})rr r Úquery)rÚpropNameÚ propOrderr ÚsqlrrrrÚgetSpeciesDatas   rc Cshtjƒ}dj|ƒ}|j|ƒ}||dt|dƒdjt|dƒƒdjt|dƒƒdjt|dƒƒdœ}|S) NzÛSELECT name, COUNT(DISTINCT BodySite) site_num, COUNT(DISTINCT disease) disease_num, SUM(loaded_uid_num) total_runs, SUM(loaded_uid_num_QC1) valid_runs FROM mbodymap_genus_to_samples WHERE ncbi_taxon_id={} GROUP BY namerrz{:,}rrr)rrrrrr)rr r r r )rr rrrrrrÚ getGenusIntros  rcCs$tjƒ}dj|||ƒ}|j|ƒ}|S)Nz]SELECT * FROM mbodymap_genus_to_site_relative_abundance WHERE ncbi_taxon_id={} ORDER BY {} {})rr r r)rrrr rrrrrÚ getGenusData.s   rN)ÚutilsrrrrrrrrrÚs