diff options
| -rw-r--r-- | wqflask/maintenance/dataset/load_phenotypes.py | 5 |
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) |