

def get_new_message_num(id):
    user = users.get_user_by_id(id)
    epistle_num = dbsession.query(Epistle).filter((user.id == Epistle.recipient)).filter((Epistle.unread == True)).count()
    comment_num = dbsession.query(Comment).filter(sqlalchemy.and_((user.id == Comment.in_reply_to), (user.id != Comment.user_id))).filter((Comment.unread == True)).count()
    return (epistle_num + comment_num)

dataset/ETHPy150Open sjuxax/raggregate/raggregate/queries/epistle.py get_new_message_num/original