def fetch_articles(userid=None): if userid != None: return False select = article_request(mode='select') select.commit() return select.result
def private_articles(): if "username" in session.keys(): pagenum = 1 if not request.args.get("p") else int(request.args.get("p")) directid = None if not request.args.get("direct") else request.args.get("direct") minnum = 8 * (pagenum - 1) maxnum = 8 * (pagenum) select = article_request( mode="select", user_id=session["userid"], direc_id=directid, min_num=str(minnum), max_num=str(maxnum) ) select.commit() directs = fetch_directs(session["userid"]) entries = [] pageover = False if select.result: entries = select.result print entries if len(select.result) <= 7: pageover = True else: pageover = True entries = (("", "", u"", "", u"没有更多文章了,请添加文章!!!", "", ""),) return render_template("private_articles.html", entries=entries, directors=directs, pageover=pageover) return redirect(url_for("login", next="private_articles"))
def view_article(): directs = fetch_directs(session["userid"]) articleid = request.args.get("articleid") direcid = request.args.get("direcid") select = article_request(mode="select", article_id=articleid, direc_id=direcid, user_id=session["userid"]) select.commit() return render_template("view_article.html", entry=select.result[0], author=session["username"], directors=directs)
def create_article(): directs = fetch_directs(session["userid"]) if not session.get("logged_in"): # abort(401) flash("please login first") return redirect(url_for("index")) form = ArticleForm() if request.method == "POST": article_content = request.form["content"] insert = article_request( mode="insert", direc_id=form.directorid.data, article_name=form.articlename.data, content=article_content, status=form.articlestatus.data, priority=1, ) insert.commit() if insert.result: flash("New entry was successfully posted") return redirect(url_for("private_articles")) else: flash(insert.sqlstr) elif request.method == "GET": select = director_request(mode="select", user_id=session["userid"]) select.commit() form.directorid.choices = [] for i in select.result: form.directorid.choices.append((i[1], i[2])) return render_template("private_articles.html", forms=form, directors=directs)