diff options
| -rw-r--r-- | wqflask/maintenance/dataset/datastructure.py | 14 | ||||
| -rw-r--r-- | wqflask/maintenance/dataset/load_phenotypes.py | 1 |
2 files changed, 15 insertions, 0 deletions
diff --git a/wqflask/maintenance/dataset/datastructure.py b/wqflask/maintenance/dataset/datastructure.py index 400c7fda..9f1433e2 100644 --- a/wqflask/maintenance/dataset/datastructure.py +++ b/wqflask/maintenance/dataset/datastructure.py @@ -44,3 +44,17 @@ def get_inbredset(probesetfreezeid): """ cursor.execute(sql, (probesetfreezeid)) return cursor.fetchone() + +def get_nextdataid_phenotype(): + cursor = utilities.get_cursor() + sql = """ + SELECT PublishData.`Id` + FROM PublishData + ORDER BY PublishData.`Id` DESC + LIMIT 1 + """ + cursor.execute(sql) + re = cursor.fetchone() + dataid = re[0] + dataid += 1 + return dataid diff --git a/wqflask/maintenance/dataset/load_phenotypes.py b/wqflask/maintenance/dataset/load_phenotypes.py index 98c22229..77133d0c 100644 --- a/wqflask/maintenance/dataset/load_phenotypes.py +++ b/wqflask/maintenance/dataset/load_phenotypes.py @@ -11,6 +11,7 @@ def main(argv): print "\t%s" % (str(item)) # var inbredsetid = config.get('config', 'inbredsetid') + dataid = utilities.get_nextdataid_phenotype() cursor, con = utilities.get_cursor() print "inbredsetid: %s" % inbredsetid # datafile |