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)
