aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorroot2014-02-19 17:07:46 -0600
committerroot2014-02-19 17:07:46 -0600
commitafbe7528993bd6fdca47dfbd045e7bd75a5b6609 (patch)
tree5779c69ac8e3dec692cfbbaef98f8eacc1d0d355
parent13b090fc47504c2ddf73f38cd16aa67f0f41d4ba (diff)
downloadgenenetwork2-afbe7528993bd6fdca47dfbd045e7bd75a5b6609.tar.gz
Committer: root <root@alexandria.uthsc.edu>
On branch master
-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