about summary refs log tree commit diff
path: root/gn3/db
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2021-12-10 11:24:33 +0300
committerFrederick Muriuki Muriithi2021-12-10 11:24:33 +0300
commita47a1c57c5a7bfd7ca10957e2225568e565467af (patch)
tree77ded89eea7cbf1f1bd352796763ee0b2db905d0 /gn3/db
parent7743715771b6149606504a011e6f0aeb93a94488 (diff)
downloadgenenetwork3-a47a1c57c5a7bfd7ca10957e2225568e565467af.tar.gz
Fix parameters
Issue:
https://github.com/genenetwork/gn-gemtext-threads/blob/main/topics/gn1-migration-to-gn2/partial-correlations.gmi

* Provide parameters as a dict of items (which works for MySQL), rather than
  as keywork arguments (as works in PostgreSQL).
Diffstat (limited to 'gn3/db')
-rw-r--r--gn3/db/correlations.py6
1 files changed, 4 insertions, 2 deletions
diff --git a/gn3/db/correlations.py b/gn3/db/correlations.py
index 3d12019..254af10 100644
--- a/gn3/db/correlations.py
+++ b/gn3/db/correlations.py
@@ -235,8 +235,10 @@ def fetch_tissue_probeset_xref_info(
                 "INNER JOIN TissueProbeSetXRef AS t ON t.Symbol = x.Symbol "
                 "AND t.Mean = x.maxmean")
             cursor.execute(
-                query, probeset_freeze_id=probeset_freeze_id,
-                symbols=tuple(gene_name_list))
+                query, {
+                    "probeset_freeze_id": probeset_freeze_id,
+                    "symbols": tuple(gene_name_list)
+                })
 
         results = cursor.fetchall()