api: pull-requests get_all now sortes the results and have a flag to show/hide merge result state

rhodecode/api/views/pull_request_api.py

@@ -141,7 +141,8 b' def get_pull_request(request, apiuser, p'
 
 
 @jsonrpc_method()
-def get_pull_requests(request, apiuser, repoid, status=Optional('new')):
+def get_pull_requests(request, apiuser, repoid, status=Optional('new'),
+                      merge_state=Optional(True)):
     """
     Get all pull requests from the repository specified in `repoid`.
 
@@ -155,6 +156,9 b' def get_pull_requests(request, apiuser, '
         * ``open``
         * ``closed``
     :type status: str
+    :param merge_state: Optional calculate merge state for each repository.
+        This could result in longer time to fetch the data
+    :type merge_state: bool
 
     Example output:
 
@@ -232,8 +236,10 b' def get_pull_requests(request, apiuser, '
         validate_repo_permissions(apiuser, repoid, repo, _perms)
 
     status = Optional.extract(status)
-    pull_requests = PullRequestModel().get_all(repo, statuses=[status])
-    data = [pr.get_api_data() for pr in pull_requests]
+    merge_state = Optional.extract(merge_state, binary=True)
+    pull_requests = PullRequestModel().get_all(repo, statuses=[status],
+                                               order_by='id', order_dir='desc')
+    data = [pr.get_api_data(with_merge_state=merge_state) for pr in pull_requests]
     return data
 
 

rhodecode/model/pull_request.py

@@ -167,6 +167,7 b' class PullRequestModel(BaseModel):'
         if order_by:
             order_map = {
                 'name_raw': PullRequest.pull_request_id,
+                'id': PullRequest.pull_request_id,
                 'title': PullRequest.title,
                 'updated_on_raw': PullRequest.updated_on,
                 'target_repo': PullRequest.target_repo_id