== notification) \

                        .one()

                Session().delete(obj)

                return True

        except Exception:

            log.error(traceback.format_exc())

            raise

    def query_for_user(self, user, filter_=None):

        """

        Get notifications for given user, filter them if filter dict is given

        :param user:

        :param filter:

        """

        user = User.guess_instance(user)

        q = UserNotification.query() \

            .filter(UserNotification.user == user) \

            .join((Notification, UserNotification.notification_id ==

                                 Notification.notification_id)) \

            .options(joinedload('notification')) \

            .options(subqueryload('notification.created_by_user')) \

            .order_by(Notification.created_on.desc())

        if filter_:

            q = q.filter(Notification.type_.in_(filter_))

        return q

    def mark_read(self, user, notification):

        try:

            notification = Notification.guess_instance(notification)

            user = User.guess_instance(user)

            if notification and user:

                obj = UserNotification.query() \

                        .filter(UserNotification.user == user) \

                        .filter(UserNotification.notification

                                == notification) \

                        .one()

                obj.read = True

                return True

        except Exception:

            log.error(traceback.format_exc())

            raise

    def mark_all_read_for_user(self, user, filter_=None):

        user = User.guess_instance(user)

        q = UserNotification.query() \

            .filter(UserNotification.user == user) \

            .filter(UserNotification.read == False) \

            .join((Notification, UserNotification.notification_id ==

                                 Notification.notification_id))

        if filter_:

            q = q.filter(Notification.type_.in_(filter_))

        # this is a little inefficient but sqlalchemy doesn't support

        # update on joined tables :(

        for obj in q:

            obj.read = True

    def get_unread_cnt_for_user(self, user):

        user = User.guess_instance(user)

        return UserNotification.query() \

                .filter(UserNotification.read == False) \

                .filter(UserNotification.user == user).count()

    def get_unread_for_user(self, user):

        user = User.guess_instance(user)

        return [x.notification for x in UserNotification.query() \

                .filter(UserNotification.read == False) \

                .filter(UserNotification.user == user).all()]

    def get_user_notification(self, user, notification):

        user = User.guess_instance(user)

        notification = Notification.guess_instance(notification)

        return UserNotification.query() \

            .filter(UserNotification.notification == notification) \

            .filter(UserNotification.user == user).scalar()

    def make_description(self, notification, show_age=True):

        """

        Creates a human readable description based on properties

        of notification object

        """

        # alias

        _n = notification

        if show_age:

            return {

                    _n.TYPE_CHANGESET_COMMENT: _('%(user)s commented on changeset %(age)s'),

                    _n.TYPE_MESSAGE: _('%(user)s sent message %(age)s'),

                    _n.TYPE_MENTION: _('%(user)s mentioned you %(age)s'),

                    _n.TYPE_REGISTRATION: _('%(user)s registered in Kallithea %(age)s'),

                    _n.TYPE_PULL_REQUEST: _('%(user)s opened new pull request %(age)s'),

                    _n.TYPE_PULL_REQUEST_COMMENT: _('%(user)s commented on pull request %(age)s'),

                }[notification.type_] % dict(

                    user=notification.created_by_user.username,

                    age=h.age(notification.created_on),

                )

        else:

            return {

                    _n.TYPE_CHANGESET_COMMENT: _('%(user)s commented on changeset at %(when)s'),

                    _n.TYPE_MESSAGE: _('%(user)s sent message at %(when)s'),

                    _n.TYPE_MENTION: _('%(user)s mentioned you at %(when)s'),

                    _n.TYPE_REGISTRATION: _('%(user)s registered in Kallithea at %(when)s'),

                    _n.TYPE_PULL_REQUEST: _('%(user)s opened new pull request at %(when)s'),

                    _n.TYPE_PULL_REQUEST_COMMENT: _('%(user)s commented on pull request at %(when)s'),

                }[notification.type_] % dict(

                    user=notification.created_by_user.username,

                    when=h.fmt_date(notification.created_on),

                )

