aboutsummaryrefslogtreecommitdiff
path: root/wqflask/maintenance/dataset
diff options
context:
space:
mode:
Diffstat (limited to 'wqflask/maintenance/dataset')
-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)