moved tests into unit directory

1 files changed, 258 insertions, 0 deletions

diff --git a/tests/unit/db/FeedMapperTest.php b/tests/unit/db/FeedMapperTest.php
new file mode 100644
index 000000000..58ea8c4ed
--- /dev/null
+++ b/tests/unit/db/FeedMapperTest.php
@@ -0,0 +1,258 @@
+<?php
+
+/**
+* ownCloud - News
+*
+* @author Alessandro Cosentino
+* @author Bernhard Posselt
+* @copyright 2012 Alessandro Cosentino cosenal@gmail.com
+* @copyright 2012 Bernhard Posselt nukeawhale@gmail.com
+*
+* This library is free software; you can redistribute it and/or
+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE
+* License as published by the Free Software Foundation; either
+* version 3 of the License, or any later version.
+*
+* This library is distributed in the hope that it will be useful,
+* but WITHOUT ANY WARRANTY; without even the implied warranty of
+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.
+*
+* You should have received a copy of the GNU Affero General Public
+* License along with this library.  If not, see <http://www.gnu.org/licenses/>.
+*
+*/
+
+namespace OCA\News\Db;
+
+require_once(__DIR__ . "/../../classloader.php");
+
+
+class FeedMapperTest extends \OCA\AppFramework\Utility\MapperTestUtility {
+
+	private $mapper;
+	private $feeds;
+	
+	protected function setUp(){
+		$this->beforeEach();
+
+		$this->mapper = new FeedMapper($this->api);
+
+		// create mock feeds
+		$feed1 = new Feed();
+		$feed2 = new Feed();
+
+		$this->feeds = array(
+			$feed1,
+			$feed2
+		);
+		$this->user = 'herman';
+	}
+
+
+	public function testFind(){
+		$userId = 'john';
+		$id = 3;
+		$rows = array(
+		  array('id' => $this->feeds[0]->getId()),
+		);
+		$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` & ?) = ? ' .
+			'WHERE `feeds`.`id` = ? ' .
+				'AND `feeds`.`user_id` = ? ' .
+			'GROUP BY `feeds`.`id`';
+		$params = array(StatusFlag::UNREAD, StatusFlag::UNREAD, $id, $userId);
+		$this->setMapperResult($sql, $params, $rows);
+		
+		$result = $this->mapper->find($id, $userId);
+		$this->assertEquals($this->feeds[0], $result);
+		
+	}
+
+
+	public function testFindNotFound(){
+		$userId = 'john';
+		$id = 3;
+		$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` & ?) = ? ' .
+			'WHERE `feeds`.`id` = ? ' .
+				'AND `feeds`.`user_id` = ? ' .
+			'GROUP BY `feeds`.`id`';
+		$params = array(StatusFlag::UNREAD, StatusFlag::UNREAD, $id, $userId);
+		$this->setMapperResult($sql, $params);
+		
+		$this->setExpectedException('\OCA\AppFramework\Db\DoesNotExistException');
+		$result = $this->mapper->find($id, $userId);	
+	}
+	
+
+	public function testFindMoreThanOneResultFound(){
+		$userId = 'john';
+		$id = 3;
+		$rows = array(
+			array('id' => $this->feeds[0]->getId()),
+			array('id' => $this->feeds[1]->getId())
+		);
+		$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` & ?) = ? ' .
+			'WHERE `feeds`.`id` = ? ' .
+				'AND `feeds`.`user_id` = ? ' .
+			'GROUP BY `feeds`.`id`';
+		$params = array(StatusFlag::UNREAD, StatusFlag::UNREAD, $id, $userId);
+		$this->setMapperResult($sql, $params, $rows);
+				
+		$this->setExpectedException('\OCA\AppFramework\Db\MultipleObjectsReturnedException');
+		$result = $this->mapper->find($id, $userId);
+	}
+
+
+	public function testFindAll(){
+		$userId = 'john';
+		$rows = array(
+			array('id' => $this->feeds[0]->getId()),
+			array('id' => $this->feeds[1]->getId())
+		);
+		$sql = 'SELECT * FROM `*PREFIX*news_feeds`';
+		
+		$this->setMapperResult($sql, array(), $rows);
+		
+		$result = $this->mapper->findAll();
+		$this->assertEquals($this->feeds, $result);
+	}
+
+
+	public function testFindAllFromUser(){
+		$userId = 'john';
+		$rows = array(
+			array('id' => $this->feeds[0]->getId()),
+			array('id' => $this->feeds[1]->getId())
+		);
+		$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` & ?) = ? ' .
+			'WHERE `feeds`.`user_id` = ? ' .
+			'GROUP BY `feeds`.`id`';
+		
+		$this->setMapperResult($sql, 
+			array(StatusFlag::UNREAD, StatusFlag::UNREAD, $userId), $rows);
+		
+		$result = $this->mapper->findAllFromUser($userId);
+		$this->assertEquals($this->feeds, $result);
+	}
+
+
+	public function testFindByUrlHash(){
+		$urlHash = md5('hihi');
+		$row = array(
+			array('id' => $this->feeds[0]->getId()),
+		);
+		$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` & ?) = ? ' .
+			'WHERE `feeds`.`url_hash` = ? ' .
+				'AND `feeds`.`user_id` = ? ' .
+			'GROUP BY `feeds`.`id`';
+		$this->setMapperResult($sql, 
+			array(StatusFlag::UNREAD, StatusFlag::UNREAD, $urlHash, $this->user), $row);
+		
+		$result = $this->mapper->findByUrlHash($urlHash, $this->user);
+		$this->assertEquals($this->feeds[0], $result);
+	}
+
+
+	public function testFindByUrlHashNotFound(){
+		$urlHash = md5('hihi');
+		$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` & ?) = ? ' .
+			'WHERE `feeds`.`url_hash` = ? ' .
+				'AND `feeds`.`user_id` = ? ' .
+			'GROUP BY `feeds`.`id`';
+		$this->setMapperResult($sql, 
+			array(StatusFlag::UNREAD, StatusFlag::UNREAD, $urlHash, $this->user));
+			
+		$this->setExpectedException('\OCA\AppFramework\Db\DoesNotExistException');
+		$result = $this->mapper->findByUrlHash($urlHash, $this->user);	
+	}
+	
+
+	public function testFindByUrlHashMoreThanOneResultFound(){
+		$urlHash = md5('hihi');
+		$rows = array(
+			array('id' => $this->feeds[0]->getId()),
+			array('id' => $this->feeds[1]->getId())
+		);
+		$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` & ?) = ? ' .
+			'WHERE `feeds`.`url_hash` = ? ' .
+				'AND `feeds`.`user_id` = ? ' .
+			'GROUP BY `feeds`.`id`';
+		$this->setMapperResult($sql, 
+			array(StatusFlag::UNREAD, StatusFlag::UNREAD, $urlHash, $this->user), $rows);
+		
+		$this->setExpectedException('\OCA\AppFramework\Db\MultipleObjectsReturnedException');
+		$result = $this->mapper->findByUrlHash($urlHash, $this->user);	
+	}
+
+
+	public function testDelete(){
+		$feed = new Feed();
+		$feed->setId(3);
+
+		$sql = 'DELETE FROM `*PREFIX*news_feeds` WHERE `id` = ?';
+		$arguments = array($feed->getId());
+
+		$sql2 = 'DELETE FROM `*PREFIX*news_items` WHERE `feed_id` = ?';
+		$arguments2 = array($feed->getId());
+
+		$pdoResult = $this->getMock('Result', 
+			array('fetchRow'));
+		$pdoResult->expects($this->any())
+			->method('fetchRow');
+		
+		$query = $this->getMock('Query', 
+			array('execute'));
+		$query->expects($this->at(0))
+			->method('execute')
+			->with($this->equalTo($arguments))
+			->will($this->returnValue($pdoResult));
+		$this->api->expects($this->at(0))
+			->method('prepareQuery')
+			->with($this->equalTo($sql))
+			->will(($this->returnValue($query)));	
+		
+		$query->expects($this->at(1))
+			->method('execute')
+			->with($this->equalTo($arguments2))
+			->will($this->returnValue($pdoResult));
+		$this->api->expects($this->at(1))
+			->method('prepareQuery')
+			->with($this->equalTo($sql2))
+			->will(($this->returnValue($query)));
+
+		$this->mapper->delete($feed);
+
+	}
+
+
+	
+
+}
\ No newline at end of file