diff options
| -rw-r--r-- | wqflask/maintenance/dataset/phenotypes/phenotypes.py | 24 |
1 files changed, 20 insertions, 4 deletions
diff --git a/wqflask/maintenance/dataset/phenotypes/phenotypes.py b/wqflask/maintenance/dataset/phenotypes/phenotypes.py index bd5dcaa6..28fd3398 100644 --- a/wqflask/maintenance/dataset/phenotypes/phenotypes.py +++ b/wqflask/maintenance/dataset/phenotypes/phenotypes.py @@ -35,15 +35,31 @@ def fetch(): # sql = """ SELECT PublishXRef.`Id`, Phenotype.`Original_description`, Phenotype.`Pre_publication_description`, Phenotype.`Post_publication_description` - FROM PublishXRef, Phenotype + FROM (PublishXRef, Phenotype) WHERE PublishXRef.`PhenotypeId`=Phenotype.`Id` AND PublishXRef.`InbredSetId`=%s """ cursor.execute(sql, (inbredsetid)) results = cursor.fetchall() - print "get %d phenotypes" % len(results) - for row in results: - print row + print "get %d phenotypes" % (len(results)) + for phenotyperow in results: + publishxrefid = phenotyperow[0] + original_description = phenotyperow[1] + pre_publication_description = phenotyperow[2] + post_publication_description = phenotyperow[3] + sql = """ + SELECT Strain.Name, PublishData.value + FROM (PublishXRef, PublishData, Strain) + WHERE PublishXRef.`InbredSetId`=%s + AND PublishXRef.Id=%s + AND PublishXRef.DataId=PublishData.Id + AND PublishData.StrainId=Strain.Id + """ + cursor.execute(sql, (inbredsetid, publishxrefid)) + results = cursor.fetchall() + print "get %d values" % (len(results)) + for strainvalue in results: + print strainvalue break # main |