def publishPost(postId): database.execute(sql=""" UPDATE post SET postStatusId=(SELECT id FROM poststatus WHERE status='Published' LIMIT 1) , publishedDateTime=CASE WHEN publishedDateTime IS NULL THEN %s ELSE publishedDateTime END , publishedYear=CASE WHEN publishedYear IS NULL THEN %s ELSE publishedYear END , publishedMonth=CASE WHEN publishedMonth IS NULL THEN %s ELSE publishedMonth END WHERE id=%s """, parameters=( dthelper.formatDateTime(date=dthelper.utcNow()), dthelper.getYear(date=dthelper.utcNow()), dthelper.getMonth(date=dthelper.utcNow()), postId, )) return database.LAST_NUM_AFFECTED
def adminEditPost(id=0): success = True message = "" mode = "" if "btnDraft" in request.all: mode = "Draft" if "btnPublish" in request.all: mode = "Published" if mode != "": post = postservice.updatePost( id = id, title = request.all["postTitle"], slug = request.all["postSlug"], content = request.all["postContent"], tags = request.all["postTags"], status = mode, publishedDateTime = dthelper.utcNow() if mode == "Published" else None, publishedYear = dthelper.utcNow() if mode == "Published" else None, publishedMonth = dthelper.utcNow() if mode == "Published" else None ) message = "Your post has been updated and %s successfully." % ("saved as a draft" if mode == "Draft" else "published") redirect("/admin/posts/" + message) else: post = postservice.getPostById(id=id) return { "title": "Write Post", "success": success, "message": message, "id": post["id"], "postTitle": post["title"], "postSlug": post["slug"], "postTags": post["tagList"], "postContent": post["content"], }
def adminWritePost(): success = True message = "" mode = "" if "btnDraft" in request.all: mode = "draft" if "btnPublish" in request.all: mode = "publish" if mode != "": post = postservice.createPost( title = request.all["postTitle"], author = request.session["user"], slug = request.all["postSlug"], content = request.all["postContent"], createdDateTime = dthelper.utcNow(), tags = request.all["postTags"], status = postservice.getPostStatus(status=("Draft" if mode == "draft" else "Published")), publishedDateTime = dthelper.utcNow() if mode == "publish" else None, publishedYear = dthelper.utcNow() if mode == "publish" else None, publishedMonth = dthelper.utcNow() if mode == "publish" else None ) message = "Your post has been %s." % ("saved as a draft" if mode == "draft" else "published") redirect("/admin/posts/" + message) return { "title": "Write Post", "success": success, "message": message, "postTitle": "" if not "postTitle" in request.all else request.all["postTitle"], "postSlug": "" if not "postSlug" in request.all else request.all["postSlug"], "postTags": "" if not "postTags" in request.all else request.all["postTags"], "postContent": "" if not "postContent" in request.all else request.all["postContent"], }