def complete(self, format='json'): self._disable_cache() parser = DistinctParamParser(request.params) params, errors = parser.parse() if errors: response.status = 400 return {'errors': errors} if not c.account: response.status = 403 return to_jsonp({'errors': _("You are not authorized to see that " "page")}) query = db.session.query(Account) filter_string = params.get('q') + '%' query = query.filter(db.or_(Account.name.ilike(filter_string), Account.fullname.ilike(filter_string))) count = query.count() query = query.limit(params.get('pagesize')) query = query.offset(int((params.get('page') - 1) * params.get('pagesize'))) results = [dict(fullname=x.fullname, name=x.name) for x in list(query)] return to_jsonp({ 'results': results, 'count': count })
def complete(self, format='json'): self._disable_cache() parser = DistinctParamParser(request.params) params, errors = parser.parse() if errors: response.status = 400 return {'errors': errors} if not c.account: response.status = 403 return to_jsonp( {'errors': _("You are not authorized to see that " "page")}) query = db.session.query(Account) filter_string = params.get('q') + '%' query = query.filter( db.or_(Account.name.ilike(filter_string), Account.fullname.ilike(filter_string))) count = query.count() query = query.limit(params.get('pagesize')) query = query.offset( int((params.get('page') - 1) * params.get('pagesize'))) results = [dict(fullname=x.fullname, name=x.name) for x in list(query)] return to_jsonp({'results': results, 'count': count})
def distinct(self, dataset, dimension, format='json'): self._get_dimension(dataset, dimension) parser = DistinctParamParser(c.dimension, request.params) params, errors = parser.parse() if errors: response.status = 400 return {'errors': errors} q = params.get('attribute').column_alias.ilike(params.get('q') + '%') offset = int((params.get('page') - 1) * params.get('pagesize')) members = c.dimension.members(q, offset=offset, limit=params.get('pagesize')) return to_jsonp(list(members))
def complete(self, format='json'): self._disable_cache() parser = DistinctParamParser(request.params) params, errors = parser.parse() if errors: response.status = 400 return {'errors': errors} query = db.session.query(Account) filter_string = params.get('q') + '%' query = query.filter(db.or_(Account.name.ilike(filter_string), Account.fullname.ilike(filter_string))) count = query.count() query = query.limit(params.get('pagesize')) query = query.offset(int((params.get('page') - 1) * params.get('pagesize'))) return to_jsonp({ 'results': list(query), 'count': count })
def complete(self, format='json'): self._disable_cache() parser = DistinctParamParser(request.params) params, errors = parser.parse() if errors: response.status = 400 return {'errors': errors} query = db.session.query(Account) filter_string = params.get('q') + '%' query = query.filter(db.or_(Account.name.ilike(filter_string), Account.fullname.ilike(filter_string))) count = query.count() query = query.limit(params.get('pagesize')) query = query.offset(int((params.get('page') - 1) * params.get('pagesize'))) return to_jsonp({ 'results': list(query), 'count': count })