def api_get_users(*, page='1'): page_index = get_page_index(page) num = yield from User.findNumber('count(id)') p = Page(num, page_index) if num == 0: return dict(page=p, users=()) 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)
async def index(*, page='1'): page_index = get_page_index(page) num = await Blog.findNumber('count(id)') p = Page(num, page_index) if num == 0: blogs = [] else: blogs = await Blog.findAll(orderBy='created_at desc', limit=(p.offset, p.limit)) return {'__template__': 'blogs.html', 'page': p, 'blogs': blogs}
async def api_blogs(*, page='1'): page_index = get_page_index(page) num = await Blog.findNumber('count(id)') p = Page(num, page_index) if num == 0: return dict(page=p, blogs=()) blogs = await Blog.findAll(orderBy='created_at desc', limit=(p.offset, p.limit) ) # 从第offset+1个开始取limit个 return dict(page=p, blogs=blogs)
async def api_comments(*, page="1"): page_index = get_page_index(page) num = await Comment.findCount('id') p = Page(num, page_index) if num == 0: return dict(page=p, comments=()) comments = await Comment.findAll(orderby="create_time desc", limit=(p.offset, p.limit)) return dict(page=p, comments=comments)
def api_get_users(): total = User.count_all() page = Page(total, _get_page_index()) # 如果sql语句语法错误,会提示Programming Error, 比如created_at 写成 create_at就会有这个错误 users = User.find_by('order by created_at desc limit ?,?', page.offset, page.limit) for u in users: u.password = '******' return dict(users=users, page=page)
async def api_blogs(*, page='1'): page_index = get_page_index(page) num = await Blog.findNumber('count(id)') p = Page(item_count=num, page_index=page_index) if num == 0: return dict(page=p, blogs=()) blogs = await Blog.findAll(order_by="create_time desc", limit=(p.offset, p.limit)) return dict(page=p, blogs=blogs)
def api_comments(*, page='1'): # 根据page获取评论,注释可参考 index 函数的注释,不细写了 page_index = get_page_index(page) num = yield from Comment.findNumber('count(id)') p = Page(num, page_index) if num == 0: return dict(page=p, comments=()) comments = yield from Comment.findAll(orderBy='created_at desc', limit=(p.offset, p.limit)) return dict(page=p, comments=comments)
async def api_users(*, page=1): page_index = get_page_index(page) num = await User.findNumber('count(id)') # 建立Page类分页 p = Page(item_count=num, page_index=page_index) if num == 0: return dict(page=p, users=()) users = await User.findAll(orderBy='created_at desc', limit=(p.offset, p.limit)) return dict(page=p, users=users)
def manage_users(): page = request.args.get('page', '1') page_index = get_page_index(page) with db_session: num = len(select(u for u in User)[:]) p = Page(num, page_index) with db_session: users = select(u for u in User).order_by(User.created_at)[p.offset: p.limit+p.offset] user = cookie2user() return render_template('manage_users.html', page_index=page_index, user=user)
def manage_comments(): page = request.args.get('page', '1') page_index = get_page_index(page) user = cookie2user() with db_session: num = len(select(c for c in Comment)[:]) p = Page(num, page_index) with db_session: comments = select(c for c in Comment).order_by(Comment.created_at)[p.offset: p.limit+p.offset] return render_template('manage_comments.html', page_index=page_index, user=user)
async def api_blogs(*,page='1'):#为什么page用str呢 page_index=get_page_index(page) num=await Blog.findNumber('count(id)') p=Page(num,page_index) if num==0: return dict(page=p,blogs=())#为什么空blog用空元组呢 blogs=await Blog.findAll(orderBy='created_at desc',limit=(p.offset,p.limit)) # for blog in blogs: # logging.info(blog) return dict(page=p,blogs=blogs)
async def api_users(*, page='1'): ''' user 管理一览 ''' page_index = get_page_index(page) num = await User.findNumber('count(id)') p = Page(num, page_index) if num == 0: return dict(page=p, users=()) users = await User.findAll(orderBy='created_at desc', limit=(p.offset, p.limit)) return dict(page=p, users=users)
async def api_users(*, page='1'): num = await User.findNumber('count(id)') p = Page(num, get_page_index(page)) if num == 0: return dict(page=p, users=()) users = await User.findAll(orderBy='created_at desc', limit=(p.offset, p.limit)) for u in users: u.passwd = '******' return dict(page=p, users=users)
async def api_get_users(*, page='1'): page_index = get_page_index(page) num = await User.findNumber('count(id)') p = Page(num, page_index) if num == 0: return dict(page=p, users=()) users = await User.findAll(orderBy='created_at desc') for u in users: u.passwd = '*******' return dict(users=users)
def api_blogs(*, page='1'): # 获取博客信息 page_index = get_page_index(page) num = yield from Blog.findNumber('count(id)') p = Page(num, page_index) if num == 0: return dict(page=p, blogs=()) blogs = yield from Blog.findAll(orderBy='created_at desc', limit=(p.offset, p.limit)) return dict(page=p, blogs=blogs)
async def api_comments(*, page='1'): '''获取评论''' page_index = get_page_index(page) num = await Comment.findNumber('count(id)') p = Page(num, page_index) print('get comments:',num) if num == 0: return dict(page=p, comments=()) comments = await Comment.findAll(orderBy='created_at desc', limit=(p.offset, p.limit)) return dict(page=p, comments=comments)
def index(*, page='1'): page_index = get_page_index(page) num = yield from Blog.findNumber('count(id)') page = Page(num) if num == 0: blogs = [] else: blogs = yield from Blog.findAll(orderBy='create_at desc', limit=(page.offset, page.limit)) return {'__template__': 'blogs.html', 'page': page, 'blogs': blogs}
def get_blogs(*, p_index=1): int_index = get_page_index(p_index) num = yield from Blog.findNumber('count(id)') p = Page(num, int_index, page_size=5) if num == 0: return dict(page=p, blogs=()) blogs = yield from Blog.findAll(orderBy='created_at desc', limit=(p.offset, p.limit)) return dict(page=p, blogs=blogs)
def api_comments(*, page="1"): page_index = get_page_index(page) num = yield from Comment.findNumber('count(id)') # num为评论总数 p = Page(num, page_index) # 创建page对象, 保存页面信息 if num == 0: return dict(page=p, comments=()) # 若评论数0,返回字典,将被app.py的response中间件再处理 # 博客总数不为0,则从数据库中抓取博客 # limit强制select语句返回指定的记录数,前一个参数为偏移量,后一个参数为记录的最大数目 comments = yield from Comment.findAll(orderBy="created_at desc", limit=(p.offset, p.limit)) return dict(page=p, comments=comments) # 返回字典,以供response中间件处理
def api_get_users(*, page="1"): page_index = get_page_index(page) num = yield from User.findNumber("count(id)") p = Page(num, page_index) if num == 0: return dict(page=p, users=()) users = yield from User.findAll(orderBy="created_at desc") for u in users: u.passwd = "*****" # 以dict形式返回,并且未指定__template__,将被app.py的response factory处理为json return dict(page=p, users=users)
def api_blogs(*, page='1'): page_index = get_page_index(page) num = yield from Blog.findNumber('count(id)') # num为博客总数 p = Page(num, page_index) # 创建page对象 if num == 0: return dict(page=p, blogs=()) # 若博客数为0,返回字典,将被app.py的response中间件再处理 # 博客总数不为0,则从数据库中抓取博客 # limit强制select语句返回指定的记录数,前一个参数为偏移量,后一个参数为记录的最大数目 blogs = yield from Blog.findAll(orderBy="created_at desc", limit=(p.offset, p.limit)) return dict(page=p, blogs=blogs) # 返回字典,以供response中间件处理
async def landscape(*, page='1'): page_index = get_page_index(page) num = await Blog.findNumber('count(id)', where='`classification`="生活"') p = Page(num, page_index) if num == 0: blogs = [] else: blogs = await Blog.findAll(orderBy='created_at desc', where='`classification`="生活"', limit=(p.offset, p.limit)) return {'__template__': 'life.html', 'page': p, 'blogs': blogs}
async def index(*, page='1'): #这里的参数经过RequestHandler()解析,添加上真正存在的值,以供该方法内部直接使用。 page_index = get_page_index(page) num = await Blog.findNumber('count(id)') page = Page(num, page_index) if page.item_count == 0: blogs = [] else: blogs = await Blog.findAll(orderBy='created_at desc', limit=(page.offset, page.limit)) return {'__template__': 'blogs.html', 'page': page, 'blogs': blogs}
def api_blogs(*, page="1"): page_index = get_page_index(page) num = yield from Blog.findNumber("count(id)") p = Page(num, page_index) if num == 0: return dict(page=p, blogs=()) blogs = yield from Blog.findall(orderBy="created_at desc", limit=(p.offset, p.limit)) return dict(page=p, blogs=blogs)
async def api_blogs(*, page='1'): page_index = get_page_index(page) # query database to get total number of blogs num = await Blog.findNumber('count(id)') p = Page(num, page_index) if num == 0: return dict(page=p, blogs=blogs()) blogs = await Blog.findAll(orderBy='created_at desc', limit=(p.offset, p.limit)) return dict(page=p, blogs=blogs)
async def api_landscape(*, page='1'): page_index = get_page_index(page) num = await Blog.findNumber('count(id)', where='tag', regexp="'landscape'") p = Page(num, page_index) if num == 0: return dict(page=p, blogs=()) blogs = await Blog.findAll(where='tag', regexp="'landscape'", orderBy='created_at desc', limit=(p.offset, p.limit)) return dict(page=p, blogs=blogs)
def api_comments(*, page='1'): #获取页面索引,默认为1: page_index = get_page_index(page) #查询数据库中Comment表中评论总数: num = yield from Comment.findNumber('count(id)') p = Page(num, page_index) if num == 0: return dict(page=p, comments=()) comments = yield from Comment.findAll(orderBy='created_at desc', limit=(p.offset, p.limit)) return dict(page=p, comments=comments)
def api_blogs(*, page='1'): page_index = get_page_index(page) num = yield from Blog.findNumber( 'count(id)' ) # Mysql函数: count(列名)---只包括列名指定列,返回指定列的记录数,这里返回的就是id这一列的行数,也就是blog的数量 p = Page(num, page_index) if num == 0: return dict(page=p, blogs=()) blogs = yield from Blog.findAll(orderBy='created_at desc', limit=(p.offset, p.limit)) return dict(page=p, blogs=blogs)
async def api_get_users(*, page='1'): page_index = get_page_index(page) num = await User.findNumber('count(id)') page = Page(num, page_index) if num == 0: return dict(page=page, users=()) users = await User.findAll(orderBy='created_at desc', limit=(page.offset, page.limit)) for user in users: user.password = '******' return dict(page=page, users=users)
def api_blogs(*, page='1'): # page由html传入 page_index = get_page_index(page) num = yield from Blog.findNumber('count(id)') # num为博客总数 p = Page(num, page_index) # 创建Page对象(Page对象在apis.py中定义) if num == 0: return dict(page_obj=p, blogs=()) # 若博客数为0, 则手动创建页面对象和空的博客tuple # 博客总数不为0,则从数据库中抓取博客 # limit强制select语句返回指定的记录数,前一个参数为偏移量,后一个参数为该页显示的最大数目,limit由第offset+1开始显示 blogs = yield from Blog.findAll(orderBy='created_at desc', limit=(p.offset, p.limit)) return dict(page_obj=p, blogs=blogs)