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)