def test_range_list_filter(self):
expected_sql = QUERY_BASE.format("")
expected_params = ["hg38", "E2F4", 18]
query = RangeListQuery(
schema="hg38",
custom_list_id=18,
model_name="E2F4",
)
sql, params = query.get_query_and_params()
self.assertEqual(expected_sql, sql)
self.assertEqual(expected_params, params)
def test_range_list_filter(self):
expected_sql = QUERY_BASE.format("")
expected_params = ["hg38", "E2F4", 18]
query = RangeListQuery(
schema="hg38",
custom_list_id=18,
model_name="E2F4",
)
sql, params = query.get_query_and_params()
self.assertEqual(expected_sql, sql)
self.assertEqual(expected_params, params)
def test_range_list_count(self):
expected_sql = QUERY_WITH_COUNT.format("")
expected_params = ["hg38", "E2F4", 48]
query = RangeListQuery(
schema="hg38",
custom_list_id=48,
model_name="E2F4",
count=True,
)
sql, params = query.get_query_and_params()
self.maxDiff = None
self.assertEqual(expected_sql, sql)
self.assertEqual(expected_params, params)
def test_range_list_filter_with_limit_multi_insert(self):
expected_sql = QUERY_BASE.format(LIMIT_OFFSET)
expected_params = ["hg38", "E2F4", 22, "100", "200"]
query = RangeListQuery(
schema="hg38",
custom_list_id=22,
model_name="E2F4",
limit="100",
offset="200",
)
sql, params = query.get_query_and_params()
self.assertEqual(expected_sql, sql)
self.assertEqual(expected_params, params)
def test_range_list_filter_with_limit_multi_insert(self):
expected_sql = QUERY_BASE.format(LIMIT_OFFSET)
expected_params = ["hg38", "E2F4", 22, "100", "200"]
query = RangeListQuery(
schema="hg38",
custom_list_id=22,
model_name="E2F4",
limit="100",
offset="200",
)
sql, params = query.get_query_and_params()
self.assertEqual(expected_sql, sql)
self.assertEqual(expected_params, params)
def test_range_list_count(self):
expected_sql = QUERY_WITH_COUNT.format("")
expected_params = ["hg38", "E2F4", 48]
query = RangeListQuery(
schema="hg38",
custom_list_id=48,
model_name="E2F4",
count=True,
)
sql, params = query.get_query_and_params()
self.maxDiff = None
self.assertEqual(expected_sql, sql)
self.assertEqual(expected_params, params)
