implement request #3: show recent pastes in "New paste" screen sidebar

3 files changed, 103 insertions, 0 deletions

diff --git a/src/phorkie/Database/Adapter/Elasticsearch/Search.php b/src/phorkie/Database/Adapter/Elasticsearch/Search.php
index d077747..e960e04 100644
--- a/src/phorkie/Database/Adapter/Elasticsearch/Search.php
+++ b/src/phorkie/Database/Adapter/Elasticsearch/Search.php
@@ -3,12 +3,75 @@ namespace phorkie;
 
 class Database_Adapter_Elasticsearch_Search implements Database_ISearch
 {
+    protected static $sortMap = array(
+        'id' => array('id', 'asc'),
+        'crdate' => array('crdate', 'desc'),
+        'tstamp' => array('tstamp', 'desc'),
+    );
+
     public function __construct()
     {
         $this->searchInstance = $GLOBALS['phorkie']['cfg']['elasticsearch'];
     }
 
     /**
+     * List all repositories
+     *
+     * @param integer $page    Page of search results, starting with 0
+     * @param integer $perPage Number of results per page
+     * @param string  $sort    Sort order. Allowed values:
+     *                         - id     - repository id
+     *                         - crdate - creation date
+     *                         - tstamp - modification date
+     *
+     * @return Search_Result Search result object
+     */
+    public function listAll($page = 0, $perPage = 10, $sort = 'id', $sortOrder = null)
+    {
+        list($sortField, $orderField) = $this->getSortField($sort, $sortOrder);
+        $r = new Database_Adapter_Elasticsearch_HTTPRequest(
+            $this->searchInstance . 'repo/_search',
+            \HTTP_Request2::METHOD_GET
+        );
+        $r->setBody(
+            json_encode(
+                (object)array(
+                    'from'  => $page * $perPage,
+                    'size'  => $perPage,
+                    'sort'  => array(
+                        $sortField => $orderField
+                    ),
+                    'query' => (object)array(
+                        'match_all' => (object)array()
+                    ),
+                )
+            )
+        );
+        $httpRes = $r->send();
+        $jRes = json_decode($httpRes->getBody());
+        if (isset($jRes->error)) {
+            throw new Exception(
+                'Search exception: ' . $jRes->error, $jRes->status
+            );
+        }
+
+        $sres = new Search_Result();
+        $sres->results = $jRes->hits->total;
+        $sres->page    = $page;
+        $sres->perPage = $perPage;
+
+        foreach ($jRes->hits->hits as $hit) {
+            $r = new Repository();
+            $r->loadById($hit->_source->id);
+            $r->crdate = strtotime($hit->_source->crdate);
+            $sres->repos[] = $r;
+        }
+
+        return $sres;
+    }
+
+
+    /**
      * Search for a given term and return repositories that contain it
      * in their description, file names or file content
      *
@@ -77,6 +140,22 @@ class Database_Adapter_Elasticsearch_Search implements Database_ISearch
 
         return $sres;
     }
+
+    protected function getSortField($sort, $sortOrder)
+    {
+        if (!isset(self::$sortMap[$sort])) {
+            throw new Exception('Invalid sort parameter: ' . $sort);
+        }
+        if ($sortOrder !== 'asc' && $sortOrder !== 'desc') {
+            throw new Exception('Invalid sortOrder parameter: ' . $sortOrder);
+        }
+
+        $data = self::$sortMap[$sort];
+        if ($sortOrder !== null) {
+            $data[1] = $sortOrder;
+        }
+        return $data;
+    }
 }
 
 ?>
diff --git a/src/phorkie/Database/Adapter/Null/Search.php b/src/phorkie/Database/Adapter/Null/Search.php
index 0731932..579c13a 100644
--- a/src/phorkie/Database/Adapter/Null/Search.php
+++ b/src/phorkie/Database/Adapter/Null/Search.php
@@ -11,6 +11,15 @@ class Database_Adapter_Null_Search implements Database_ISearch
         $sres->perPage = $perPage;
         return $sres;
     }
+
+    public function listAll($page = 0, $perPage = 10, $sort = 'id', $sortOrder = null)
+    {
+        $sres = new Search_Result();
+        $sres->results = 0;
+        $sres->page    = $page;
+        $sres->perPage = $perPage;
+        return $sres;
+    }
 }
 
 ?>
diff --git a/src/phorkie/Database/ISearch.php b/src/phorkie/Database/ISearch.php
index b18d43a..c33867b 100644
--- a/src/phorkie/Database/ISearch.php
+++ b/src/phorkie/Database/ISearch.php
@@ -4,6 +4,21 @@ namespace phorkie;
 interface Database_ISearch
 {
     public function search($term, $page = 0, $perPage = 10);
+
+    /**
+     * List all repositories
+     *
+     * @param integer $page    Page of search results, starting with 0
+     * @param integer $perPage Number of results per page
+     * @param string  $sort    Sort order. Allowed values:
+     *                         - id     - repository id
+     *                         - crdate - creation date
+     *                         - tstamp - modification date
+     *
+     * @return Search_Result Search result object
+     */
+    public function listAll($page = 0, $perPage = 10, $sort = 'id', $sortOrder = null);
+
 }
 
 ?>