From a47a1c57c5a7bfd7ca10957e2225568e565467af Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Fri, 10 Dec 2021 11:24:33 +0300
Subject: 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).
---
 gn3/db/correlations.py | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

(limited to 'gn3/db')

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()
 
-- 
cgit v1.2.3