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)
