def test_max_with_no_guess(self): expected_sql = MAX_QUERY_NO_GUESS expected_params = ["hg38", "refgene", "E2F4", "250", "150", "150", "250", "refgene", "E2F4", "250", "150", "150", "250"] query = MaxPredictionQuery( schema="hg38", gene_list="refgene", model_name="E2F4", upstream="150", downstream="250", ) sql, params = query.get_query_and_params() self.assertMultiLineEqual(expected_sql, sql) self.assertEqual(expected_params, params)
def test_max_with_no_guess(self): expected_sql = MAX_QUERY_NO_GUESS expected_params = [ "hg38", "refgene", "E2F4", "150", "250", "250", "150", "refgene", "E2F4", "150", "250", "250", "150" ] query = MaxPredictionQuery( schema="hg38", gene_list="refgene", model_name="E2F4", upstream="150", downstream="250", ) sql, params = query.get_query_and_params() self.assertMultiLineEqual(expected_sql, sql) self.assertEqual(expected_params, params)
def test_max_count(self): expected_sql = COUNT_QUERY expected_params = ["hg38", "refgene", "E2F4", "250", "150", "150", "250", "refgene", "E2F4", "250", "150", "150", "250"] query = MaxPredictionQuery( schema="hg38", gene_list="refgene", model_name="E2F4", upstream="150", downstream="250", count=True, ) self.maxDiff = None sql, params = query.get_query_and_params() self.assertMultiLineEqual(expected_sql, sql) self.assertEqual(expected_params, params)
def test_max_count(self): expected_sql = COUNT_QUERY expected_params = [ "hg38", "refgene", "E2F4", "150", "250", "250", "150", "refgene", "E2F4", "150", "250", "250", "150" ] query = MaxPredictionQuery( schema="hg38", gene_list="refgene", model_name="E2F4", upstream="150", downstream="250", count=True, ) self.maxDiff = None sql, params = query.get_query_and_params() self.assertMultiLineEqual(expected_sql, sql) self.assertEqual(expected_params, params)
def test_max_with_guess_and_limit(self): expected_sql = MAX_QUERY_WITH_GUESS_WITH_LIMIT expected_params = ["hg38", "refgene", "E2F4", "250", "150", "150", "250", "0.4", "100", "200", "refgene", "E2F4", "250", "150", "150", "250"] query = MaxPredictionQuery( schema="hg38", gene_list="refgene", model_name="E2F4", upstream="150", downstream="250", guess="0.4", limit="100", offset="200", ) sql, params = query.get_query_and_params() self.maxDiff = None self.assertMultiLineEqual(expected_sql, sql) self.assertEqual(expected_params, params)
def test_max_with_guess_and_limit(self): expected_sql = MAX_QUERY_WITH_GUESS_WITH_LIMIT expected_params = [ "hg38", "refgene", "E2F4", "150", "250", "250", "150", "0.4", "100", "200", "refgene", "E2F4", "150", "250", "250", "150" ] query = MaxPredictionQuery( schema="hg38", gene_list="refgene", model_name="E2F4", upstream="150", downstream="250", guess="0.4", limit="100", offset="200", ) sql, params = query.get_query_and_params() self.maxDiff = None self.assertMultiLineEqual(expected_sql, sql) self.assertEqual(expected_params, params)