aboutsummaryrefslogtreecommitdiff
path: root/wqflask/maintenance/dataset/datastructure.py
diff options
context:
space:
mode:
authorLei Yan2014-02-22 22:13:26 -0600
committerLei Yan2014-02-22 22:13:26 -0600
commitaf92bb48b2589d2804569863bc0306f787df1c60 (patch)
tree594ad9481cc6ffabfb8e687efc646d94e9328aa6 /wqflask/maintenance/dataset/datastructure.py
parent562e7ba9b6b5a051da1a9f0a046f39f480998be8 (diff)
downloadgenenetwork2-af92bb48b2589d2804569863bc0306f787df1c60.tar.gz
On branch master
Diffstat (limited to 'wqflask/maintenance/dataset/datastructure.py')
-rw-r--r--wqflask/maintenance/dataset/datastructure.py14
1 files changed, 14 insertions, 0 deletions
diff --git a/wqflask/maintenance/dataset/datastructure.py b/wqflask/maintenance/dataset/datastructure.py
index 0ee4b4ab..e1d88df2 100644
--- a/wqflask/maintenance/dataset/datastructure.py
+++ b/wqflask/maintenance/dataset/datastructure.py
@@ -66,6 +66,20 @@ def get_genofreeze_byinbredsetid(inbredsetid):
cursor.execute(sql, (inbredsetid))
return cursor.fetchone()
+def get_nextdataid_genotype():
+ cursor, con = utilities.get_cursor()
+ sql = """
+ SELECT GenoData.`Id`
+ FROM GenoData
+ ORDER BY GenoData.`Id` DESC
+ LIMIT 1
+ """
+ cursor.execute(sql)
+ re = cursor.fetchone()
+ dataid = re[0]
+ dataid += 1
+ return dataid
+
def get_nextdataid_phenotype():
cursor, con = utilities.get_cursor()
sql = """