filter_expression_parser/example.py at master · snow884/filter_expression_parser · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
import re
import parser
import datetime

def create_setup():
    jog_parser_params = {}

    # define the format checking functions
    def check_jog_id(str_in):

        try:
            val_out = int(str_in)
        except:
            raise(Exception('invalid format of the column jog_id'))

        return(val_out)

    def check_date(str_in):

        comp_value = str_in.strip().strip('\'').strip('"')
        try:
            datetime.datetime.strptime(comp_value, '%Y-%m-%d')
        except:
            raise(Exception('invalid format of the column date'))

        return(comp_value)

    def check_distance(str_in):
        try:
            val_out = float(str_in)
        except:
            raise(Exception('invalid format of the column jog_id'))

        return(val_out)

    def check_time(str_in):
        try:
            val_out = float(str_in)
        except:
            raise(Exception('invalid format of the column jog_id'))

        return(val_out)

    # define variable types and forma checking functions
    jog_parser_params['column_list']=(
    {
        'jog_id': {
                'type': 'int',
                'format_checker': check_jog_id,
            },
        'date':
            {
                'type': 'date',
                'format_checker': check_date,
            },
        'distance':
            {
                'type': 'float',
                'format_checker': check_distance,
            },
        'time':
            {
                'type': 'float',
                'format_checker': check_time
            }
    }
    )

    # define the comparison operators
    jog_parser_params['comp_op_list'] = (
    {
        'eq':{
                'sql_str':'=',
                'funciton': lambda a, b : a == b
            },
        'ne':{
                'sql_str':'!=',
                'funciton': lambda a, b : a != b
            },
        'gt':{
                'sql_str':'>',
                'funciton': lambda a, b : a > b
            },
        'lt':{
                'sql_str':'<',
                'funciton': lambda a, b : a < b
            }
    })

    # define the logical operators
    jog_parser_params['log_ops'] = (
    {
        'or':{
                'sql_str':'or',
                'funciton': lambda a, b : a | b
            },
        'and':{
                'sql_str':'and',
                'funciton': lambda a, b : a & b
            }
    })

    return(jog_parser_params)

list_in = (
    [
    {
        'jog_id': 1,
        'date': '2019-01-03',
        'distance': 10,
        'time': 40
    },
    {
        'jog_id': 2,
        'date': '2019-01-04',
        'distance': 12,
        'time': 40
    },
    {
        'jog_id': 3,
        'date': '2019-01-05',
        'distance': 12,
        'time': 41
    }
    ])

print(parser.Parser(create_setup()).filter('',list_in))

print(parser.Parser(create_setup()).filter('jog_id gt 1',list_in))

print(parser.Parser(create_setup()).filter('date gt \'2019-01-04\'',list_in))

print(parser.Parser(create_setup()).filter('(jog_id eq 1) OR (date gt \'2019-01-04\')',list_in))