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)
def add(): if request.method == 'POST': form = GuestBookForm(request.form) if form.validate_on_submit(): form = form.description.data form = form.replace(" ", "_") form = form.replace("!", "") post(form) return redirect(url_for('main')) else: return "must have some content" else: return "post only"
def create(request): if request.POST: form = GuestBookForm(request.POST) if form.is_valid(): form.save() return HttpResponseRedirect('/guestbookdetails/success') else: form = GuestBookForm() args = {} args.update(csrf(request)) args[ 'form' ] = form return render_to_response('create_guestbook.html',args) args = {} args.update(crsf(request)) args['form'] = form return render_to_response('create_guestbook.html',args)
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)