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)
