def apiGetUsers(*, page='1'): pageIndex = getPageIndex(page) num = yield from User.findNumber('count(id)') p = Page(num, pageIndex) if num == 0: return dict(page=p, users=()) users = yield from User.findAll(orderBy='createTime desc', limit=(p.offset, p.limit)) for u in users: u.password = '******' return dict(page=p, users=users)
def api_get_users(*, page='1'): #获取页面索引,默认为1: page_index = get_page_index(page) #查询数据库中User表中用户总数: num = yield from User.findNumber('count(id)') p = Page(num, page_index) if num == 0: return dict(page=p, users=()) #查询数据库中User表中对应分页的用户结果;(limit为mysql的分页查询条件) users = yield from User.findAll(orderBy='created_at desc', limit=(p.offset, p.limit)) for u in users: u.passwd = '******' return dict(page=p, users=users)