about summary refs log tree commit diff
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2021-11-26 11:50:33 +0300
committerFrederick Muriuki Muriithi2021-11-29 12:05:16 +0300
commitee200d60bd3065c4c9e69bcbb756715211b711d2 (patch)
treeadffe12351e8ce8753817cd2551dac8738de35d0
parentd29ef85d44fff9414932d64850f65cb268b1cddd (diff)
downloadgenenetwork3-ee200d60bd3065c4c9e69bcbb756715211b711d2.tar.gz
Return only values
Issue:
https://github.com/genenetwork/gn-gemtext-threads/blob/main/topics/gn1-migration-to-gn2/partial-correlations.gmi

* Return the values from the database, not the tuples.
-rw-r--r--gn3/db/correlations.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/gn3/db/correlations.py b/gn3/db/correlations.py
index 898de75..05c0809 100644
--- a/gn3/db/correlations.py
+++ b/gn3/db/correlations.py
@@ -399,12 +399,12 @@ def fetch_sample_ids(
         "AND Species.name=%(species_name)s")
     with conn.cursor() as cursor:
         cursor.execute(
-        return cursor.fetchall()
             query,
             {
                 "samples_names": tuple(sample_names),
                 "species_name": species_name
             })
+        return tuple(row[0] for row in cursor.fetchall())
 
 def build_query_sgo_lit_corr(
         db_type: str, temp_table: str, sample_id_columns: str,