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
})