def test_querystring_update_filter_in_3(self, registry_blok): registry = registry_blok request = MockRequest(self) model = registry.System.Blok key = 'name' op = 'in' value = '' qs = QueryString(request, model) qs.update_filter(model, key, op, value) assert ("Filter 'in' except a comma separated string value" in request.errors.messages)
def test_querystring_update_filter_ilike(self, registry_blok): registry = registry_blok request = MockRequest(self) model = registry.System.Blok query = model.query() key = 'name' op = 'ilike' value = 'yBlOk-c' qs = QueryString(request, model) Q = query.filter(qs.update_filter(model, key, op, value)) obj = Q.one() assert obj.name == 'anyblok-core'
def test_querystring_update_filter_ilike(self): registry = self.init_registry(None) request = MockRequest(self) model = registry.System.Blok query = model.query() key = 'name' op = 'ilike' value = 'yBlOk-c' qs = QueryString(request, model) Q = query.filter(qs.update_filter(model, key, op, value)) obj = Q.one() self.assertEqual(obj.name, 'anyblok-core')
def test_querystring_update_filter_or_ilike(self, registry_blok): registry = registry_blok request = MockRequest(self) model = registry.System.Blok query = model.query() key = 'name' op = 'or-ilike' value = 'core,test' qs = QueryString(request, model) Q = query.filter(qs.update_filter(model, key, op, value)) Q = Q.order_by('name') obj = Q.all() assert obj.name == ['anyblok-core', 'anyblok-test']
def test_querystring_update_filter_in_2(self, registry_blok): registry = registry_blok request = MockRequest(self) model = registry.System.Blok query = model.query() key = 'name' op = 'in' value = 'anyblok-core,anyblok-test' qs = QueryString(request, model) Q = query.filter(qs.update_filter(model, key, op, value)) names = Q.all().name assert len(names) == 2 assert 'anyblok-core' in names assert 'anyblok-test' in names
def test_querystring_update_filter_in_2(self): registry = self.init_registry(None) request = MockRequest(self) model = registry.System.Blok query = model.query() key = 'name' op = 'in' value = 'anyblok-core,anyblok-io' qs = QueryString(request, model) Q = query.filter(qs.update_filter(model, key, op, value)) names = Q.all().name self.assertEqual(len(names), 2) self.assertIn('anyblok-core', names) self.assertIn('anyblok-io', names)
def test_querystring_update_filter_gte(self, registry_blok_with_integer): registry = registry_blok_with_integer request = MockRequest(self) model = registry.Exemple query = model.query() key = 'number' op = 'gte' value = 10 qs = QueryString(request, model) Q = query.filter(qs.update_filter(model, key, op, value)) assert len(Q.all()) == 0 model.insert(number=9) assert len(Q.all()) == 0 model.insert(number=10) assert len(Q.all()) == 1 model.insert(number=11) assert len(Q.all()) == 2
def test_querystring_update_filter_lt(self): registry = self.init_registry(add_integer_class) request = MockRequest(self) model = registry.Exemple query = model.query() key = 'number' op = 'lt' value = 10 qs = QueryString(request, model) Q = query.filter(qs.update_filter(model, key, op, value)) self.assertEqual(len(Q.all()), 0) model.insert(number=9) self.assertEqual(len(Q.all()), 1) model.insert(number=10) self.assertEqual(len(Q.all()), 1) model.insert(number=11) self.assertEqual(len(Q.all()), 1)