Beispiel #1
0
    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')
Beispiel #2
0
    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')
Beispiel #3
0
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
Beispiel #4
0
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