Python Parser.parse_where Examples

Programming Language: Python

Namespace/Package Name: sql

Class/Type: Parser

Method/Function: parse_where

Examples at hotexamples.com: 2

Python Parser.parse_where - 2 examples found. These are the top rated real world Python examples of sql.Parser.parse_where extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

parse_group(1)

parse_order(1)

parse_select(1)

parse_where(1)

Example #1

Show file

File: tests.py Project: Nouhi/polychart2

 def test_succeed_on_parse_where(self):
   filter_with_inequalities = {'val1': { 'ge': 8, 'le': 17 }}
   filter_with_strict_inequalities = { 'val2': { 'lt': 9, 'gt':2} }
   filter_with_in = { 'color': {'in': ['blue', 'red']}}
   self.assertEqual(Parser.parse_where(filter_with_inequalities), [('val1', '>=', 8), ('val1', '<=', 17)])
   self.assertEqual(Parser.parse_where(filter_with_strict_inequalities), [('val2', '<', 9), ('val2', '>', 2)])
   self.assertEqual(Parser.parse_where(filter_with_in), [('color', 'in', ['blue', 'red'])])

Example #2

Show file

File: tests.py Project: sardarsevasingh76/polychart2

 def test_succeed_on_parse_where(self):
     filter_with_inequalities = {'val1': {'ge': 8, 'le': 17}}
     filter_with_strict_inequalities = {'val2': {'lt': 9, 'gt': 2}}
     filter_with_in = {'color': {'in': ['blue', 'red']}}
     self.assertEqual(Parser.parse_where(filter_with_inequalities),
                      [('val1', '>=', 8), ('val1', '<=', 17)])
     self.assertEqual(Parser.parse_where(filter_with_strict_inequalities),
                      [('val2', '<', 9), ('val2', '>', 2)])
     self.assertEqual(Parser.parse_where(filter_with_in),
                      [('color', 'in', ['blue', 'red'])])