diff options
Diffstat (limited to 'wqflask/tests/unit/base/test_mrna_assay_tissue_data.py')
-rw-r--r-- | wqflask/tests/unit/base/test_mrna_assay_tissue_data.py | 81 |
1 files changed, 0 insertions, 81 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 deleted file mode 100644 index c43fb4b6..00000000 --- a/wqflask/tests/unit/base/test_mrna_assay_tissue_data.py +++ /dev/null @@ -1,81 +0,0 @@ -import pytest -from base.mrna_assay_tissue_data import MrnaAssayTissueData - - -@pytest.mark.parametrize( - ('gene_symbols', 'expected_query', 'sql_fetch_all_results'), - ( - (None, - (("SELECT t.Symbol, t.GeneId, t.DataId, " - "t.Chr, t.Mb, t.description, " - "t.Probe_Target_Description " - "FROM (SELECT Symbol, " - "max(Mean) AS maxmean " - "FROM TissueProbeSetXRef WHERE " - "TissueProbeSetFreezeId=1 AND " - "Symbol != '' AND Symbol IS NOT " - "Null GROUP BY Symbol) " - "AS x INNER JOIN TissueProbeSetXRef " - "AS t ON t.Symbol = x.Symbol " - "AND t.Mean = x.maxmean"),), - (("symbol", "gene_id", - "data_id", "chr", "mb", - "description", - "probe_target_description"),)), - (["k1", "k2", "k3"], - ("SELECT t.Symbol, t.GeneId, t.DataId, " - "t.Chr, t.Mb, t.description, " - "t.Probe_Target_Description FROM (SELECT Symbol, " - "max(Mean) AS maxmean " - "FROM TissueProbeSetXRef WHERE " - "TissueProbeSetFreezeId=1 AND " - "Symbol IN (%s, %s, %s) " - "GROUP BY Symbol) AS x INNER JOIN " - "TissueProbeSetXRef AS " - "t ON t.Symbol = x.Symbol " - "AND t.Mean = x.maxmean", - ("k1", "k2", "k3")), - (("k1", "203", - "112", "xy", "20.11", - "Sample Description", - "Sample Probe Target Description"),)), - ), -) -def test_mrna_assay_tissue_data_initialisation(mocker, gene_symbols, - expected_query, - sql_fetch_all_results): - mock_conn = mocker.MagicMock() - with mock_conn.cursor() as cursor: - cursor.fetchall.return_value = sql_fetch_all_results - MrnaAssayTissueData(conn=mock_conn, gene_symbols=gene_symbols) - cursor.execute.assert_called_with(*expected_query) - - -def test_get_trait_symbol_and_tissue_values(mocker): - """Test for getting trait symbol and tissue_values""" - mock_conn = mocker.MagicMock() - with mock_conn.cursor() as cursor: - cursor.fetchall.side_effect = [ - (("k1", "203", - "112", "xy", "20.11", - "Sample Description", - "Sample Probe Target Description"),), - (("k1", "v1"), - ("k2", "v2"), - ("k3", "v3")), - ] - _m = MrnaAssayTissueData(conn=mock_conn, - gene_symbols=["k1", "k2", "k3"]) - assert _m.get_symbol_values_pairs() == { - "k1": ["v1"], - "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',)) |