class EmailNotificationModel(object):

    TYPE_CHANGESET_COMMENT = Notification.TYPE_CHANGESET_COMMENT

    TYPE_MESSAGE = Notification.TYPE_MESSAGE # only used for testing

    # Notification.TYPE_MENTION is not used

    TYPE_PASSWORD_RESET = 'password_link'

    TYPE_REGISTRATION = Notification.TYPE_REGISTRATION

    TYPE_PULL_REQUEST = Notification.TYPE_PULL_REQUEST

    TYPE_PULL_REQUEST_COMMENT = Notification.TYPE_PULL_REQUEST_COMMENT

    TYPE_DEFAULT = 'default'

    def __init__(self):

        super(EmailNotificationModel, self).__init__()

        self._template_root = kallithea.CONFIG['paths']['templates'][0]

        self._tmpl_lookup = app_globals.mako_lookup

        self.email_types = {

            self.TYPE_CHANGESET_COMMENT: 'changeset_comment',

            self.TYPE_PASSWORD_RESET: 'password_reset',

            self.TYPE_REGISTRATION: 'registration',

            self.TYPE_DEFAULT: 'default',

            self.TYPE_PULL_REQUEST: 'pull_request',

            self.TYPE_PULL_REQUEST_COMMENT: 'pull_request_comment',

        }

        self._subj_map = {

            self.TYPE_CHANGESET_COMMENT: _('[Comment] %(repo_name)s changeset %(short_id)s "%(message_short)s" on %(branch)s'),

            self.TYPE_MESSAGE: 'Test Message',

            # self.TYPE_PASSWORD_RESET

            self.TYPE_REGISTRATION: _('New user %(new_username)s registered'),

            # self.TYPE_DEFAULT

            self.TYPE_PULL_REQUEST: _('[Review] %(repo_name)s PR %(pr_nice_id)s "%(pr_title_short)s" from %(pr_source_branch)s by %(pr_owner_username)s'),

            self.TYPE_PULL_REQUEST_COMMENT: _('[Comment] %(repo_name)s PR %(pr_nice_id)s "%(pr_title_short)s" from %(pr_source_branch)s by %(pr_owner_username)s'),

        }

    def get_email_description(self, type_, **kwargs):

        """

        return subject for email based on given type

        """

        tmpl = self._subj_map[type_]

        try:

            subj = tmpl % kwargs

        except KeyError as e:

            log.error('error generating email subject for %r from %s: %s', type_, ','.join(self._subj_map.keys()), e)

            raise

        l = [safe_unicode(x) for x in [kwargs.get('status_change'), kwargs.get('closing_pr') and _('Closing')] if x]

        if l:

            if subj.startswith('['):

                subj = '[' + ', '.join(l) + ': ' + subj[1:]

            else:

                subj = '[' + ', '.join(l) + '] ' + subj

        return subj

    def get_email_tmpl(self, type_, content_type, **kwargs):

        """

        return generated template for email based on given type

        """

        base = 'email_templates/' + self.email_types.get(type_, self.email_types[self.TYPE_DEFAULT]) + '.' + content_type

        email_template = self._tmpl_lookup.get_template(base)

        # translator and helpers inject

        _kwargs = {'_': _,

                   'h': h,

                   'c': c}

        _kwargs.update(kwargs)

        if content_type == 'html':

            _kwargs.update({

                "color_text": "#202020",

                "color_emph": "#395fa0",

                "color_link": "#395fa0",

                "color_border": "#ddd",

                "color_background_grey": "#f9f9f9",

                "color_button": "#395fa0",

                "monospace_style": "font-family:Lucida Console,Consolas,Monaco,Inconsolata,Liberation Mono,monospace",

                "sans_style": "font-family:Helvetica,Arial,sans-serif",

                })

            _kwargs.update({

                "default_style": "%(sans_style)s;font-weight:200;font-size:14px;line-height:17px;color:%(color_text)s" % _kwargs,

                "comment_style": "%(monospace_style)s;white-space:pre-wrap" % _kwargs,

                "emph_style": "font-weight:600;color:%(color_emph)s" % _kwargs,

                "link_style": "color:%(color_link)s;text-decoration:none" % _kwargs,

                })

        log.debug('rendering tmpl %s with kwargs %s', base, _kwargs)

        return email_template.render_unicode(**_kwargs)

<%inherit file="main.html"/>\

\

<%block name="header">\

<% title = _('Mention in Comment on Changeset "%s"') % h.shorter(message, 200, firstline=True) if is_mention else _('Comment on Changeset "%s"') % h.shorter(message, 200, firstline=True) %>\

