def get_boji_comment(comment_id):
c = db_session.query(BodhiComment).filter(BodhiComment.id == comment_id).first()
if request.method == 'GET':
comment = dict(date=str(c.date), update=c.title, text=c.text, user=c.username, karma=c.karma, send_email=c.send_email, id=c.id)
return render_template('comment_detail.html', comment = comment)
# stupid browsers not supporting HTTP delete calls ...
elif request.method == 'POST':
if request.form['request'] == 'DELETE':
db_session.delete(c)
db_session.commit()
flash('Comment %d was deleted' % comment_id)
return redirect(url_for('default_boji_comments'))
elif request.method == 'DELETE':
db_session.delete(c)
db_session.commit()
return (url_for('default_boji_comments'))
def get_comments(start=0, num_comments=NUM_PAGE):
c = db_session.query(BodhiComment).order_by(desc(BodhiComment.id)).slice(start, start+num_comments)
comments = [dict(date=str(row.date), update=row.title, text=row.text, user=row.username,
karma=row.karma, send_email=row.send_email, id=row.id ) for row in c]
return comments
def search_comments(update):
c = db_session.query(BodhiComment).filter(BodhiComment.title.like('%%%s%%' % update)).order_by(BodhiComment.id)
comments = [dict(date=str(row.date), update=row.title, text=row.text, user=row.username,
karma=row.karma, send_email=row.send_email, id=row.id) for row in c]
return comments
