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)
def fetch_directs(userid,pare_direct=None): select = director_request(mode='select',user_id=userid) select.commit() #if pare_direct == None: return select.result