aboutsummaryrefslogtreecommitdiff
path: root/wqflask/maintenance
diff options
context:
space:
mode:
Diffstat (limited to 'wqflask/maintenance')
-rw-r--r--wqflask/maintenance/dataset/datastructure.py30
1 files changed, 30 insertions, 0 deletions
diff --git a/wqflask/maintenance/dataset/datastructure.py b/wqflask/maintenance/dataset/datastructure.py
index 9f1433e2..97d8f91f 100644
--- a/wqflask/maintenance/dataset/datastructure.py
+++ b/wqflask/maintenance/dataset/datastructure.py
@@ -58,3 +58,33 @@ def get_nextdataid_phenotype():
dataid = re[0]
dataid += 1
return dataid
+
+def insert_strain(speciesid, strainname):
+ sql = """
+ INSERT INTO Strain
+ SET
+ Strain.`Name`=%s,
+ Strain.`Name2`=%s,
+ Strain.`SpeciesId`=%s
+ """
+ cursor.execute(sql, (strainname, strainname, speciesid))
+
+def get_strain(speciesid, strainname):
+ sql = """
+ SELECT Strain.`Id`, Strain.`Name`
+ FROM Strain
+ WHERE Strain.`SpeciesId`=%s
+ AND Strain.`Name` LIKE %s
+ """
+ cursor.execute(sql1, (speciesid, strainname))
+ return cursor.fetchone()
+
+def get_strain_sure(speciesid, strainname):
+ strain = get_strain(speciesid, strainname)
+ if not strain:
+ insert_strain(speciesid, strainame)
+ strain = get_strain(speciesid, strainname)
+ return strain
+
+def get_strains_bynames(strainnames)
+ \ No newline at end of file