def test_condition_to_where_string_wc(self): sql._ParamCreator.index = 0 self.assertEqual( sql._condition_to_where( parse_binary_condition('@raw_column == "test*"')), ('(raw_column LIKE :param_raw_column_0)', { 'param_raw_column_0': 'test%' })) self.assertEqual( sql._condition_to_where( parse_binary_condition('@raw_column == "*test*"')), ('(raw_column LIKE :param_raw_column_1)', { 'param_raw_column_1': '%test%' }))
def test_condition_to_where_int(self): sql._ParamCreator.index = 0 self.assertEqual( sql._condition_to_where( parse_binary_condition('@raw_column == 5')), ('(raw_column = :param_raw_column_0)', { 'param_raw_column_0': 5 }))
def test_parse_tag_eq_num(): parse_binary_condition('tag: == 23')
def test_parse_dim_eq_num(): assert_equal( parse_binary_condition(':dim == 23'), GenericBinaryCondition(TaggedDim(frozenset(), Dim('dim')), '==', 23))
def test_parse_field_eq_unquoted(): parse_binary_condition("@asdf == asdf")
def test_parse_field_eq_ip_extra_garbage(): parse_binary_condition('@asdf == 2.3.4.5 ffff')
def test_parse_rhs_valueset(): assert_equal(GenericSetCondition(Field('asdf'), '==', [91, 92, 93]), parse_binary_condition('@asdf == {91,92,93}'))
def test_parse_field_eq_ip(): assert_equal(parse_binary_condition('@asdf == 2.3.4.5'), GenericBinaryCondition(Field('asdf'), '==', "2.3.4.5"))
def test_parse_field_eq_star(): assert_equal(parse_binary_condition('@asdf == "*test*"'), GenericBinaryCondition(Field('asdf'), '==', "*test*"))
def test_parse_field_eq_quote(): assert_equal(parse_binary_condition("@asdf == 'asdf'"), GenericBinaryCondition(Field('asdf'), '==', "asdf"))
def test_parse_field_eq_float(): assert_equal(parse_binary_condition('@asdf == 2.03'), GenericBinaryCondition(Field('asdf'), '==', 2.03))
def test_parse_set(): parse_binary_condition("@asdf == {1, 2, 3}")
def test_parse_tags_eq_num(): parse_binary_condition("tag1:tag2 == 23")