def test_sort_query(self): query = Document.query sort_string = "title desc" doc_query = filters.sort_query(query, Document, sort_string) self.assertEqual(doc_query[0].title, 'Title 3') sort_string = "title asc" doc_query = filters.sort_query(query, Document, sort_string) self.assertEqual(doc_query[-1].title, 'Title 3')
def get_users(): page = request.args.get("page") rows = request.args.get("rows") sort = request.args.get("sort") user = helpers.get_user() xhr = MakeResponse() if not user.is_admin: xhr.set_error(401, "You must be an admin.") return xhr.response query = User.query count = query.count() query = filters.sort_query(query, User, sort) query = filters.limit_and_offset(query, page=page, rows=rows) users = query.all() users = [u.to_dict(include="is_admin") for u in users] result = helpers.format_result(users, page, rows, count) xhr = MakeResponse(200, body=result) return xhr.response
def get_users(): page = request.args.get('page') rows = request.args.get('rows') sort = request.args.get('sort') user = helpers.get_user() xhr = MakeResponse() if not user.is_admin: xhr.set_error(401, "You must be an admin.") return xhr.response query = User.query count = query.count() query = filters.sort_query(query, User, sort) query = filters.limit_and_offset(query, page=page, rows=rows) users = query.all() users = [u.to_dict(include='is_admin') for u in users] result = helpers.format_result(users, page, rows, count) xhr = MakeResponse(200, body=result) return xhr.response