From 3e48d8020029d6a98fcb056366d145277f22fc61 Mon Sep 17 00:00:00 2001 From: Frederick Muriuki Muriithi Date: Fri, 22 Mar 2024 04:53:59 +0300 Subject: Fix linting issue. --- scripts/insert_data.py | 18 +++++++++--------- 1 file 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 " -- cgit v1.2.3