def test_queryfilter_by_name(item):
qry = QueryFilter(model=Table)
qry.add('name', 'test')
sql_expected = SQL + 'WHERE "table".name LIKE ?'
assert qry.sql == sql_expected
def test_queryfilter_by_ilike(item):
qry = QueryFilter(model=Table)
qry.add('name[ilike]', '1999-09-09')
sql_expected = SQL + \
"WHERE lower(\"table\".name) LIKE lower(?)"
assert qry.sql == sql_expected
def test_queryfilter_by_is_null(item):
qry = QueryFilter(model=Table)
qry.add('name', 'null')
sql_expected = SQL + \
"WHERE \"table\".name IS NULL"
assert qry.sql == sql_expected
def test_queryfilter_by_notin_(item):
qry = QueryFilter(model=Table)
qry.add('name[notin_]', 'ab')
sql_expected = SQL + \
"WHERE \"table\".name NOT IN (?, ?)"
assert qry.sql == sql_expected
def test_queryfilter_order_by_defalt_asc(item):
qry = QueryFilter(model=Table)
qry.add('sort_field', 'name')
sql_expected = SQL[:-1] + \
"ORDER BY \"table\".name ASC"
assert qry.sql == sql_expected
def test_queryfilter_by_year(item):
qry = QueryFilter(model=Table)
qry.add('created_date[year]', '1')
sql_expected = SQL + \
"WHERE CAST(STRFTIME('%Y', \"table\".created_date) AS INTEGER) = ?"
assert qry.sql == sql_expected
def test_queryfilter_by_like(item):
qry = QueryFilter(model=Table)
qry.add('created_date[like]', '1999-09-09')
sql_expected = SQL + \
"WHERE \"table\".created_date LIKE ?"
assert qry.sql == sql_expected
def test_queryfilter_by_isnot(item):
qry = QueryFilter(model=Table)
qry.add('name[isnot]', None)
sql_expected = SQL + \
"WHERE \"table\".name IS NOT NULL"
assert qry.sql == sql_expected
def test_queryfilter_by_equal(item):
qry = QueryFilter(model=Table)
qry.add('name[equal]', '1999-09-09')
sql_expected = SQL + \
"WHERE \"table\".name = ?"
assert qry.sql == sql_expected
def test_queryfilter_by_name_and_desciption(item):
qry = QueryFilter(model=Table)
qry.add('name', 'test')
qry.add('description', 'test')
sql_expected = SQL + \
'WHERE "table".name LIKE ? AND "table".description LIKE ?'
assert qry.sql == sql_expected
def test_queryfilter_by_name_or_description(item):
qry = QueryFilter(model=Table)
qry.add('name[orlike]', 'test')
qry.add('description[orlike]', 'test')
sql_expected = SQL + \
'WHERE ("table".name LIKE ? OR "table".description LIKE ?)'
assert qry.sql == sql_expected
def get_query_filter(self, filters=None, exclude_facets=None):
filters = filters or []
exclude_facets = set(exclude_facets or [])
qf = QueryFilter()
for f in filters:
qf.add_filter(f)
if "facet.field" in self._params:
for field in self._params["facet.field"]:
if field not in exclude_facets:
qf.add_filter(field)
if "facet.query" in self._params:
for facet_query in self._params["facet.query"]:
field, cond = facet_query.split(":")
if field not in exclude_facets:
qf.add_filter(field)
return qf
def test_error_get_invalid_field_in_order_by(item):
qry = QueryFilter(model=Table)
with pytest.raises(InvalidField):
qry.add('sort_field', 'invalidField')
def resolve_something(self, info, **kwargs):
query_filter = kwargs.get('queryFilter', {})
query_filter = QueryFilter(query_filter)
examples = query_filter.on_dicts(EXAMPLE_DATA)
return examples
def test_null2none(item):
qry = QueryFilter(model=Table)
assert qry.null2none('null') == None
def test_error_get_invalid_field(item):
qry = QueryFilter(model=Table)
with pytest.raises(InvalidField):
qry.add('not_in_table', 'test')
def test_find_operator(operator, item):
qry = QueryFilter(model=Table)
assert qry.find_operator(operator) == operator
def test_invalid_find_operator(item):
qry = QueryFilter(model=Table)
assert qry.find_operator('InvalidOperator') == None
def test_get_field(field):
qry = QueryFilter(model=Table)
assert qry.get_field(field) == 'name'
def test_get_valid_field(field):
qry = QueryFilter(model=Table, valid_fields=['name', 'description'])
assert qry.get_field(field) == 'name'
def test_error_get_invalid_operator(item):
qry = QueryFilter(model=Table)
qry.OPERATOR_KEYWORDS += ['notin']
qry.add('name[notin]', 'test')
with pytest.raises(InvalidDialectField):
qry.query()
