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)
