aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorroot2014-02-20 16:14:05 -0600
committerroot2014-02-20 16:14:05 -0600
commitb196a0b2a55091eb92e1538c5dd52e0460ecdc84 (patch)
treeb144b43e1603c6c0f9c6bca3a92eaf3fe8ef5313
parent16afdd0bb4be4733a98db4ee656125ccd7a14293 (diff)
downloadgenenetwork2-b196a0b2a55091eb92e1538c5dd52e0460ecdc84.tar.gz
Committer: root <root@alexandria.uthsc.edu>
On branch master
-rw-r--r--wqflask/maintenance/dataset/load_phenotypes.py5
1 files changed, 3 insertions, 2 deletions
diff --git a/wqflask/maintenance/dataset/load_phenotypes.py b/wqflask/maintenance/dataset/load_phenotypes.py
index 5847da4b..95b71b2f 100644
--- a/wqflask/maintenance/dataset/load_phenotypes.py
+++ b/wqflask/maintenance/dataset/load_phenotypes.py
@@ -151,9 +151,10 @@ def main(argv):
PublishXRef.`InbredSetId`=%s,
PublishXRef.`PhenotypeId`=%s,
PublishXRef.`PublicationId`=%s,
- PublishXRef.`DataId`=%s
+ PublishXRef.`DataId`=%s,
+ PublishXRef.`comments`=%s
"""
- cursor.execute(sql, (inbredsetid, phenotypeid, publicationid, dataid))
+ cursor.execute(sql, (inbredsetid, phenotypeid, publicationid, dataid, ""))
rowcount = cursor.rowcount
publishxrefid = con.insert_id()
print "INSERT INTO PublishXRef: %d record: %d" % (rowcount, publishxrefid)