diff options
| author | Frederick Muriuki Muriithi | 2024-03-22 04:53:59 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2024-03-22 04:53:59 +0300 |
| commit | 3e48d8020029d6a98fcb056366d145277f22fc61 (patch) | |
| tree | 13a7ea01865ebf2376e648aafa16525f45bc8efa /scripts | |
| parent | 3958ce457f621f1b75fa8843ba859d8e6015a6c7 (diff) | |
| download | gn-uploader-3e48d8020029d6a98fcb056366d145277f22fc61.tar.gz | |
Fix linting issue.
Diffstat (limited to 'scripts')
| -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 " |