def _get_users_by_page():
"""
:return:users, page
"""
total = Users.count_all()
page = Page(total, _get_page_index(), 5)
users = Users.find_by('order by created_at desc limit ?,?', page.offset, page.limit)
return users, page
def route_weibo_new(request):
headers = {
'Content-Type': 'text/html',
}
username = current_user(request)
header = response_with_headers(headers)
user = Users.find_by(username=username)
body = template('weibo_new.html')
r = header + '\r\n' + body
return r.encode(encoding='utf-8')
def route_weibo_index(request):
headers = {
'Content-Type': 'text/html',
}
header = response_with_headers(headers)
user_id = request.query.get('user_id', -1)
user_id = int(user_id)
user = Users.find(user_id)
if user is None:
return error(request)
# 找到 user 发布的所有 weibo
weibos = Weibo.find_all(user_id=user_id)
log('weibos', weibos)
current_username = current_user(request)
u = Users.find_by(username=current_username)
if u is None:
return redirect('/login')
def weibo_tag(weibo):
comment_list = Comment.find_all(weibo_id=weibo.id)
comments = '<br>'.join([c.content for c in comment_list])
w = {
"id": weibo.id,
"user_id": u.id,
"content": weibo.content,
"username": user.username,
"time": weibo.created_time,
"comments": comments,
}
log('comments debug', comment_list)
return """
<p>{content} from {username}@{time}
<a href="/weibo/delete?id={id}">删除</a>
<a href="/weibo/edit?id={id}">修改</a>
<button class="gua-show-comment" data-id="{id}">评论</button>
<div>
{comments}
</div>
<div id="id-div-comment-{id}" class="gua-comment-form gua-hide">
<form action="/weibo/comment/add" method="post">
<input name="user_id" value="{user_id}" type="hidden">
<input name="weibo_id" value="{id}" type="hidden">
<textarea name="content"></textarea>
<button type="submit">添加评论</button>
</form>
</div>
</p>
""".format(**w)
weibos = '\n'.join([weibo_tag(w) for w in weibos])
body = template('weibo_index.html', weibos=weibos)
r = header + '\r\n' + body
return r.encode(encoding='utf-8')
def route_weibo_add(request):
headers = {
'Content-Type': 'text/html',
}
username = current_user(request)
header = response_with_headers(headers)
user = Users.find_by(username=username)
# 创建微博
form = request.form()
w = Weibo(form)
w.user_id = user.id
w.save()
return redirect('/weibo?user_id={}'.format(user.id))
def route_weibo_update(request):
username = current_user(request)
user = Users.find_by(username=username)
form = request.form()
content = form.get('content', '')
weibo_id = int(form.get('id', -1))
w = Weibo.find(weibo_id)
if user.id != w.user_id:
return error(request)
w.content = content
w.save()
# 重定向到用户的主页
return redirect('/weibo?user_id={}'.format(user.id))
def route_weibo_delete(request):
headers = {
'Content-Type': 'text/html',
}
username = current_user(request)
header = response_with_headers(headers)
user = Users.find_by(username=username)
# 删除微博
weibo_id = request.query.get('id', None)
weibo_id = int(weibo_id)
w = Weibo.find(weibo_id)
w.delete()
return redirect('/weibo?user_id={}'.format(user.id))
def api_get_users():
users = Users.find_by('order by created_at desc')
for u in users:
u.password = '******'
return dict(users=users)