diff options
| -rw-r--r-- | scripts/insert_data.py | 18 |
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 " |