diff options
author | Alessandro Cosentino <cosenal@gmail.com> | 2012-08-11 11:39:03 -0400 |
---|---|---|
committer | Alessandro Cosentino <cosenal@gmail.com> | 2012-08-11 11:39:03 -0400 |
commit | 48513e8e42c72409109f21804964b7c54527f6c0 (patch) | |
tree | 3da33a98ff14cc34b9f78b08e824d6200a23b1fa /lib/feedmapper.php | |
parent | c37d6ea2225e6b7ee93d2a294c33d81681fa843e (diff) |
changes namespace to OCA\News
Diffstat (limited to 'lib/feedmapper.php')
-rw-r--r-- | lib/feedmapper.php | 46 |
1 files changed, 24 insertions, 22 deletions
diff --git a/lib/feedmapper.php b/lib/feedmapper.php index a8292cd39..3d11ff0e6 100644 --- a/lib/feedmapper.php +++ b/lib/feedmapper.php @@ -10,10 +10,12 @@ * */ +namespace OCA\News; + /** * This class maps a feed to an entry in the feeds table of the database. */ -class OC_News_FeedMapper { +class FeedMapper { const tableName = '*PREFIX*news_feeds'; private $userid; @@ -22,7 +24,7 @@ class OC_News_FeedMapper { if ($userid !== null) { $this->userid = $userid; } - $this->userid = OCP\USER::getUser(); + $this->userid = \OCP\USER::getUser(); } /** @@ -46,7 +48,7 @@ class OC_News_FeedMapper { $params[] = $this->userid; } - $stmt = OCP\DB::prepare( $query ); + $stmt = \OCP\DB::prepare( $query ); $result = $stmt->execute( $params ); $feeds = array(); while ($row = $result->fetchRow()) { @@ -66,14 +68,14 @@ class OC_News_FeedMapper { * @returns */ public function findById($id){ - $stmt = OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' WHERE id = ?'); + $stmt = \OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' WHERE id = ?'); $result = $stmt->execute(array($id)); if(!$row = $result->fetchRow()) return null; $url = $row['url']; $title = htmlspecialchars_decode($row['title']); - $feed = new OC_News_Feed($url, $title, null, $id); + $feed = new Feed($url, $title, null, $id); return $feed; } @@ -83,14 +85,14 @@ class OC_News_FeedMapper { * @returns an instance of OC_News_Feed */ public function findByFolderId($folderid){ - $stmt = OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' WHERE folder_id = ?'); + $stmt = \OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' WHERE folder_id = ?'); $result = $stmt->execute(array($folderid)); $feeds = array(); while ($row = $result->fetchRow()) { $url = $row['url']; $title = htmlspecialchars_decode($row['title']); $id = $row['id']; - $feed = new OC_News_Feed($url, $title, null, $id); + $feed = new Feed($url, $title, null, $id); $favicon = $row['favicon_link']; $feed->setFavicon($favicon); $feeds[] = $feed; @@ -105,15 +107,15 @@ class OC_News_FeedMapper { * @returns an instance of OC_News_Feed */ public function findWithItems($id){ - $stmt = OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' WHERE id = ?'); + $stmt = \OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' WHERE id = ?'); $result = $stmt->execute(array($id)); $row = $result->fetchRow(); $url = $row['url']; $title = htmlspecialchars_decode($row['title']); - $feed = new OC_News_Feed($url, $title, null,$id); + $feed = new Feed($url, $title, null,$id); $favicon = $row['favicon_link']; $feed->setFavicon($favicon); - $itemMapper = new OC_News_ItemMapper(); + $itemMapper = new ItemMapper(); $items = $itemMapper->findAll($id); $feed->setItems($items); @@ -127,7 +129,7 @@ class OC_News_FeedMapper { * null - if there is no such feed */ public function findIdFromUrl($url){ - $stmt = OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' WHERE url = ?'); + $stmt = \OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' WHERE url = ?'); $result = $stmt->execute(array($url)); $row = $result->fetchRow(); $id = null; @@ -139,7 +141,7 @@ class OC_News_FeedMapper { public function mostRecent(){ //FIXME: does something like SELECT TOP 1 * exists in pear/mdb2 ?? - $stmt = OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' ORDER BY lastmodified'); + $stmt = \OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' ORDER BY lastmodified'); $result = $stmt->execute(); $row = $result->fetchRow(); $id = null; @@ -155,8 +157,8 @@ class OC_News_FeedMapper { * @returns The id of the feed in the database table. */ //TODO: handle error case - public function save(OC_News_Feed $feed, $folderid){ - $CONFIG_DBTYPE = OCP\Config::getSystemValue( "dbtype", "sqlite" ); + public function save(Feed $feed, $folderid){ + $CONFIG_DBTYPE = \OCP\Config::getSystemValue( "dbtype", "sqlite" ); if( $CONFIG_DBTYPE == 'sqlite' or $CONFIG_DBTYPE == 'sqlite3' ){ $_ut = "strftime('%s','now')"; } elseif($CONFIG_DBTYPE == 'pgsql') { @@ -169,14 +171,14 @@ class OC_News_FeedMapper { $url = htmlspecialchars_decode($feed->getUrl()); if(empty($title)) { - $l = OC_L10N::get('news'); + $l = \OC_L10N::get('news'); $title = $l->t('no title'); } //FIXME: Detect when feed contains already a database id $feedid = $this->findIdFromUrl($url); if ($feedid == null){ - $query = OCP\DB::prepare(" + $query = \OCP\DB::prepare(" INSERT INTO " . self::tableName . "(url, title, favicon_link, folder_id, user_id, added, lastmodified) VALUES (?, ?, ?, ?, ?, $_ut, $_ut) @@ -191,11 +193,11 @@ class OC_News_FeedMapper { ); $query->execute($params); - $feedid = OCP\DB::insertid(self::tableName); + $feedid = \OCP\DB::insertid(self::tableName); } $feed->setId($feedid); - $itemMapper = new OC_News_ItemMapper(); + $itemMapper = new ItemMapper(); $items = $feed->getItems(); foreach($items as $item){ @@ -209,17 +211,17 @@ class OC_News_FeedMapper { if ($id == null) { return false; } - $stmt = OCP\DB::prepare('DELETE FROM ' . self::tableName .' WHERE id = ?'); + $stmt = \OCP\DB::prepare('DELETE FROM ' . self::tableName .' WHERE id = ?'); $result = $stmt->execute(array($id)); - $itemMapper = new OC_News_ItemMapper(); + $itemMapper = new ItemMapper(); //TODO: handle the value that the execute returns $itemMapper->deleteAll($id); return true; } - public function delete(OC_News_Feed $feed){ + public function delete(Feed $feed){ $id = $feed->getId(); return deleteById($id); } @@ -229,7 +231,7 @@ class OC_News_FeedMapper { return false; } - $stmt = OCP\DB::prepare('SELECT id FROM ' . self::tableName . ' WHERE folder_id = ?'); + $stmt = \OCP\DB::prepare('SELECT id FROM ' . self::tableName . ' WHERE folder_id = ?'); $result = $stmt->execute(array($folderid)); while ($row = $result->fetchRow()) { |