summaryrefslogtreecommitdiffstats
path: root/lib/feedmapper.php
diff options
context:
space:
mode:
Diffstat (limited to 'lib/feedmapper.php')
-rw-r--r--lib/feedmapper.php46
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()) {
generated by cgit v1.2.3 (git 2.25.1) at 2024-07-27 11:34:42 +0000