aboutsummaryrefslogtreecommitdiff
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
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).
-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()