aboutsummaryrefslogtreecommitdiff
path: root/wqflask/base/webqtlTrait.py
diff options
context:
space:
mode:
authorSam Ockman2012-06-03 05:47:07 -0400
committerSam Ockman2012-06-03 05:47:07 -0400
commit3d6be932e5185e4dd7170b3ea740591de01341a0 (patch)
tree654227319e2f5bab727a8abb5fac6689a0afedef /wqflask/base/webqtlTrait.py
parentf44a9e0425cf9d364604c62893100c0cdb0a6f8f (diff)
downloadgenenetwork2-3d6be932e5185e4dd7170b3ea740591de01341a0.tar.gz
Before changing fd for trait analysis into a webQTLFormData object
Diffstat (limited to 'wqflask/base/webqtlTrait.py')
-rwxr-xr-xwqflask/base/webqtlTrait.py17
1 files changed, 9 insertions, 8 deletions
diff --git a/wqflask/base/webqtlTrait.py b/wqflask/base/webqtlTrait.py
index c3c0cded..88226894 100755
--- a/wqflask/base/webqtlTrait.py
+++ b/wqflask/base/webqtlTrait.py
@@ -92,12 +92,13 @@ class webqtlTrait:
WHERE
ProbeSet.Id=ProbeSetXRef.ProbeSetId and
ProbeSetFreeze.Id = ProbeSetXRef.ProbeSetFreezeId and
- ProbeSet.Name = "%s" and
- ProbeSetFreeze.Name = "%s"
- ''' % (self.name, self.db.name)
+ ProbeSet.Name = %s and
+ ProbeSetFreeze.Name = %s
+ ''', (self.name, self.db.name)
print("query is:", query)
- self.cursor.execute(query)
+ self.cursor.execute(*query)
self.sequence = self.cursor.fetchone()[0]
+ print("self.sequence is:", self.sequence)
def getName(self):
@@ -124,7 +125,7 @@ class webqtlTrait:
str = self.name
if self.db and self.name:
if self.db.type=='Temp':
- self.cursor.execute('SELECT description FROM Temp WHERE Name=%s',self.name)
+ self.cursor.execute('SELECT description FROM Temp WHERE Name=%s', self.name)
desc = self.cursor.fetchone()[0]
if desc.__contains__('PCA'):
desc = desc[desc.rindex(':')+1:].strip()
@@ -206,7 +207,7 @@ class webqtlTrait:
def getSequence(self):
assert self.cursor
if self.db.type == 'ProbeSet':
- query = '''
+ self.cursor.execute('''
SELECT
ProbeSet.BlatSeq
FROM
@@ -216,8 +217,8 @@ class webqtlTrait:
ProbeSetFreeze.Id = ProbeSetXRef.ProbSetFreezeId and
ProbeSet.Name = %s
ProbeSetFreeze.Name = %s
- ''' , (self.name, self.db.name)
- self.cursor.execute(query)
+ ''', self.name, self.db.name)
+ #self.cursor.execute(query)
results = self.fetchone()
return results[0]