website.py 文件源码

def POST(self):
        form = search_form()
        form.validates()

        usr_in = form['term_id'].value
        in_sample_type = form["sample_type"].value
        term_ids = get_searched_term_ids(usr_in)

        metasra_db = web.database(dbn='sqlite', db='static/metasra.sqlite')

        tsv_str = "sample_accession\tstudy_accession\tmapped_ontology_terms\tsample_type\tsample_type_confidence\n"
        n_results = 0
        for term_id in term_ids:
            if in_sample_type == "all":
                results = query_metasra.query_metasra_for_term(metasra_db, term_id)
            else:
                results = query_metasra.query_metasra_for_term(metasra_db, term_id, sample_type=in_sample_type)

            for r in results:
                n_results += 1
                sample_acc = r["sample_accession"]
                study_acc = r["study_accession"]
                r_sample_type = r["sample_type"]
                r_terms_csv = r["sample_terms_csv"]
                confidence = r["confidence"]
                tsv_str += "%s\t%s\t%s\t%s\t%0.3f\n" % (sample_acc, study_acc, r_terms_csv, r_sample_type, confidence)
        tsv_str = tsv_str[:-1] # remove trailing line-break
        print "Returning %d results" % n_results
        return tsv_str