summaryrefslogtreecommitdiffstats
path: root/db/feedmapper.php
diff options
context:
space:
mode:
Diffstat (limited to 'db/feedmapper.php')
-rw-r--r--db/feedmapper.php35
1 files changed, 34 insertions, 1 deletions
diff --git a/db/feedmapper.php b/db/feedmapper.php
index 9eb85c3fe..2a84574df 100644
--- a/db/feedmapper.php
+++ b/db/feedmapper.php
@@ -25,6 +25,8 @@
namespace OCA\News\Db;
+use \OCA\AppFramework\Core\API;
+
class FeedMapper extends NewsMapper {
@@ -39,10 +41,41 @@ class FeedMapper extends NewsMapper {
'WHERE `id` = ? ' .
'AND `user_id` = ?';
- return $this->findRow($sql, $id, $userId);
+ $row = $this->findRow($sql, $id, $userId);
+ $feed = new Feed();
+ $feed->fromRow($row);
+
+ return $feed;
}
+ private function findAllRows($sql, $params=array()){
+ $result = $this->execute($sql, $params);
+
+ $feeds = array();
+ while($row = $result->fetchRow()){
+ $feed = new Feed();
+ $feed->fromRow($row);
+ array_push($feeds, $feed);
+ }
+
+ return $feeds;
+ }
+ public function findAllFromUser($userId){
+ $sql = 'SELECT * FROM `*dbprefix*news_feeds` ' .
+ 'AND `user_id` = ?';
+ $params = array($userId);
+
+ return $this->findAllRows($sql, $params);
+ }
+
+
+ public function findAll(){
+ $sql = 'SELECT * FROM `*dbprefix*news_feeds`';
+
+ return $this->findAllRows($sql);
+ }
+
} \ No newline at end of file