aboutsummaryrefslogtreecommitdiff
path: root/wqflask/tests/unit/base
diff options
context:
space:
mode:
authorMunyoki Kilyungi2022-09-07 11:58:57 +0300
committerBonfaceKilz2022-09-08 14:26:19 +0300
commitf48d60c1f4ddb222629e19fd42c840a961666334 (patch)
tree74e9bbffc839490f0c63749d1861fe755c17984c /wqflask/tests/unit/base
parente3b7d9a24fb38397d4c393503463973d677925fb (diff)
downloadgenenetwork2-f48d60c1f4ddb222629e19fd42c840a961666334.tar.gz
Use "%s" in sql query
* wqflask/base/mrna_assay_tissue_data.py: Delete db_tools. (MrnaAssayTissueData.get_symbol_values_pairs): Re-format query. * wqflask/tests/unit/base/test_mrna_assay_tissue_data.py: (test_get_trait_symbol_and_tissue_values): Add test for above.
Diffstat (limited to 'wqflask/tests/unit/base')
-rw-r--r--wqflask/tests/unit/base/test_mrna_assay_tissue_data.py8
1 files changed, 8 insertions, 0 deletions
diff --git a/wqflask/tests/unit/base/test_mrna_assay_tissue_data.py b/wqflask/tests/unit/base/test_mrna_assay_tissue_data.py
index ecaa9def..c43fb4b6 100644
--- a/wqflask/tests/unit/base/test_mrna_assay_tissue_data.py
+++ b/wqflask/tests/unit/base/test_mrna_assay_tissue_data.py
@@ -71,3 +71,11 @@ def test_get_trait_symbol_and_tissue_values(mocker):
"k2": ["v2"],
"k3": ["v3"],
}
+ cursor.execute.assert_called_with(
+ "SELECT TissueProbeSetXRef.Symbol, "
+ "TissueProbeSetData.value FROM "
+ "TissueProbeSetXRef, TissueProbeSetData "
+ "WHERE TissueProbeSetData.Id IN (%s) "
+ "AND TissueProbeSetXRef.DataId = "
+ "TissueProbeSetData.Id",
+ ('112',))