def modify(todolist_id): form_t = TodoListForm() form_m = ModifyForm() todolist = TodoList.query.get_or_404(todolist_id) if form_m.validate_on_submit(): #???????????????? #此处要用正则才能取得所需数据 # content=re.findall(regex,str(form_m.content))[0] # todolist.content=u'%s' % content #如果使用下面这句代码替代上述2句,提交的结果是一个html标记 #todolist.content = u'%s' % str(form_m.content) #????????????????? todolist.content = request.form['content'] db.session.add(todolist) db.session.commit() return redirect(url_for('index')) #todolists=TodoList.query.all() page_index = request.args.get('page', 1, type=int) query = TodoList.query.order_by(TodoList.create_time.desc()) pagination = query.paginate(page_index, per_page=10, error_out=False) todolists = pagination.items return render_template('index.html', todolists=todolists, form=form_t, form_m=form_m, pagination=pagination)
def modify(): """Processes new-found movie form data and adds it to database""" form = ModifyForm() if form.validate_on_submit(): movie = form.name.data # Get movie data and put it to our database rotten_url = 'http://api.rottentomatoes.com/api/public/v1.0/movies/{!s}.json?apikey={!s}'.format(movie, ROTTEN_KEY) req = urllib2.Request(rotten_url, headers={'Accept-Encoding': 'gzip, identity'}) conn = urllib2.urlopen(req) movie = conn.read() try: if conn.headers['content-encoding'] == 'gzip': movie = zlib.decompress(movie, 16+zlib.MAX_WBITS) except KeyError: pass movie = json.loads(movie) description = movie['synopsis'] genres = movie['genres'] # Put all genres in a string final = "" counter = 1 for genre in genres: final += genre if len(genres) > 1 and counter < len(genres): final += ', ' counter += 1 genres = final # Rest of the stuff ratings = movie['ratings'] ratings = ratings.get('audience_score') posters = movie['posters'] posters = posters.get('thumbnail') movie = movie['title'] ticketid = form.id.data # Just dump it to database querymovie = Movie.query.filter_by(id = ticketid).first() querymovie.status = 2 querymovie.description = description querymovie.genres = genres querymovie.ratings = ratings querymovie.posters = posters querymovie.name = movie db.session.commit() flash(movie+' added!') items = Movie.query.filter_by(status = 1).all() return render_template('modify.html', form = form, items = items)
def change_paste(id): if request.method == "GET": pasteList = PasteText.query.filter_by(id=id).first_or_404() form = ModifyForm() form.content.data = pasteList.content return render_template("modify.html", form=form) else: form = ModifyForm() if form.validate_on_submit(): pasteList = PasteText.query.filter_by(id=id).first_or_404() pasteList.content = form.content.data pasteList.status = form.status.data db.session.commit() flash("You have modify a pasteList") else: flash(form.errors) return redirect(url_for("show_paste_list"))
def erecord(): status = request.args.get('status') allnum = db.session.query(Erecord).count() nsolvenum = db.session.query(Erecord).filter( Erecord.solve == False).count() nverifynum = db.session.query(Erecord).filter( Erecord.verify == False).count() oknum = db.session.query(Erecord).filter(Erecord.verify == True).filter( Erecord.mender != '').filter(Erecord.solve == True).count() nobody = db.session.query(Erecord).filter(Erecord.mender == '').count() print status if status == '2': results = db.session.query(Erecord).filter( Erecord.verify == False).order_by(-Erecord.id) elif status == '3': results = db.session.query(Erecord).filter( Erecord.solve == False).order_by(-Erecord.id) elif status == '4': results = db.session.query(Erecord).filter( Erecord.verify == True).filter(Erecord.mender != '').filter( Erecord.solve == True).order_by(-Erecord.id) elif status == '5': results = db.session.query(Erecord).filter( Erecord.mender == '').order_by(-Erecord.id) else: results = db.session.query(Erecord).order_by(-Erecord.id) form = ModifyForm() if form.validate_on_submit(): return redirect(url_for('admin.emodify', id=form.id.data)) return render_template('admin/erecord.html', results=results, form=form, nsolvenum=nsolvenum, nverifynum=nverifynum, oknum=oknum, allnum=allnum, nobody=nobody)
def record(): results = db.session.query(Record).order_by(-Record.id) form = ModifyForm() if form.validate_on_submit(): return redirect(url_for('admin.modify', id=form.id.data)) return render_template('admin/record.html', results=results, form=form)
def comment(): comment = db.session.query(Comment).order_by(-Comment.id) form = ModifyForm() if form.validate_on_submit(): return redirect(url_for('admin.commentmodify', id=form.id.data)) return render_template('admin/comment.html', form=form, comment=comment)