<%include file="header.html" args="title=title,link=cs_comment_url"/>\

</%block>\

\

<table cellpadding="0" cellspacing="0" border="0" width="100%">

    <tr>

        <td>

<%include file="comment.html" args="text=body,author=cs_comment_user,status=status_change"/>\

        </td>

    </tr>

    <tr>

        <td height="30px" style="height:30px"></td>

    </tr>

    <tr>

        <td>

            <div>

                ${_('Changeset on')}

                <a style="${link_style}"

                   href="${cs_target_repo}">${cs_target_repo}</a>

                ${_('branch')}

            </div>

            <div>

                "<a style="${link_style}"

                   href="${cs_url}">${h.shorter(message, 60, firstline=True)}</a>"

                ${_('by')}

            </div>

        </td>

    </tr>

    <tr>

        <td>

<%include file="button.html" args="url=cs_comment_url,title=_('View Comment'),padding_bottom=False"/>\

        </td>

    </tr>

</table>

<%inherit file="main.html"/>\

\

<%block name="header">\

<% title = _('Mention on Pull Request %s "%s" by %s') % (pr_nice_id, pr_title, pr_user_created) if is_mention else _('Added as Reviewer of Pull Request %s "%s" by %s') % (pr_nice_id, pr_title, pr_user_created) %>\

<%include file="header.html" args="title=title,link=pr_url"/>\

</%block>\

\

<table cellpadding="0" cellspacing="0" border="0" width="100%">

    <tr>

        <td>

            <div>

                ${_('Pull request from')}

                <a style="${link_style}"

                   href="${pr_source_repo}">${pr_source_repo}</a>

                ${_('at')}

                ${_('to')}

                <a style="${link_style}"

                   href="${pr_target_repo}">${pr_target_repo}</a>

                ${_('at')}

            </div>

            <div>

                <a style="${link_style}"

                   href="${pr_url}">${pr_nice_id}</a>

                "<span style="color:${color_link}">${pr_title}</span>"

                ${_('by')}

            </div>

        </td>

    </tr>

    <tr><td height="10px" style="height:10px"></td></tr>

    <tr>

        <td>

            <div>

                ${_('Description')}:

            </div>

        </td>

    </tr>

    <tr><td height="10px" style="height:10px"></td></tr>

    <tr>

        <td>

            <table cellpadding="0" cellspacing="0" width="100%" border="0" bgcolor="${color_background_grey}" style="border:1px solid ${color_border};border-radius:4px">

                <tr>

                    <td height="10px" style="height:10px" colspan="3"></td>

                </tr>

                <tr>

                    <td width="20px" style="width:20px"></td>

                    <td>

                        <div style="${comment_style}">${body}</div>

                    </td>

                    <td width="20px" style="width:20px"></td>

                </tr>

                <tr>

                    <td height="10px" style="height:10px" colspan="3"></td>

                </tr>

            </table>

        </td>

    </tr>

    <tr><td height="15px" style="height:15px"></td></tr>

    <tr>

        <td>

            <div>${_('Changesets')}:</div>

        </td>

    </tr>

    <tr><td height="10px" style="height:10px"></td></tr>

    <tr>

        <td style="${sans_style}">

            <ul style="color:${color_link};padding-left:15px;margin:0">

                %for revision, desc in pr_revisions:

                    <li style="mso-special-format:bullet">

                        <a style="${link_style}"

                           href="${h.canonical_url('changeset_home', repo_name=org_repo_name, revision=revision)}">

                            ${h.shorter(desc, 80, firstline=True)}

                        </a>

                    </li>

                %endfor

            </ul>

        </td>

    </tr>

    <tr>

        <td>

<%include file="button.html" args="url=pr_url,title=_('View Pull Request'),padding_bottom=False"/>\

        </td>

    </tr>

</table>

<%inherit file="main.html"/>\

\

<%block name="header">\

<% title = _('Mention in Comment on Pull Request %s "%s"') % (pr_nice_id, pr_title) if is_mention else _('Pull Request %s "%s" Closed') % (pr_nice_id, pr_title) if closing_pr else _('Comment on Pull Request %s "%s"') % (pr_nice_id, pr_title) %>\

