public function findByUrlHash($hash, $userId)
{
$sql = 'SELECT `feeds`.*, COUNT(`items`.`id`) AS `unread_count` ' . 'FROM `*PREFIX*news_feeds` `feeds` ' . 'LEFT JOIN `*PREFIX*news_items` `items` ' . 'ON `feeds`.`id` = `items`.`feed_id` ' . 'AND (`items`.`status` & ' . StatusFlag::UNREAD . ') = ' . StatusFlag::UNREAD . ' ' . 'WHERE `feeds`.`url_hash` = ? ' . 'AND `feeds`.`user_id` = ? ' . 'GROUP BY `feeds`.`id`, `feeds`.`user_id`, `feeds`.`url_hash`,' . '`feeds`.`url`, `feeds`.`title`, `feeds`.`link`,' . '`feeds`.`favicon_link`, `feeds`.`added`, `feeds`.`articles_per_update`,' . '`feeds`.`folder_id`, `feeds`.`prevent_update`, `feeds`.`deleted_at`';
$params = array($hash, $userId);
$row = $this->findOneQuery($sql, $params);
$feed = new Feed();
$feed->fromRow($row);
return $feed;
}
/**
* @expectedException OCA\News\Service\ServiceNotFoundException
*/
public function testOrderingDoesNotExist()
{
$feed = Feed::fromRow(['id' => 3]);
$this->feedMapper->expects($this->once())->method('find')->will($this->throwException(new DoesNotExistException('')));
$this->feedService->setOrdering(3, 2, $this->user);
}
public function testSetPinned()
{
$feed = Feed::fromRow(['id' => 3, 'pinned' => false]);
$this->feedMapper->expects($this->once())->method('find')->with($this->equalTo($feed->getId()), $this->equalTo($this->user))->will($this->returnValue($feed));
$feed->setPinned(true);
$this->feedMapper->expects($this->once())->method('update')->with($this->equalTo($feed));
$this->feedService->setPinned(3, true, $this->user);
}
