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)
