aboutsummaryrefslogtreecommitdiff
path: root/wqflask/maintenance
diff options
context:
space:
mode:
Diffstat (limited to 'wqflask/maintenance')
-rw-r--r--wqflask/maintenance/dataset/datastructure.py14
-rw-r--r--wqflask/maintenance/dataset/load_phenotypes.py1
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