app.py 文件源码

def  showDetailedIssue(I_Id):
    if 'logged_in' not in login_session:
        flash('You need to login first.')
        return redirect(url_for('login'))
    else:
        showDetailedIssue = session.query(Issue).filter_by(id = I_Id).one()
        showDetailedComment = session.query(Comment).filter_by(id = I_Id).order_by(asc(Comment.sqNo)).all()
        showDetailedUser= session.query(User).filter_by(id= showDetailedIssue.author).one()
        Author=showDetailedUser.name
        #temporarily harcoding the likes and dislikes part
        like=showDetailedIssue.like
        dislike=showDetailedIssue.dislike
        #showDetailedVote = session.query(Issue).filter_by(id = I_Id).all()
        #showDetailedVote = session,query(func.count())   SELECT count(*) 
        #    FROM (SELECT V_flag FROM Votes where V_IssueId = %s AND V_flag = true)
        # AS likes  GROUP BY V_flag;""",(I_Id,))
        if showDetailedIssue.anonFlag == 1:
           Author="Anonymous"
        return render_template('showdetailedissue.html', Issue=showDetailedIssue, Comment=showDetailedComment, like=like, dislike=dislike, Author=Author)