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