diff options
author | Bernhard Posselt <nukeawhale@gmail.com> | 2013-03-20 19:21:47 +0100 |
---|---|---|
committer | Bernhard Posselt <nukeawhale@gmail.com> | 2013-03-20 19:21:47 +0100 |
commit | 9c78fd8295f8e27cdb8fe8c4e10ffae650bc14d0 (patch) | |
tree | 5a9bf0d8e6c7044b85c93b95c044b6a1449197ce /db | |
parent | 8f215ec03ba57e51dbbfef004069fb1e63c8fca1 (diff) |
added feedmaper
Diffstat (limited to 'db')
-rw-r--r-- | db/feedmapper.php | 35 |
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 |