log.error(traceback.format_exc())

            h.flash(str(e), category='warning')

            return redirect(url('home'))

        c.changes = OrderedDict()

        c.sum_added = 0

        c.sum_removed = 0

        c.lines_added = 0

        c.lines_deleted = 0

        c.cut_off = False  # defines if cut off limit is reached

        c.comments = []

        # Iterate over ranges (default changeset view is always one changeset)

        for changeset in c.cs_ranges:

            c.changes[changeset.raw_id] = []

            try:

                changeset_parent = changeset.parents[0]

            except IndexError:

                changeset_parent = None

            #==================================================================

            # ADDED FILES

            #==================================================================

            for node in changeset.added:

                filenode_old = FileNode(node.path, '', EmptyChangeset())

        c.diffs = ''

        for x in c.changes:

            c.diffs += x[2]

        return render('changeset/raw_changeset.html')

    def comment(self, repo_name, revision):

        ccmodel = ChangesetCommentsModel()

        ccmodel.create(text=request.POST.get('text'),

                       repo_id=c.rhodecode_db_repo.repo_id, 

                       user_id=c.rhodecode_user.user_id, 

                       line_no = request.POST.get('line'))

        return redirect(h.url('changeset_home', repo_name=repo_name,

                              revision=revision))

    @jsonify

    def delete_comment(self, comment_id):

        co = ChangesetComment.get(comment_id)

        if (h.HasPermissionAny('hg.admin', 'repository.admin')() or

            co.author.user_id == c.rhodecode_user.user_id):

            ccmodel = ChangesetCommentsModel()

            ccmodel.delete(comment_id=comment_id)

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

# GNU General Public License for more details.

#

# You should have received a copy of the GNU General Public License

# along with this program.  If not, see <http://www.gnu.org/licenses/>.

import logging

import traceback

from rhodecode.model import BaseModel

from rhodecode.model.db import ChangesetComment

log = logging.getLogger(__name__)

class ChangesetCommentsModel(BaseModel):

               line_no=None):

        """

        Creates new comment for changeset

        :param text:

        :param repo_id:

        :param user_id:

        :param f_path:

        :param line_no:

        """

        comment = ChangesetComment()

        comment.repo_id = repo_id

        comment.user_id = user_id

        comment.text = text

        comment.f_path = f_path

        comment.line_no = line_no

        self.sa.add(comment)

        self.sa.commit()

        return comment

    def delete(self, comment_id):

        """

        Deletes given comment

        :param comment_id:

        """

        comment = ChangesetComment.get(comment_id)

        self.sa.delete(comment)

        self.sa.commit()

        return comment

        inv_obj = Session().query(CacheInvalidation)\

            .filter(CacheInvalidation.cache_key == key).scalar()

        inv_obj.cache_active = True

        Session.add(inv_obj)

        Session.commit()

class ChangesetComment(Base, BaseModel):

    __tablename__ = 'changeset_comments'

    __table_args__ = ({'extend_existing':True},)

    comment_id = Column('comment_id', Integer(), nullable=False, primary_key=True)

    repo_id = Column('repo_id', Integer(), ForeignKey('repositories.repo_id'), nullable=False)

    line_no = Column('line_no', Integer(), nullable=True)

    f_path = Column('f_path', String(1000), nullable=True)

    user_id = Column('user_id', Integer(), ForeignKey('users.user_id'), nullable=False)

    text = Column('text', String(25000), nullable=False)

    modified_at = Column('modified_at', DateTime(timezone=False), nullable=False, default=datetime.datetime.now)

    author = relationship('User')

    repo = relationship('Repository')

class DbMigrateVersion(Base, BaseModel):

    __tablename__ = 'db_migrate_version'

##usage:

## <%namespace name="comment" file="/changeset/changeset_file_comment.html"/>

## ${comment.comment_block(co)}

##

<%def name="comment_block(co)">

  <div class="comment" id="comment-${co.comment_id}">

  	<div class="meta">

  		<span class="user">

  			<img src="${h.gravatar_url(co.author.email, 20)}" />

  			${co.author.username}

  		</span>

  		<a href="${h.url.current(anchor='comment-%s' % co.comment_id)}"> ${_('commented on')} </a>

  		%if co.f_path:

  			${_(' in file ')}

  			${co.f_path}:L${co.line_no}

  		%endif

  		<span class="date">

  			${h.age(co.modified_at)}

  		</span>

  	</div>

  	<div class="text">

  		%if h.HasPermissionAny('hg.admin', 'repository.admin')() or co.author.user_id == c.rhodecode_user.user_id:

  			<div class="buttons">

  				<span onClick="deleteComment(${co.comment_id})" class="delete-comment ui-button-small">${_('Delete')}</span>