From afbe7528993bd6fdca47dfbd045e7bd75a5b6609 Mon Sep 17 00:00:00 2001
From: root
Date: Wed, 19 Feb 2014 17:07:46 -0600
Subject: Committer: root <root@alexandria.uthsc.edu> On branch master

---
 wqflask/maintenance/dataset/datastructure.py | 30 ++++++++++++++++++++++++++++
 1 file changed, 30 insertions(+)

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
-- 
cgit v1.2.3