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_genotypes.py11
2 files changed, 14 insertions, 11 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 = """
diff --git a/wqflask/maintenance/dataset/load_genotypes.py b/wqflask/maintenance/dataset/load_genotypes.py
index 124d3776..0e35fc24 100644
--- a/wqflask/maintenance/dataset/load_genotypes.py
+++ b/wqflask/maintenance/dataset/load_genotypes.py
@@ -55,17 +55,6 @@ def main(argv):
print values
return
- # open db
- host = 'localhost'
- user = 'webqtl'
- passwd = 'webqtl'
- db = 'db_webqtl'
- con = MySQLdb.Connect(db=db, user=user, passwd=passwd, host=host)
- cursor = con.cursor()
- # var
- speciesid = int(argv[2])
- inbredsetid = int(argv[3])
- genofreezeid = int(argv[4])
sql = """
SELECT Id
FROM GenoData