<%include file="header.html" args="title=title,link=pr_comment_url"/>\

</%block>\

\

<table cellpadding="0" cellspacing="0" border="0" width="100%">

    <tr>

        <td>

<%include file="comment.html" args="text=body,author=pr_comment_user,status=status_change,close=closing_pr"/>\

        </td>

    </tr>

    <tr>

        <td height="30px" style="height:30px"></td>

    </tr>

    <tr>

        <td>

            <div>

                ${_('Pull request from')}

                <a style="${link_style}"

                   href="${pr_source_repo}">${pr_source_repo}</a>

                ${_('branch')}

                ${_('to')}

                <a style="${link_style}"

                   href="${pr_target_repo}">${pr_target_repo}</a>

                ${_('branch')}

            </div>

            <div>

                <a style="${link_style}"

                   href="${pr_url}">${pr_nice_id}</a>

                "<span style="color:${color_link}">${pr_title}</span>"

                ${_('by')}

            </div>

        </td>

    </tr>

    <tr>

        <td>

<%include file="button.html" args="url=pr_comment_url,title=_('View Comment'),padding_bottom=False"/>\

        </td>

    </tr>

</table>

## -*- coding: utf-8 -*-

<%inherit file="main.html"/>\

\

<%block name="header">\

<%include file="header.html" args="title=_('New User Registration'),link=registered_user_url"/>\

</%block>\

\

<table cellpadding="0" cellspacing="0" border="0" width="100%">

    <tr>

        <td>

            ${_('Username')}:

        </td>

            ${new_username}

        </td>

    </tr>

    <tr>

        <td height="10px" style="height:10px" colspan="2"></td>

    </tr>

    <tr>

        <td>

            ${_('Full Name')}:

        </td>

            ${new_full_name}

        </td>

    </tr>

    <tr>

        <td height="10px" style="height:10px" colspan="2"></td>

    </tr>

    <tr>

        <td>

            ${_('Email')}:

        </td>

            ${new_email}

        </td>

    </tr>

    <tr>

        <td colspan="2">

<%include file="button.html" args="url=registered_user_url,title=_('View User Profile'),padding_bottom=False"/>\

        </td>

    </tr>

</table>

<!doctype html>

<html lang="en">

<head><title>Notifications</title><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head>

<body>

<hr/>

<h1>cs_comment, is_mention=False, status_change=None</h1>

<pre>

From: u1

To: u2@example.com

Subject: [Comment] repo/name changeset cafe1234 "This changeset did something cl..." on brunch

</pre>

<hr/>

<pre>http://comment.org

Comment on Changeset "This changeset did something clever which is hard to explain"

Opinionated User (jsmith):

This is the new 'comment'.

 - and here it ends indented.

Changeset on http://example.com/repo_target branch brunch:

"This changeset did something clever which is hard to explain" by u2 u3 (u2).

View Comment: http://comment.org

</pre>

<hr/>

<!--!doctype html-->

<!--html lang="en"-->

<!--head-->

    <!--title--><!--/title-->

    <!--meta name="viewport" content="width=device-width"-->

    <!--meta http-equiv="Content-Type" content="text/html; charset=UTF-8"-->

<!--/head-->

<!--body-->

<table align="center" cellpadding="0" cellspacing="0" border="0" style="min-width:348px;max-width:800px;font-family:Helvetica,Arial,sans-serif;font-weight:200;font-size:14px;line-height:17px;color:#202020">

    <tr>

        <td width="30px" style="width:30px"></td>

        <td>

            <table width="100%" cellpadding="0" cellspacing="0" border="0"

                   style="table-layout:fixed;font-family:Helvetica,Arial,sans-serif;border:1px solid #ddd">

                <tr><td width="30px" style="width:30px"></td><td></td><td width="30px" style="width:30px"></td></tr>

                <tr>

                    <td colspan="3">

