created_on=repo.created_on,

            description=repo.description,

            landing_rev=repo.landing_rev,

            owner=repo.user.username,

            fork_of=repo.fork.repo_name if repo.fork else None,

            enable_statistics=repo.enable_statistics,

            enable_locking=repo.enable_locking,

            enable_downloads=repo.enable_downloads,

            last_changeset=repo.changeset_cache,

            locked_by=User.get(self.locked[0]).get_api_data() \

                if self.locked[0] else None,

            locked_date=time_to_datetime(self.locked[1]) \

                if self.locked[1] else None

        )

        rc_config = Setting.get_app_settings()

        repository_fields = str2bool(rc_config.get('repository_fields'))

        if repository_fields:

            for f in self.extra_fields:

                data[f.field_key_prefixed] = f.field_value

        return data

    @classmethod

    def lock(cls, repo, user_id, lock_time=None):

        if lock_time is not None:

            lock_time = time.time()

        repo.locked = [user_id, lock_time]

        Session().add(repo)

        Session().commit()

    @classmethod

    def unlock(cls, repo):

        repo.locked = None

        Session().add(repo)

        Session().commit()

    @classmethod

    def getlock(cls, repo):

        return repo.locked

    @property

    def last_db_change(self):

        return self.updated_on

    @property

    def clone_uri_hidden(self):

        clone_uri = self.clone_uri

        if clone_uri:

            import urlobject

            url_obj = urlobject.URLObject(self.clone_uri)

            if url_obj.password:

                clone_uri = url_obj.with_password('*****')

        return clone_uri

    def clone_url(self, **override):

        import kallithea.lib.helpers as h

        qualified_home_url = h.canonical_url('home')

        uri_tmpl = None

        if 'with_id' in override:

            uri_tmpl = self.DEFAULT_CLONE_URI_ID

            del override['with_id']

        if 'uri_tmpl' in override:

            uri_tmpl = override['uri_tmpl']

            del override['uri_tmpl']

        # we didn't override our tmpl from **overrides

        if not uri_tmpl:

            uri_tmpl = self.DEFAULT_CLONE_URI

            try:

                from pylons import tmpl_context as c

                uri_tmpl = c.clone_uri_tmpl

            except AttributeError:

                # in any case if we call this outside of request context,

                # ie, not having tmpl_context set up

                pass

        return get_clone_url(uri_tmpl=uri_tmpl,

                             qualified_home_url=qualified_home_url,

                             repo_name=self.repo_name,

                             repo_id=self.repo_id, **override)

    def set_state(self, state):

        self.repo_state = state

        Session().add(self)

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

    # SCM PROPERTIES

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

    def get_changeset(self, rev=None):

        return get_changeset_safe(self.scm_instance, rev)

    def get_landing_changeset(self):

        """

        Returns landing changeset, or if that doesn't exist returns the tip

        """

        _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"""

        from webhelpers.html import literal

        if repo_group is None:

            return (-1, u'-- %s --' % _('top level'))

        return repo_group.group_id, literal(cls.SEP.join(repo_group.full_path_splitted))

    @classmethod

    def groups_choices(cls, groups):

        """Return tuples with group_id and name as html literal."""

        return sorted((cls._generate_choice(g) for g in groups),

                      key=lambda c: c[1].split(cls.SEP))

    @classmethod

    def url_sep(cls):

        return URL_SEP

    @classmethod

    def get_by_group_name(cls, group_name, cache=False, case_insensitive=False):

        if case_insensitive:

            gr = cls.query() \

                .filter(func.lower(cls.group_name) == func.lower(group_name))

        else:

            gr = cls.query() \

                .filter(cls.group_name == group_name)

        if cache:

            gr = gr.options(FromCache(

                            "sql_cache_short",

                            "get_group_%s" % _hash_key(group_name)

                            )

            )

        return gr.scalar()

    @property

    def parents(self):

        parents_recursion_limit = 10

        groups = []

        if self.parent_group is None:

            return groups

        cur_gr = self.parent_group

        groups.insert(0, cur_gr)

        cnt = 0

        while 1:

            cnt += 1

            gr = getattr(cur_gr, 'parent_group', None)

            cur_gr = cur_gr.parent_group

            if gr is None:

                break

            if cnt == parents_recursion_limit:

                # this will prevent accidental infinite loops

                log.error(('more than %s parents found for group %s, stopping '

                           'recursive parent fetching' % (parents_recursion_limit, self)))

                break

            groups.insert(0, gr)

        return groups

    @property

    def children(self):

        return RepoGroup.query().filter(RepoGroup.parent_group == self)

    @property

    def name(self):

        return self.group_name.split(RepoGroup.url_sep())[-1]

    @property

    def full_path(self):

        return self.group_name

    @property

    def full_path_splitted(self):

        return self.group_name.split(RepoGroup.url_sep())

    @property

    def repositories(self):

        return Repository.query() \

                .filter(Repository.group == self) \

                .order_by(Repository.repo_name)

    @property

    def repositories_recursive_count(self):

        cnt = self.repositories.count()

        def children_count(group):

            cnt = 0

            for child in group.children:

                cnt += child.repositories.count()

                cnt += children_count(child)

            return cnt

        return cnt + children_count(self)

    def _recursive_objects(self, include_repos=True):

        all_ = []

        def _get_members(root_gr):

            if include_repos:

                for r in root_gr.repositories:

## -*- 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));

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

                            $('#open_new_pr').prop('href', pyroutes.url('pullrequest_home',

                                                                        {'repo_name': '${c.repo_name}',

                                                                         'rev_start': rev_start,

                                                                         'rev_end': rev_end}));

                            $('#open_new_pr').html(_TM['Open New Pull Request for {0} → {1}'].format(rev_start, rev_end));

                        } else {

                            $('#open_new_pr').prop('href', pyroutes.url('pullrequest_home',

                                                                        {'repo_name': '${c.repo_name}',

                                                                         'rev_end': rev_end}));

                            $('#open_new_pr').html(_TM['Open New Pull Request from {0}'].format(rev_end));

                        }

                        $('#rev_range_clear').show();

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

                        var disabled = true;

                        $checkboxes.each(function(){

                            var $this = $(this);

                            if (disabled) {

                                if ($this.prop('checked')) {

                                    $this.closest('tr').removeClass('out-of-range');

                                    disabled = singlerange;

                                } else {

                                    $this.closest('tr').addClass('out-of-range');

                                }

                            } else {

                                $this.closest('tr').removeClass('out-of-range');

                                disabled = $this.prop('checked');

                            }

                        });

                        if ($checked_checkboxes.length + (singlerange ? 1 : 0) >= 2) {

                            $checkboxes.hide();

                            $checked_checkboxes.show();

                            if (!singlerange)

                                $singlerange.hide();

                        }

                    } else {

                        $('#singlerange').hide().prop('checked', false);

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

                        %if c.revision:

                            $('#open_new_pr').prop('href', pyroutes.url('pullrequest_home',

                                                                        {'repo_name': '${c.repo_name}',

                                                                         'rev_end':'${c.first_revision.raw_id}'}));

                            $('#open_new_pr').html(_TM['Open New Pull Request from {0}'].format('${c.revision}'));

                        %else:

                            $('#open_new_pr').prop('href', pyroutes.url('pullrequest_home',

                                                                        {'repo_name': '${c.repo_name}',

                                                                        'branch':'${c.first_revision.branch}'}));

                            $('#open_new_pr').html(_TM['Open New Pull Request from {0}'].format('${c.first_revision.branch}'));

                        %endif

                        $('#compare_fork').show();

                        $checkboxes.closest('tr').removeClass('out-of-range');

                    }

                };

                checkbox_checker();

                $checkboxes.click(function() {

                    checkbox_checker();

                    r.render(jsdata,100);

                });

                $('#singlerange').click(checkbox_checker);

                $('#rev_range_clear').click(function(e){

                    $checkboxes.prop('checked', false);

                    checkbox_checker();

                    r.render(jsdata,100);

                });

                var $msgs = $('.message');

                // get first element height

                var el = $('#graph_content .container')[0];

                var row_h = el.clientHeight;

                $msgs.each(function() {

                    var m = this;

                    var h = m.clientHeight;

                    if(h > row_h){

                        var offset = row_h - (h+12);

                        $(m.nextElementSibling).css('display', 'block');

                        $(m.nextElementSibling).css('margin-top', offset+'px');

                    }

                });

                $('.expand_commit').on('click',function(e){

                    var cid = $(this).attr('commit_id');

                    $('#C-'+cid).toggleClass('expanded');

                    //redraw the graph, r and jsdata are bound outside function

                    r.render(jsdata,100);

                });

                // change branch filter

                $("#branch_filter").select2({

                    dropdownAutoWidth: true,

                    minimumInputLength: 1,

## -*- 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