Exemplo n.º 1
0
 private static function updateFeed($feedmapper, $feed)
 {
     $newfeed = null;
     $newfeed = Utils::fetch($feed['url']);
     if ($newfeed !== null) {
         $feedmapper = new FeedMapper();
         $newfeedid = $feedmapper->save($newfeed, $feed['folderid']);
     }
 }
Exemplo n.º 2
0
 /**
  * @brief Retrieve all the item corresponding to a feed from the database
  * @param feedid The id of the feed in the database table.
  */
 public function findByFeedId($feedid)
 {
     $stmt = \OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' WHERE feed_id = ? ORDER BY pub_date DESC');
     $result = $stmt->execute(array($feedid));
     $feedmapper = new FeedMapper($this->userid);
     $feed = $feedmapper->findById($feedid);
     $items = array();
     while ($row = $result->fetchRow()) {
         $item = $this->fromRow($row);
         $item->setFeedTitle($feed->getTitle());
         $items[] = $item;
     }
     return $items;
 }
Exemplo n.º 3
0
 static function instance()
 {
     if (!isset(self::$instance)) {
         self::$instance = new self();
     }
     return self::$instance;
 }
Exemplo n.º 4
0
 /**
  * @brief Delete the folder and all its feeds from the database
  * @param folder the folder to be deleted (an instance of OCA\News\Folder)
  * @returns true if the folder has been deleted, false if an error occurred
  */
 public function deleteById($folderid)
 {
     if ($folderid == null) {
         return false;
     }
     // delete child folders
     $stmt = \OCP\DB::prepare('SELECT id FROM ' . self::tableName . ' WHERE parent_id = ? AND user_id = ?');
     $result = $stmt->execute(array($folderid, $this->userid));
     while ($row = $result->fetchRow()) {
         if (!self::deleteById($row['id'])) {
             return false;
         }
     }
     $stmt = \OCP\DB::prepare('DELETE FROM ' . self::tableName . ' WHERE id = ? AND user_id = ?');
     $result = $stmt->execute(array($folderid, $this->userid));
     $feedMapper = new FeedMapper($this->userid);
     //TODO: handle the value that the execute returns
     if (!$feedMapper->deleteAll($folderid)) {
         return false;
     }
     return true;
 }
Exemplo n.º 5
0
<?php

include 'header.php';
$feed = FeedMapper::instance()->find($_GET['id']);
$item_helper = new ItemHelper();
?>

<table>
<th>id</th><th>title</th>

<?php 
foreach ($feed->items() as $item) {
    ?>

<tr>
 <td><?php 
    echo $item->id();
    ?>
</td>
  <td><?php 
    echo $item_helper->link($item);
    ?>
 </td>
</tr>

<?php 
}
?>


Exemplo n.º 6
0
 function feed()
 {
     return FeedMapper::instance()->find($this->feed_id());
 }
Exemplo n.º 7
0
 function mapper()
 {
     return FeedMapper::instance();
 }
Exemplo n.º 8
0
<?php

include 'header.php';
$feeds = FeedMapper::instance()->find_all();
$feed_helper = new FeedHelper();
?>

<table>

<tr><th>id</th><th>title</th><th>feed url</th><th>time to live</th>
 <tr>

<?php 
foreach ($feeds as $feed) {
    ?>
<tr>

<td><?php 
    echo $feed->id();
    ?>
</td>
<td><?php 
    echo $feed_helper->link($feed);
    ?>
</td>
<td><?php 
    echo $feed->feed_url();
    ?>
</td>
<td><?php 
    echo $feed->time_to_live();