From 3b03ce957c0469420ab591b4f3568f9298e8e02e Mon Sep 17 00:00:00 2001 From: Sam Ockman Date: Thu, 5 Jul 2012 18:41:14 -0400 Subject: Before changing data_sharing template --- wqflask/wqflask/dataSharing/SharingInfo.py | 26 ++++++++++++++++++++++++-- wqflask/wqflask/views.py | 8 +++++--- 2 files changed, 29 insertions(+), 5 deletions(-) diff --git a/wqflask/wqflask/dataSharing/SharingInfo.py b/wqflask/wqflask/dataSharing/SharingInfo.py index 018121c8..28149088 100755 --- a/wqflask/wqflask/dataSharing/SharingInfo.py +++ b/wqflask/wqflask/dataSharing/SharingInfo.py @@ -27,6 +27,7 @@ from __future__ import print_function, division from pprint import pformat as pf +from collections import namedtuple import httplib @@ -48,7 +49,21 @@ class SharingInfo(object): cursor = webqtlDatabaseFunction.getCursor() if (not cursor): return - sql = "select Id, GEO_Series, Status, Title, Organism, Experiment_Type, Summary, Overall_Design, Contributor, Citation, Submission_Date, Contact_Name, Emails, Phone, URL, Organization_Name, Department, Laboratory, Street, City, State, ZIP, Country, Platforms, Samples, Species, Normalization, InbredSet, InfoPageName, DB_Name, Organism_Id, InfoPageTitle, GN_AccesionId, Tissue, AuthorizedUsers, About_Cases, About_Tissue, About_Download, About_Array_Platform, About_Data_Values_Processing, Data_Source_Acknowledge, Progreso from InfoFiles where " + + field_names = """Id, GEO_Series, Status, Title, Organism, Experiment_Type, + Summary, Overall_Design, Contributor, Citation, Submission_Date, + Contact_Name, Emails, Phone, URL, Organization_Name, Department, + Laboratory, Street, City, State, ZIP, Country, Platforms, + Samples, Species, Normalization, InbredSet, InfoPageName, + DB_Name, Organism_Id, InfoPageTitle, GN_AccesionId, Tissue, + AuthorizedUsers, About_Cases, About_Tissue, About_Download, + About_Array_Platform, About_Data_Values_Processing, + Data_Source_Acknowledge, Progreso """ + + InfoRecord = namedtuple('InfoRecord', field_names) + + # We can use string interpolation here cause we own the string + sql = """select %s from InfoFiles where """ % (field_names) if(self.GN_AccessionId): sql += "GN_AccesionId = %s" cursor.execute(sql, self.GN_AccessionId) @@ -58,6 +73,12 @@ class SharingInfo(object): else: raise 'No correct parameter found' info = cursor.fetchone() + print("432 info:", info) + print("type(info):", type(info)) + info = InfoRecord._make(info) + + print("q888 info.Title:", info.Title) + # fetch datasets file list try: conn = httplib.HTTPConnection("atlas.uthsc.edu") @@ -102,4 +123,5 @@ class SharingInfo(object): htmlfilelist = "Data sets are not available or are not public yet." print("333 info is:", pf(info)) print("333 keys:", pf(info)) - return SharingBody.sharinginfo_body_string % (info[31], info[32], infoupdate, info[32], info[1], info[3], info[30], info[4], info[27], info[33], info[2], info[23], info[26], info[11], info[15], info[16], info[18], info[19], info[20], info[21], info[22], info[13], info[12], info[14], info[14], htmlfilelist, info[6], info[35], info[36], info[37], info[38], info[39], info[40], info[5], info[7], info[8], info[9], info[10], info[17], info[24]) + return info, htmlfilelist + #return SharingBody.sharinginfo_body_string % (info[31], info[32], infoupdate, info[32], info[1], info[3], info[30], info[4], info[27], info[33], info[2], info[23], info[26], info[11], info[15], info[16], info[18], info[19], info[20], info[21], info[22], info[13], info[12], info[14], info[14], htmlfilelist, info[6], info[35], info[36], info[37], info[38], info[39], info[40], info[5], info[7], info[8], info[9], info[10], info[17], info[24]) diff --git a/wqflask/wqflask/views.py b/wqflask/wqflask/views.py index 67351784..89f0b3d7 100644 --- a/wqflask/wqflask/views.py +++ b/wqflask/wqflask/views.py @@ -28,10 +28,12 @@ def data_sharing(): fd = webqtlFormData.webqtlFormData(request.args) print("1Have fd") sharingInfoObject = SharingInfo.SharingInfo(request.args['GN_AccessionId'], None) - self.dict['body'] = sharingInfoObject.getBody(infoupdate="") - template_vars = SharingInfo.SharingInfo(request.args['GN_AccessionId'], None) + info, htmlfilelist = sharingInfoObject.getBody(infoupdate="") + #template_vars = SharingInfo.SharingInfo(request.args['GN_AccessionId'], None) print("1 Made it to rendering") - return template_vars + return render_template("data_sharing.html", + info=info, + htmlfilelist=htmlfilelist) @app.route("/search") def search(): -- cgit v1.2.3