diff options
Diffstat (limited to 'wqflask/maintenance/dataset/datastructure.py')
| -rw-r--r-- | wqflask/maintenance/dataset/datastructure.py | 14 |
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 = """ |