if not title:

            title = '%s#%s to %s' % (org_repo, org_ref.split(':', 2)[1], other_repo)

        description = _form['pullrequest_desc']

        try:

            pull_request = PullRequestModel().create(

                self.authuser.user_id, org_repo, org_ref, other_repo,

                other_ref, revisions, reviewers, title, description

            )

            Session().commit()

            h.flash(_('Successfully opened new pull request'),

                    category='success')

        except Exception:

                    category='error')

            log.error(traceback.format_exc())

            return redirect(url('pullrequest_home', repo_name=repo_name))

        return redirect(url('pullrequest_show', repo_name=other_repo,

                            pull_request_id=pull_request.pull_request_id))

    @LoginRequired()

    @NotAnonymous()

    @HasRepoPermissionAnyDecorator('repository.read', 'repository.write',

                                   'repository.admin')

    @jsonify

    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:

        return _c(rn)

    def __get_instance(self):

        repo_full_path = self.repo_full_path

        try:

            alias = get_scm(repo_full_path)[0]

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

                      % (alias, repo_full_path))

            backend = get_backend(alias)

        except VCSError:

            log.error(traceback.format_exc())

            log.error('Perhaps this repository is in db and not in '

        return ChangesetStatus.get_status_lbl(self.status)

class PullRequest(Base, BaseModel):

    __tablename__ = 'pull_requests'

    __table_args__ = (

        {'extend_existing': True, 'mysql_engine': 'InnoDB',

         'mysql_charset': 'utf8', 'sqlite_autoincrement': True},

    )

    # values for .status

    STATUS_NEW = u'new'

    STATUS_CLOSED = u'closed'

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

    title = Column('title', Unicode(256), nullable=True)

    description = Column('description', UnicodeText(10240), nullable=True)

    status = Column('status', Unicode(256), nullable=False, default=STATUS_NEW) # only for closedness, not approve/reject/etc

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

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

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

    _revisions = Column('revisions', UnicodeText(20500))  # 500 revisions max

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

    org_ref = Column('org_ref', Unicode(256), nullable=False)

                        .filter(UserNotification.user == user)\

                        .filter(UserNotification.notification

                                == notification)\

                        .one()

                Session().delete(obj)

                return True

        except Exception:

            log.error(traceback.format_exc())

            raise

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

        """

        :param user:

        :param filter:

        """

        user = self._get_user(user)

        q = UserNotification.query()\

            .filter(UserNotification.user == user)\

            .join((Notification, UserNotification.notification_id ==

                                 Notification.notification_id))

        if filter_:

    var next_id = $('.new_members').length;

    $last_node.before($('<tr class="new_members">').append(_html.format(next_id)));

    _MembersAutoComplete("perm_new_member_name_"+next_id,

            "perm_container_"+next_id, users_list, groups_list);

}

function ajaxActionRevokePermission(url, obj_id, obj_type, field_id, extra_data) {

    var callback = {

        success: function (o) {

            $('#' + field_id).remove();

        },

        failure: function (o) {

        },

    };

    query_params = {

        '_method': 'delete'

    }

    // put extra data into POST

    if (extra_data !== undefined && (typeof extra_data === 'object')){

        for(k in extra_data){

            query_params[k] = extra_data[k];

        }

    }

            var TRANSLATION_MAP = {

                'Add another comment':'${_("Add another comment")}',

                'Stop following this repository':"${_('Stop following this repository')}",

                'Start following this repository':"${_('Start following this repository')}",

                'Group':"${_('Group')}",

                'members':"${_('members')}",

                'Loading ...':"${_('Loading ...')}",

                'loading ...':"${_('loading ...')}",

                'Search truncated': "${_('Search truncated')}",

                'No matching files': "${_('No matching files')}",

                'Open new pull request': "${_('Open new pull request')}",

                'Open new pull request for selected changesets':  "${_('Open new pull request for selected changesets')}",

                'Show selected changeset __S': "${_('Show selected changeset __S')}",

                'Selection link': "${_('Selection link')}",

                'Collapse diff': "${_('Collapse diff')}",

                'Expand diff': "${_('Expand diff')}",

                'Failed to revoke permission': "${_('Failed to revoke permission')}",

                'Confirm to revoke permission for {0}: {1} ?': "${_('confirm to revoke permission for {0}: {1} ?')}",

                'enabled': "${_('enabled')}",

                'disabled': "${_('disabled')}",

                'Select changeset': "${_('Select changeset')}",

                'MSG_SORTASC': "${_('Click to sort ascending')}",

                'MSG_SORTDESC': "${_('Click to sort descending')}",

                'MSG_EMPTY': "${_('No records found.')}",

                'MSG_ERROR': "${_('Data error.')}",

                'MSG_LOADING': "${_('Loading...')}",

            };

            var _TM = TRANSLATION_MAP;

            var TOGGLE_FOLLOW_URL  = "${h.url('toggle_following')}";

            <div id="graph">

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

                    <div class="container_header">

                       <div style="float:right; margin: 0px 0px 0px 4px">${h.select('branch_filter',c.branch_name,c.branch_filters)}</div>

                       <div class="info_box" style="text-align: right; float: right">

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

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

                            %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=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=request.GET.get('branch') or c.db_repo.landing_rev[1], merge=1)}"

                            %endif

                            <a id="open_new_pr" href="${h.url('pullrequest_home',repo_name=c.repo_name)}" class="btn btn-mini">${_('Open new pull request')}</a>

                       </div>

                       ${h.form(h.url.current(),method='get')}

                       <div style="float:left">

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

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

                           ${_('revisions')}

                       </div>

                       ${h.end_form()}

                    </div>

                            }

                        }

                    }

                    if(checked_checkboxes.length>0){

                        var rev_end = checked_checkboxes[0].name;

                        var rev_start = checked_checkboxes[checked_checkboxes.length-1].name;

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

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

                        var link = (rev_start == rev_end)

                            ? _TM['Show selected changeset __S']

                        link = link.replace('__S',rev_start.substr(0,6));

                        link = link.replace('__E',rev_end.substr(0,6));

                        YUD.get('rev_range_container').href = url;

                        YUD.get('rev_range_container').innerHTML = link;

                        YUD.setStyle('rev_range_container','display','');

                        YUD.setStyle('rev_range_clear','display','');

                        YUD.get('open_new_pr').href = pyroutes.url('pullrequest_home',

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

                                                                    'rev_start': rev_start,

                                                                    'rev_end': rev_end})

