def index(): from models import GuestBookItem from forms import GuestBookForm if request.method == 'POST': print(request.form) form = GuestBookForm(request.form) if form.validate(): item = GuestBookItem(**form.data) db.session.add(item) db.session.commit() flash('Post created!') else: flash('Form is not valid! Post was not created.') flash(str(form.errors)) posts = GuestBookItem.query.all() for post in posts: author = post.author content = post.content return '{} {}'.format(author, content)
def guestbook(): form = GuestBookForm() if form.validate_on_submit(): nickname = form.nickname.data text = form.text.data email = form.email.data guesttext = GuestBook(nickname, text, email) db.session.add(guesttext) db.session.commit() return redirect(url_for('guestbook')) # 查询数据 guestbook = GuestBook.query.all() # guestbook = GuestBook.query.filter_by(id=2).first() # guestbook = GuestBook.query.filter_by(nickname='aaa1') # 修改数据 # guestbook = GuestBook.query.filter_by(id=2).first() # guestbook.nickname='aaa2' # guestbook.email='*****@*****.**' # db.session.add(guestbook) # db.session.commit() # 批量修改数据 # guestbook = GuestBook.query.all() # for data in guestbook: # if data.id == 2: # data.nickname = data.nickname+'3' # db.session.add(data) # db.session.commit() # print guestbook return render_template('guestbook.html', title='留言簿', form=form, guestbook=guestbook)