def update_post(id):
body = request.form['body']
title = request.form['title']
title_pic = request.form['title_pic']
published = bool(int(request.form['published']))
post = Post.at(id).getone()
published_old = bool(int(post.published))
if not post.published: # only non-published posts update this field
post.published = published
post.body = body
post.title = title
post.title_pic = title_pic
rows_affected = post.save()
if rows_affected >= 0:
if not published_old and published: # published
flashx.success('Published successfully')
return redirect(url_for('post', id=post.id))
else:
flashx.success('Saved successfully')
if post.published:
return redirect(url_for('post', id=post.id))
else:
flashx.error('Something wrong when updating post')
return redirect(url_for('edit', id=post.id))
def delete(id):
query = Post.at(id).delete()
rows_affected = query.execute()
if rows_affected <= 0:
flashx.error('Something wrong when deleting post')
return redirect(url_for('edit', id=id))
else:
flashx.success('Delete post successfully')
return redirect(url_for('write'))
def post(id):
post = Post.at(id).getone()
if post is None:
abort(404)
setattr(post, 'html', markdown.render(post.body))
query = Post.where(Post.id._in(
Post.where(Post.id > id).select(fn.min(Post.id)),
Post.where(Post.id < id).select(fn.max(Post.id)),
)).select(Post.id, Post.title)
setattr(post, 'next', None)
setattr(post, 'prev', None)
for pst in query: # execute query
if pst.id > id:
post.next = pst
elif pst.id < id:
post.prev = pst
return render_public('post.html', post=post)
