def new(): pcfg = {"title": "New note"} form = NoteForm() if form.validate_on_submit(): a = Note() a.title = form.title.data a.cat = form.cat.data a.note = form.note.data a.user_id = current_user.id db.session.add(a) db.session.commit() flash("Success updating note: {0}".format(a.title), "success") return redirect(url_for("bp_notes.notes")) logbooks = (db.session.query(Logbook.id, Logbook.name, func.count( Log.id)).join(Log).filter(Logbook.user_id == current_user.id).group_by( Logbook.id).all()) return render_template("notes/new.jinja2", pcfg=pcfg, form=form, logbooks=logbooks)