<table bgcolor="#f9f9f9" width="100%" cellpadding="0" cellspacing="0"

       style="border-bottom:1px solid #ddd">

    <tr>

        <td height="20px" style="height:20px" colspan="3"></td>

    </tr>

    <tr>

        <td width="30px" style="width:30px"></td>

        <td style="font-family:Helvetica,Arial,sans-serif;font-size:19px;line-height:24px">

            <a style="text-decoration:none;font-weight:600;color:#395fa0" href="http://comment.org"

               target="_blank">Comment on Changeset &#34;This changeset did something clever which is hard to explain&#34;</a>

        </td>

        <td width="30px" style="width:30px"></td>

    </tr>

    <tr>

        <td height="20px" style="height:20px" colspan="3"></td>

    </tr>

</table>

                    </td>

                </tr>

                <tr>

                    <td height="30px" style="height:30px" colspan="3"></td>

                </tr>

                <tr>

                    <td></td>

                    <td>

<table cellpadding="0" cellspacing="0" border="0" width="100%">

    <tr>

        <td>

<table cellpadding="0" cellspacing="0" width="100%" border="0" bgcolor="#f9f9f9" style="border:1px solid #ddd;border-radius:4px">

    <tr>

        <td height="10px" style="height:10px" colspan="3"></td>

    </tr>

    <tr>

        <td width="20px" style="width:20px"></td>

        <td>

            <div style="font-weight:600;color:#395fa0">Opinionated User (jsmith)</div>

        </td>

        <td width="20px" style="width:20px"></td>

    </tr>

    <tr>

        <td height="10px" style="height:10px" colspan="3" style="border-bottom:1px solid #ddd"></td>

    </tr>

    <tr>

        <td height="10px" style="height:10px" colspan="3"></td>

    </tr>

    <tr>

        <td width="20px" style="width:20px"></td>

        <td>

            <div style="font-family:Lucida Console,Consolas,Monaco,Inconsolata,Liberation Mono,monospace;white-space:pre-wrap"><div class="formatted-fixed">This is the new &#39;comment&#39;.<br/><br/> - and here it ends indented.</div></div>

        </td>

        <td width="20px" style="width:20px"></td>

    </tr>

    <tr>

        <td height="10px" style="height:10px" colspan="3"></td>

    </tr>

</table>

        </td>

    </tr>

    <tr>

        <td height="30px" style="height:30px"></td>

    </tr>

    <tr>

        <td>

            <div>

                Changeset on

                <a style="color:#395fa0;text-decoration:none"

                   href="http://example.com/repo_target">http://example.com/repo_target</a>

                branch

            </div>

            <div>

                "<a style="color:#395fa0;text-decoration:none"

                   href="http://changeset.com">This changeset did something clever which is hard to explain</a>"

                by

            </div>

        </td>

    </tr>

    <tr>

        <td>

<center>

    <table cellspacing="0" cellpadding="0" style="margin-left:auto;margin-right:auto">

        <tr>

            <td height="25px" style="height:25px"></td>

        </tr>

        <tr>

            <td style="border-collapse:collapse;border-radius:2px;text-align:center;display:block;border:solid 1px #395fa0;padding:11px 20px 11px 20px">

                <a href="http://comment.org" style="text-decoration:none;display:block" target="_blank">

                    <center>

                        <font size="3">

                            <span style="font-family:Helvetica,Arial,sans-serif;font-weight:700;font-size:15px;line-height:14px;color:#395fa0;white-space:nowrap;vertical-align:middle">View Comment</span>

                        </font>

                    </center>

                </a>

            </td>

        </tr>

    </table>

</center>

        </td>

    </tr>

</table>

                    </td>

                    <td></td>

                </tr>

                <tr>

                    <td height="30px" style="height:30px" colspan="3"></td>

                </tr>

            </table>

        </td>

        <td width="30px" style="width:30px"></td>

    </tr>

</table>

<!--/body-->

<!--/html-->

<hr/>

<hr/>

<h1>cs_comment, is_mention=True, status_change=None</h1>

<pre>

From: u1

To: u2@example.com

Subject: [Comment] repo/name changeset cafe1234 "This changeset did something cl..." on brunch

</pre>

<hr/>

<pre>http://comment.org

Mention in Comment on Changeset "This changeset did something clever which is hard to explain"

Opinionated User (jsmith):

This is the new 'comment'.

 - and here it ends indented.

Changeset on http://example.com/repo_target branch brunch:

"This changeset did something clever which is hard to explain" by u2 u3 (u2).

View Comment: http://comment.org

</pre>

<hr/>

<!--!doctype html-->

