Python parse_binary_condition Examples

Example #1

    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%'
            }))

Example #2

 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
         }))

Example #3

def test_parse_tag_eq_num():
    parse_binary_condition('tag: == 23')

Example #4

def test_parse_dim_eq_num():
    assert_equal(
        parse_binary_condition(':dim == 23'),
        GenericBinaryCondition(TaggedDim(frozenset(), Dim('dim')), '==', 23))

Example #5

def test_parse_field_eq_unquoted():
    parse_binary_condition("@asdf == asdf")

Example #6

def test_parse_field_eq_ip_extra_garbage():
    parse_binary_condition('@asdf == 2.3.4.5  ffff')

Example #7

def test_parse_rhs_valueset():
    assert_equal(GenericSetCondition(Field('asdf'), '==', [91, 92, 93]),
                 parse_binary_condition('@asdf == {91,92,93}'))

Example #8

def test_parse_field_eq_ip():
    assert_equal(parse_binary_condition('@asdf == 2.3.4.5'),
                 GenericBinaryCondition(Field('asdf'), '==', "2.3.4.5"))

Example #9

def test_parse_field_eq_star():
    assert_equal(parse_binary_condition('@asdf == "*test*"'),
                 GenericBinaryCondition(Field('asdf'), '==', "*test*"))

Example #10

def test_parse_field_eq_quote():
    assert_equal(parse_binary_condition("@asdf == 'asdf'"),
                 GenericBinaryCondition(Field('asdf'), '==', "asdf"))

Example #11

def test_parse_field_eq_float():
    assert_equal(parse_binary_condition('@asdf == 2.03'),
                 GenericBinaryCondition(Field('asdf'), '==', 2.03))

Example #12

def test_parse_set():
    parse_binary_condition("@asdf == {1, 2, 3}")

Example #13

def test_parse_tags_eq_num():
    parse_binary_condition("tag1:tag2 == 23")