aboutsummaryrefslogtreecommitdiff
path: root/scripts/insert_data.py
diff options
context:
space:
mode:
Diffstat (limited to 'scripts/insert_data.py')
-rw-r--r--scripts/insert_data.py18
1 files changed, 9 insertions, 9 deletions
diff --git a/scripts/insert_data.py b/scripts/insert_data.py
index 23ae108..efe81df 100644
--- a/scripts/insert_data.py
+++ b/scripts/insert_data.py
@@ -258,15 +258,15 @@ def insert_se(# pylint: disable = [too-many-arguments]
annotations = annotationinfo(dbconn, platformid, datasetid)
if not bool(annotations):
with dbconn.cursor(cursorclass=DictCursor) as cursor:
- dquery = cursor.execute((
- "SELECT "
- "gc.GeneChipName AS platformname, pf.Name AS studyname, "
- "psf.FullName AS datasetname "
- "FROM GeneChip AS gc INNER JOIN ProbeFreeze AS pf "
- "ON gc.Id=pf.ChipId INNER JOIN ProbeSetFreeze AS psf "
- "ON pf.Id=psf.ProbeFreezeId "
- "WHERE gc.Id=%s AND psf.Id=%s"),
- (platformid, datasetid))
+ cursor.execute(
+ ("SELECT "
+ "gc.GeneChipName AS platformname, pf.Name AS studyname, "
+ "psf.FullName AS datasetname "
+ "FROM GeneChip AS gc INNER JOIN ProbeFreeze AS pf "
+ "ON gc.Id=pf.ChipId INNER JOIN ProbeSetFreeze AS psf "
+ "ON pf.Id=psf.ProbeFreezeId "
+ "WHERE gc.Id=%s AND psf.Id=%s"),
+ (platformid, datasetid))
errorinfo = cursor.fetchone()
print(("ERROR: No annotations found for the "