</%def>

<%def name="comment_inline_form()">

<div id='comment-inline-form-template' style="display:none">

  <div class="comment-inline-form ac">

  %if c.authuser.username != 'default':

      ${h.form('#', class_='inline-form')}

      <div id="edit-container_{1}" class="clearfix">

          <div class="comment-help">${_('Commenting on line {1}.')}

          ${(_('Comments parsed using %s syntax with %s support.') % (

                 ('<a href="%s">RST</a>' % h.url('rst_help')),

               )

            )|n

           }

          <div id="preview-btn_{1}" class="preview-btn btn btn-mini">${_('Preview')}</div>

          </div>

            <div class="mentions-container" id="mentions_container_{1}"></div>

            <textarea id="text_{1}" name="text" class="comment-block-ta yui-ac-input"></textarea>

      </div>

      <div id="preview-container_{1}" class="clearfix" style="display:none">

         <div class="comment-help">

              ${_('Comment preview')}

            <div id="edit-btn_{1}" class="edit-btn btn btn-mini">${_('Edit')}</div>

            //filter results

            $.each(cached.results, function(){

                var section = this.text;

                var children = [];

                $.each(this.children, function(){

                    if(query.term.length == 0 || this.text.toUpperCase().indexOf(query.term.toUpperCase()) >= 0 ){

                        children.push({'id': this.id, 'text': this.text})

                    }

                })

                data.results.push({'text': section, 'children': children})

            });

            //push the typed in changeset

                               'children': [{'id': query.term, 'text': query.term, 'type': 'rev'}]})

            query.callback(data);

          }else{

              $.ajax({

                url: pyroutes.url('repo_refs_data', {'repo_name': '${c.org_repo.repo_name}'}),

                data: {},

                dataType: 'json',

                type: 'GET',

                success: function(data) {

                  cache[key] = data;

                }

              })

          }

        },

    });

    $("#compare_other").select2({

        placeholder: "${'%s@%s' % (c.other_repo.repo_name, c.other_ref)}",

        dropdownAutoWidth: true,

        formatSelection: function(obj){

            return '{0}@{1}'.format("${c.other_repo.repo_name}", obj.text)

        },

        query: function(query){

            //filter results

            $.each(cached.results, function(){

                var section = this.text;

                var children = [];

                $.each(this.children, function(){

                    if(query.term.length == 0 || this.text.toUpperCase().indexOf(query.term.toUpperCase()) >= 0 ){

                        children.push({'id': this.id, 'text': this.text})

                    }

                })

                data.results.push({'text': section, 'children': children})

            });

            //push the typed in changeset

                               'children': [{'id': query.term, 'text': query.term, 'type': 'rev'}]})

            query.callback(data);

          }else{

              $.ajax({

                url: pyroutes.url('repo_refs_data', {'repo_name': '${c.other_repo.repo_name}'}),

                data: {},

                dataType: 'json',

                type: 'GET',

                success: function(data) {

                  cache[key] = data;

                  query.callback({results: data.results});

                }

                            </div>

                            <span style="font-size: 20px">

                            ${h.select('other_repo',c.default_other_repo,c.other_repos,class_='refs')}:${c.default_other_repo_info['revs']}

                            </span>

                        </div>

                    </div>

                    <div style="clear:both"></div>

                </div>

            </div>

            <div class="field">

                <div class="buttons">

                    ${h.reset('reset',_('Reset'),class_="btn")}

               </div>

            </div>

        </div>

        ## Reviewers

        <div style="float:left; border-left:1px dashed #eee">

            <div class="pr-details-title">${_('Pull request reviewers')}</div>

            <div id="reviewers" style="padding:0px 0px 0px 15px">

              ## members goes here !

              <div>

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

import os

import sys

import platform

if sys.version_info < (2, 5):

    raise Exception('Kallithea requires python 2.5 or later')

here = os.path.abspath(os.path.dirname(__file__))