<!--html lang="en"-->

<!--head-->

    <!--title--><!--/title-->

    <!--meta name="viewport" content="width=device-width"-->

    <!--meta http-equiv="Content-Type" content="text/html; charset=UTF-8"-->

<!--/head-->

<!--body-->

<table align="center" cellpadding="0" cellspacing="0" border="0" style="min-width:348px;max-width:800px;font-family:Helvetica,Arial,sans-serif;font-weight:200;font-size:14px;line-height:17px;color:#202020">

    <tr>

        <td width="30px" style="width:30px"></td>

        <td>

            <table width="100%" cellpadding="0" cellspacing="0" border="0"

                   style="table-layout:fixed;font-family:Helvetica,Arial,sans-serif;border:1px solid #ddd">

                <tr><td width="30px" style="width:30px"></td><td></td><td width="30px" style="width:30px"></td></tr>

                <tr>

                    <td colspan="3">

<table bgcolor="#f9f9f9" width="100%" cellpadding="0" cellspacing="0"

       style="border-bottom:1px solid #ddd">

    <tr>

        <td height="20px" style="height:20px" colspan="3"></td>

    </tr>

    <tr>

        <td width="30px" style="width:30px"></td>

        <td style="font-family:Helvetica,Arial,sans-serif;font-size:19px;line-height:24px">

            <a style="text-decoration:none;font-weight:600;color:#395fa0" href="http://comment.org"

               target="_blank">Mention in Comment on Changeset &#34;This changeset did something clever which is hard to explain&#34;</a>

        </td>

        <td width="30px" style="width:30px"></td>

    </tr>

    <tr>

        <td height="20px" style="height:20px" colspan="3"></td>

    </tr>

</table>

                    </td>

                </tr>

                <tr>

                    <td height="30px" style="height:30px" colspan="3"></td>

                </tr>

                <tr>

                    <td></td>

                    <td>

<table cellpadding="0" cellspacing="0" border="0" width="100%">

    <tr>

        <td>

<table cellpadding="0" cellspacing="0" width="100%" border="0" bgcolor="#f9f9f9" style="border:1px solid #ddd;border-radius:4px">

    <tr>

        <td height="10px" style="height:10px" colspan="3"></td>

    </tr>

    <tr>

        <td width="20px" style="width:20px"></td>

        <td>

            <div style="font-weight:600;color:#395fa0">Opinionated User (jsmith)</div>

        </td>

        <td width="20px" style="width:20px"></td>

    </tr>

    <tr>

        <td height="10px" style="height:10px" colspan="3" style="border-bottom:1px solid #ddd"></td>

    </tr>

    <tr>

        <td height="10px" style="height:10px" colspan="3"></td>

    </tr>

    <tr>

        <td width="20px" style="width:20px"></td>

        <td>

            <div style="font-family:Lucida Console,Consolas,Monaco,Inconsolata,Liberation Mono,monospace;white-space:pre-wrap"><div class="formatted-fixed">This is the new &#39;comment&#39;.<br/><br/> - and here it ends indented.</div></div>

        </td>

        <td width="20px" style="width:20px"></td>

    </tr>

    <tr>

        <td height="10px" style="height:10px" colspan="3"></td>

    </tr>

</table>

        </td>

    </tr>

    <tr>

        <td height="30px" style="height:30px"></td>

    </tr>

    <tr>

        <td>

            <div>

                Changeset on

                <a style="color:#395fa0;text-decoration:none"

                   href="http://example.com/repo_target">http://example.com/repo_target</a>

                branch

            </div>

            <div>

                "<a style="color:#395fa0;text-decoration:none"

                   href="http://changeset.com">This changeset did something clever which is hard to explain</a>"

                by

            </div>

        </td>

    </tr>

    <tr>

        <td>

<center>

    <table cellspacing="0" cellpadding="0" style="margin-left:auto;margin-right:auto">

        <tr>

            <td height="25px" style="height:25px"></td>

        </tr>

        <tr>

            <td style="border-collapse:collapse;border-radius:2px;text-align:center;display:block;border:solid 1px #395fa0;padding:11px 20px 11px 20px">

                <a href="http://comment.org" style="text-decoration:none;display:block" target="_blank">

                    <center>

                        <font size="3">

                            <span style="font-family:Helvetica,Arial,sans-serif;font-weight:700;font-size:15px;line-height:14px;color:#395fa0;white-space:nowrap;vertical-align:middle">View Comment</span>

                        </font>

                    </center>

                </a>

            </td>

        </tr>

    </table>

