"""

        _rev_type, _rev = self.landing_rev

        cs = self.get_changeset(_rev)

        if isinstance(cs, EmptyChangeset):

            return self.get_changeset()

        return cs

    def update_changeset_cache(self, cs_cache=None):

        """

        Update cache of last changeset for repository, keys should be::

            short_id

            raw_id

            revision

            message

            date

            author

        :param cs_cache:

        """

        from kallithea.lib.vcs.backends.base import BaseChangeset

        if cs_cache is None:

            cs_cache = EmptyChangeset()

            # use no-cache version here

            scm_repo = self.scm_instance_no_cache()

            if scm_repo:

                cs_cache = scm_repo.get_changeset()

        if isinstance(cs_cache, BaseChangeset):

            cs_cache = cs_cache.__json__()

        if (not self.changeset_cache or cs_cache['raw_id'] != self.changeset_cache['raw_id']):

            _default = datetime.datetime.fromtimestamp(0)

            last_change = cs_cache.get('date') or _default

            log.debug('updated repo %s with new cs cache %s',

                      self.repo_name, cs_cache)

            self.updated_on = last_change

            self.changeset_cache = cs_cache

            Session().add(self)

            Session().commit()

        else:

            log.debug('changeset_cache for %s already up to date with %s',

                      self.repo_name, cs_cache['raw_id'])

    @property

    def tip(self):

        return self.get_changeset('tip')

    @property

    def author(self):

        return self.tip.author

    @property

    def last_change(self):

        return self.scm_instance.last_change

    def get_comments(self, revisions=None):

        """

        Returns comments for this repository grouped by revisions

        :param revisions: filter query by revisions only

        """

        cmts = ChangesetComment.query() \

            .filter(ChangesetComment.repo == self)

        if revisions is not None:

            if not revisions:

                return [] # don't use sql 'in' on empty set

            cmts = cmts.filter(ChangesetComment.revision.in_(revisions))

        grouped = collections.defaultdict(list)

        for cmt in cmts.all():

            grouped[cmt.revision].append(cmt)

        return grouped

    def statuses(self, revisions):

        """

        Returns statuses for this repository.

        PRs without any votes do _not_ show up as unreviewed.

        :param revisions: list of revisions to get statuses for

        """

        if not revisions:

            return {}

        statuses = ChangesetStatus.query() \

            .filter(ChangesetStatus.repo == self) \

            .filter(ChangesetStatus.version == 0) \

            .filter(ChangesetStatus.revision.in_(revisions))

        grouped = {}

        for stat in statuses.all():

            pr_id = pr_nice_id = pr_repo = None

            if stat.pull_request:

                pr_id = stat.pull_request.pull_request_id

                pr_nice_id = PullRequest.make_nice_id(pr_id)

                pr_repo = stat.pull_request.other_repo.repo_name

            grouped[stat.revision] = [str(stat.status), stat.status_lbl,

        return grouped

    def _repo_size(self):

        from kallithea.lib import helpers as h

        log.debug('calculating repository size...')

        return h.format_byte_size(self.scm_instance.size)

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

    # SCM CACHE INSTANCE

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

    def set_invalidate(self):

        """

        Mark caches of this repo as invalid.

        """

        CacheInvalidation.set_invalidate(self.repo_name)

    def scm_instance_no_cache(self):

        return self.__get_instance()

    @property

    def scm_instance(self):

        import kallithea

        full_cache = str2bool(kallithea.CONFIG.get('vcs_full_cache'))

        if full_cache:

            return self.scm_instance_cached()

        return self.__get_instance()

    def scm_instance_cached(self, valid_cache_keys=None):

        @cache_region('long_term')

        def _c(repo_name):

            return self.__get_instance()

        rn = self.repo_name

        valid = CacheInvalidation.test_and_set_valid(rn, None, valid_cache_keys=valid_cache_keys)

        if not valid:

            log.debug('Cache for %s invalidated, getting new object', rn)

            region_invalidate(_c, None, rn)

        else:

            log.debug('Getting scm_instance of %s from cache', rn)

        return _c(rn)

    def __get_instance(self):

        repo_full_path = self.repo_full_path

        alias = get_scm(safe_str(repo_full_path))[0]

        log.debug('Creating instance of %s repository from %s',

                  alias, repo_full_path)

        backend = get_backend(alias)

        if alias == 'hg':

            repo = backend(safe_str(repo_full_path), create=False,

                           baseui=self._ui)

        else:

            repo = backend(repo_full_path, create=False)

        return repo

    def __json__(self):

        return dict(landing_rev = self.landing_rev)

class RepoGroup(Base, BaseModel):

    __tablename__ = 'groups'

    __table_args__ = (

        UniqueConstraint('group_name', 'group_parent_id'),

        CheckConstraint('group_id != group_parent_id'),

        _table_args_default_dict,

    )

    __mapper_args__ = {'order_by': 'group_name'}

    SEP = ' » '

    group_id = Column(Integer(), unique=True, primary_key=True)

    group_name = Column(Unicode(255), nullable=False, unique=True)

    group_parent_id = Column(Integer(), ForeignKey('groups.group_id'), nullable=True)

    group_description = Column(Unicode(10000), nullable=False)

    enable_locking = Column(Boolean(), nullable=False, default=False)

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

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

    repo_group_to_perm = relationship('UserRepoGroupToPerm', cascade='all', order_by='UserRepoGroupToPerm.group_to_perm_id')

    users_group_to_perm = relationship('UserGroupRepoGroupToPerm', cascade='all')

    parent_group = relationship('RepoGroup', remote_side=group_id)

    user = relationship('User')

    def __init__(self, group_name='', parent_group=None):

        self.group_name = group_name

        self.parent_group = parent_group

    def __unicode__(self):

        return u"<%s('id:%s:%s')>" % (self.__class__.__name__, self.group_id,

                                      self.group_name)

    @classmethod

    def _generate_choice(cls, repo_group):

        """Return tuple with group_id and name as html literal"""

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

<%inherit file="/base/base.html"/>

<%block name="title">

    ${_('%s Changelog') % c.repo_name}

    %if c.changelog_for_path:

      /${c.changelog_for_path}

    %endif

</%block>

<%def name="breadcrumbs_links()">

    <% size = c.size if c.size <= c.total_cs else c.total_cs %>

    ${_('Changelog')}

    %if c.changelog_for_path:

     - /${c.changelog_for_path}

    %endif

    %if c.revision:

    @ ${h.short_id(c.first_revision.raw_id)}

    %endif

    - ${ungettext('showing %d out of %d revision', 'showing %d out of %d revisions', size) % (size, c.total_cs)}

</%def>

<%block name="header_menu">

    ${self.menu('repositories')}

</%block>

<%def name="main()">

${self.repo_context_bar('changelog', c.first_revision.raw_id if c.first_revision else None)}

<div class="box">

    <!-- box / title -->

    <div class="title">

        ${self.breadcrumbs()}

    </div>

    <div class="table">

        % if c.pagination:

            <div>

                <div style="overflow:auto; ${'display:none' if c.changelog_for_path else ''}">

                    <div class="container_header">

                        <div style="float:left; margin-left:20px;">

                          ${h.form(h.url.current(),method='get',style="display:inline")}

                            ${h.submit('set',_('Show'),class_="btn btn-small")}

                            ${h.text('size',size=3,value=c.size)}

                            ${_('revisions')}

                            %if c.branch_name:

                            ${h.hidden('branch', c.branch_name)}

                            %endif

                          ${h.end_form()}

                          <a href="#" class="btn btn-small" id="rev_range_clear" style="display:none">${_('Clear selection')}</a>

                        </div>

                        <div style="float: right; margin: 0px 0px 0px 4px">

                            <a href="#" class="btn btn-small" id="rev_range_container" style="display:none"></a>

                            %if c.revision:

                                <a class="btn btn-small" href="${h.url('changelog_home', repo_name=c.repo_name)}">

                                    ${_('Go to tip of repository')}

                                </a>

                            %endif

                            %if c.db_repo.fork:

                                <a id="compare_fork"

                                   title="${_('Compare fork with %s' % c.db_repo.fork.repo_name)}"

                                   href="${h.url('compare_url',repo_name=c.db_repo.fork.repo_name,org_ref_type=c.db_repo.landing_rev[0],org_ref_name=c.db_repo.landing_rev[1],other_repo=c.repo_name,other_ref_type='branch' if request.GET.get('branch') else c.db_repo.landing_rev[0],other_ref_name=request.GET.get('branch') or c.db_repo.landing_rev[1], merge=1)}"

                                   class="btn btn-small"><i class="icon-git-compare"></i> ${_('Compare fork with parent repository (%s)' % c.db_repo.fork.repo_name)}</a>

                            %endif

                            ## text and href of open_new_pr is controlled from javascript

                            <a id="open_new_pr" class="btn btn-small"></a>

                            ${_("Branch filter:")} ${h.select('branch_filter',c.branch_name,c.branch_filters)}

                        </div>

                    </div>

                </div>

                <div id="changelog" style="clear:both">

                <div id="graph_nodes">

                    <canvas id="graph_canvas" style="width:0"></canvas>

                </div>

                <div id="graph_content" style="${'margin: 0px' if c.changelog_for_path else ''}">

                <table id="changesets">

                <tbody>

                %for cnt,cs in enumerate(c.pagination):

                    <tr id="chg_${cnt+1}" class="container ${'mergerow' if len(cs.parents) > 1 else ''}">

                        <td class="checkbox">

                            %if c.changelog_for_path:

                                ${h.checkbox(cs.raw_id,class_="changeset_range", disabled="disabled")}

                            %else:

                                ${h.checkbox(cs.raw_id,class_="changeset_range")}

                            %endif

                        <td class="status">

                          %if c.statuses.get(cs.raw_id):

                            <div class="changeset-status-ico">

                            %if c.statuses.get(cs.raw_id)[2]:

                                <i class="icon-circle changeset-status-${c.statuses.get(cs.raw_id)[0]}"></i>

                              </a>

                            %else:

                                  <i class="icon-circle changeset-status-${c.statuses.get(cs.raw_id)[0]}"></i>

                              </a>

                            %endif

                            </div>

                          %endif

                        </td>

                        <td class="author">

                            ${h.gravatar(h.email_or_none(cs.author), size=16)}

                            <span title="${cs.author}" class="user">${h.shorter(h.person(cs.author),22)}</span>

                        </td>

                        <td class="hash" style="width:${len(h.show_id(cs))*6.5}px">

                            <a href="${h.url('changeset_home',repo_name=c.repo_name,revision=cs.raw_id)}">

                                <span class="changeset_hash">${h.show_id(cs)}</span>

                            </a>

                        </td>

                        <td class="date">

                            <div class="date tooltip" title="${h.fmt_date(cs.date)}">${h.age(cs.date,True)}</div>

                        </td>

                        <td class="expand_commit" commit_id="${cs.raw_id}" title="${_('Expand commit message')}">

                            <i class="icon-align-left" style="color:#999"></i>

                        </td>

                        <td class="mid">

                            <div class="log-container">

                                <div class="message" id="C-${cs.raw_id}">${h.urlify_commit(cs.message, c.repo_name,h.url('changeset_home',repo_name=c.repo_name,revision=cs.raw_id))}</div>

                                <div class="extra-container">

                                    %if c.comments.get(cs.raw_id):

                                        <div class="comments-container">

                                            <div class="comments-cnt" title="${_('Changeset has comments')}">

                                                <a href="${c.comments[cs.raw_id][0].url()}">

                                                    ${len(c.comments[cs.raw_id])}

                                                    <i class="icon-comment-discussion"></i>

                                                </a>

                                            </div>

                                        </div>

                                    %endif

                                    %if h.is_hg(c.db_repo_scm_instance):

                                        %for book in cs.bookmarks:

                                            <div class="booktag" title="${_('Bookmark %s') % book}">

                                                ${h.link_to(book,h.url('changeset_home',repo_name=c.repo_name,revision=cs.raw_id))}

                                            </div>

                                        %endfor

                                    %endif

                                    %for tag in cs.tags:

                                        <div class="tagtag" title="${_('Tag %s') % tag}">

                                            ${h.link_to(tag,h.url('changeset_home',repo_name=c.repo_name,revision=cs.raw_id))}

                                        </div>

                                    %endfor

                                    %if (not c.branch_name) and cs.branch:

                                        <div class="branchtag" title="${_('Branch %s' % cs.branch)}">

                                            ${h.link_to(cs.branch,h.url('changelog_home',repo_name=c.repo_name,branch=cs.branch))}

                                        </div>

                                    %endif

                                </div>

                            </div>

                        </td>

                    </tr>

                %endfor

                </tbody>

                </table>

                <input type="checkbox" id="singlerange" style="display:none"/>

                </div>

                <div class="pagination-wh pagination-left">

                    ${c.pagination.pager('$link_previous ~2~ $link_next')}

                </div>

            </div>

        </div>

        <script type="text/javascript" src="${h.url('/js/graph.js', ver=c.kallithea_version)}"></script>

        <script type="text/javascript">

            $(document).ready(function(){

                var $checkboxes = $('.changeset_range');

                pyroutes.register('changeset_home', "${h.url('changeset_home', repo_name='%(repo_name)s', revision='%(revision)s')}", ['repo_name', 'revision']);

                var checkbox_checker = function(e) {

                    var $checked_checkboxes = $checkboxes.filter(':checked');

                    var $singlerange = $('#singlerange');

                    $('#rev_range_container').hide();

                    $checkboxes.show();

                    $singlerange.show();

                    if ($checked_checkboxes.length > 0) {

                        $checked_checkboxes.first().parent('td').append($singlerange);

                        var singlerange = $singlerange.prop('checked');

                        var rev_end = $checked_checkboxes.first().prop('name').substr(0, 12);

                        if ($checked_checkboxes.length > 1 || singlerange) {

                            var rev_start = $checked_checkboxes.last().prop('name').substr(0, 12);

                            $('#rev_range_container').prop('href',

                                pyroutes.url('changeset_home', {'repo_name': '${c.repo_name}',

                                                                'revision': rev_start + '...' + rev_end}));

                            $('#rev_range_container').html(

                                 _TM['Show Selected Changesets {0} → {1}'].format(rev_start, rev_end));

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

%if c.repo_changesets:

<table>

    <tr>

        <th class="left"></th>

        <th class="left"></th>

        <th class="left">${_('Revision')}</th>

        <th class="left">${_('Commit Message')}</th>

        <th class="left">${_('Age')}</th>

        <th class="left">${_('Author')}</th>

        <th class="left">${_('Refs')}</th>

    </tr>

%for cnt,cs in enumerate(c.repo_changesets):

    <tr class="parity${cnt%2}">

        <td class="compact">

            <div class="changeset-status-container">

              %if c.statuses.get(cs.raw_id):

                <span class="changeset-status-ico shortlog">

                %if c.statuses.get(cs.raw_id)[2]:

                    <i class="icon-circle changeset-status-${c.statuses.get(cs.raw_id)[0]}"></i>

                  </a>

                %else:

                    <i class="icon-circle changeset-status-${c.statuses.get(cs.raw_id)[0]}"></i>

                  </a>

                %endif

                </span>

              %endif

            </div>

        </td>

        <td class="compact">

              %if c.comments.get(cs.raw_id,[]):

               <div class="comments-container">

                   <div title="${('comments')}">

                       <a href="${c.comments[cs.raw_id][0].url()}">

                          <i class="icon-comment"></i>${len(c.comments[cs.raw_id])}

                       </a>

                   </div>

               </div>

              %endif

        </td>

        <td>

            <a href="${h.url('changeset_home',repo_name=c.repo_name,revision=cs.raw_id)}" class="revision-link">${h.show_id(cs)}</a>

        </td>

        <td>

            ${h.urlify_commit(h.chop_at(cs.message,'\n'),c.repo_name, h.url('changeset_home',repo_name=c.repo_name,revision=cs.raw_id))}

        </td>

        <td><span class="tooltip" title="${h.fmt_date(cs.date)}">

                      ${h.age(cs.date)}</span>

        </td>

        <td title="${cs.author}">${h.person(cs.author)}</td>

        <td>

            %if h.is_hg(c.db_repo_scm_instance):

                %for book in cs.bookmarks:

                    <div class="booktag" title="${_('Bookmark %s') % book}">

                        ${h.link_to(book,h.url('changeset_home',repo_name=c.repo_name,revision=cs.raw_id))}

                    </div>

                %endfor

            %endif

            %for tag in cs.tags:

             <div class="tagtag" title="${_('Tag %s') % tag}">

                 ${h.link_to(tag,h.url('changeset_home',repo_name=c.repo_name,revision=cs.raw_id))}

             </div>

            %endfor

            %if cs.branch:

             <div class="branchtag" title="${_('Branch %s' % cs.branch)}">

                 ${h.link_to(cs.branch,h.url('changelog_home',repo_name=c.repo_name,branch=cs.branch))}

             </div>

            %endif

        </td>

    </tr>

%endfor

</table>

<div class="pagination-wh pagination-left">

${c.repo_changesets.pager('$link_previous ~2~ $link_next')}

</div>

%else:

%if h.HasRepoPermissionAny('repository.write','repository.admin')(c.repo_name):

<h4>${_('Add or upload files directly via Kallithea')}</h4>

<div style="margin: 20px 30px;">

  <div id="add_node_id" class="add_node">

      <a class="btn btn-mini" href="${h.url('files_add_home',repo_name=c.repo_name,revision=0,f_path='', anchor='edit')}">${_('Add New File')}</a>

  </div>

</div>

%endif

<h4>${_('Push new repository')}</h4>

<pre>

    ${c.db_repo_scm_instance.alias} clone ${c.clone_repo_url}

    ${c.db_repo_scm_instance.alias} add README # add first file

    ${c.db_repo_scm_instance.alias} commit -m "Initial" # commit with message

    ${c.db_repo_scm_instance.alias} push ${'origin master' if h.is_git(c.db_repo_scm_instance) else ''} # push changes back

</pre>

<h4>${_('Existing repository?')}</h4>

<pre>

%if h.is_git(c.db_repo_scm_instance):

    git remote add origin ${c.clone_repo_url}

    git push -u origin master

%else:

    hg push ${c.clone_repo_url}

%endif

</pre>

%endif