</center>

        </td>

    </tr>

</table>

                    </td>

                    <td></td>

                </tr>

                <tr>

                    <td height="30px" style="height:30px" colspan="3"></td>

                </tr>

            </table>

        </td>

        <td width="30px" style="width:30px"></td>

    </tr>

</table>

<!--/body-->

<!--/html-->

<hr/>

<hr/>

<h1>cs_comment, is_mention=False, status_change='Approved'</h1>

<pre>

From: u1

To: u2@example.com

Subject: [Approved: Comment] repo/name changeset cafe1234 "This changeset did something cl..." on brunch

</pre>

<hr/>

<pre>http://comment.org

Comment on Changeset "This changeset did something clever which is hard to explain"

Opinionated User (jsmith):

Status change: Approved

This is the new 'comment'.

 - and here it ends indented.

Changeset on http://example.com/repo_target branch brunch:

"This changeset did something clever which is hard to explain" by u2 u3 (u2).

View Comment: http://comment.org

</pre>

<hr/>

<!--!doctype html-->

<!--html lang="en"-->

<!--head-->

    <!--title--><!--/title-->

    <!--meta name="viewport" content="width=device-width"-->

    <!--meta http-equiv="Content-Type" content="text/html; charset=UTF-8"-->

<!--/head-->

<!--body-->

<table align="center" cellpadding="0" cellspacing="0" border="0" style="min-width:348px;max-width:800px;font-family:Helvetica,Arial,sans-serif;font-weight:200;font-size:14px;line-height:17px;color:#202020">

    <tr>

        <td width="30px" style="width:30px"></td>

        <td>

            <table width="100%" cellpadding="0" cellspacing="0" border="0"

                   style="table-layout:fixed;font-family:Helvetica,Arial,sans-serif;border:1px solid #ddd">

                <tr><td width="30px" style="width:30px"></td><td></td><td width="30px" style="width:30px"></td></tr>

                <tr>

                    <td colspan="3">

<table bgcolor="#f9f9f9" width="100%" cellpadding="0" cellspacing="0"

       style="border-bottom:1px solid #ddd">

    <tr>

        <td height="20px" style="height:20px" colspan="3"></td>

    </tr>

    <tr>

        <td width="30px" style="width:30px"></td>

        <td style="font-family:Helvetica,Arial,sans-serif;font-size:19px;line-height:24px">

            <a style="text-decoration:none;font-weight:600;color:#395fa0" href="http://comment.org"

               target="_blank">Comment on Changeset &#34;This changeset did something clever which is hard to explain&#34;</a>

        </td>

        <td width="30px" style="width:30px"></td>

    </tr>

    <tr>

        <td height="20px" style="height:20px" colspan="3"></td>

    </tr>

</table>

                    </td>

                </tr>

                <tr>

                    <td height="30px" style="height:30px" colspan="3"></td>

                </tr>

                <tr>

                    <td></td>

                    <td>

<table cellpadding="0" cellspacing="0" border="0" width="100%">

    <tr>

        <td>

<table cellpadding="0" cellspacing="0" width="100%" border="0" bgcolor="#f9f9f9" style="border:1px solid #ddd;border-radius:4px">

    <tr>

        <td height="10px" style="height:10px" colspan="3"></td>

    </tr>

    <tr>

        <td width="20px" style="width:20px"></td>

        <td>

            <div style="font-weight:600;color:#395fa0">Opinionated User (jsmith)</div>

        </td>

        <td width="20px" style="width:20px"></td>

    </tr>

    <tr>

        <td height="10px" style="height:10px" colspan="3" style="border-bottom:1px solid #ddd"></td>

    </tr>

        <tr>

            <td height="10px" style="height:10px" colspan="3"></td>

        </tr>

        <tr>

            <td width="20px" style="width:20px"></td>

            <td>

                    <div style="font-weight:600">

                        Status change:

                        Approved

                    </div>

            </td>

            <td width="20px" style="width:20px"></td>