diff options
author | Alessandro Cosentino <cosenal@gmail.com> | 2013-03-20 18:24:21 +0100 |
---|---|---|
committer | Alessandro Cosentino <cosenal@gmail.com> | 2013-03-20 18:24:21 +0100 |
commit | 843f5e0fd29577489f14164c2e0e664cc67e36fc (patch) | |
tree | 25caaa7415335e0141aa993793e7886545c9fa96 /tests | |
parent | 97855d5d6aa19bb1b02934b8415fb56651e63304 (diff) |
findAll functions in the itemmapper
Diffstat (limited to 'tests')
-rw-r--r-- | tests/db/ItemMapperTest.php | 47 | ||||
-rw-r--r-- | tests/db/ItemMapperTest.php~ | 141 | ||||
-rw-r--r-- | tests/db/NewsMapperTest.php~ | 50 |
3 files changed, 226 insertions, 12 deletions
diff --git a/tests/db/ItemMapperTest.php b/tests/db/ItemMapperTest.php index 675af7ba2..b3be320e7 100644 --- a/tests/db/ItemMapperTest.php +++ b/tests/db/ItemMapperTest.php @@ -28,7 +28,7 @@ namespace OCA\News\Db; require_once(__DIR__ . "/../classloader.php"); -class Test extends \OCA\AppFramework\Utility\MapperTestUtility { +class ItemMapperTest extends \OCA\AppFramework\Utility\MapperTestUtility { private $itemMapper; private $items; @@ -74,10 +74,12 @@ class Test extends \OCA\AppFramework\Utility\MapperTestUtility { $rows = array( array('id' => $this->items[0]->getId()), ); - $sql = 'SELECT * FROM `*PREFIX*news_items` ' . - 'WHERE user_id = ? ' . - 'AND id = ?'; - + $sql = 'SELECT `*dbprefix*news_items`.* FROM `*dbprefix*news_items` ' . + 'JOIN `*dbprefix*news_feeds` ' . + 'ON `*dbprefix*news_feeds`.`id` = `*dbprefix*news_items`.`feed_id` ' . + 'WHERE `*dbprefix*news_items`.`id` = ? ' . + 'AND `*dbprefix*news_feeds`.`user_id` = ? '; + $this->setMapperResult($sql, array($id, $userId), $rows); $result = $this->itemMapper->find($id, $userId); @@ -88,10 +90,12 @@ class Test extends \OCA\AppFramework\Utility\MapperTestUtility { public function testFindNotFound(){ $userId = 'john'; $id = 3; - $sql = 'SELECT * FROM `*PREFIX*news_items` ' . - 'WHERE user_id = ? ' . - 'AND id = ?'; - + $sql = 'SELECT `*dbprefix*news_items`.* FROM `*dbprefix*news_items` ' . + 'JOIN `*dbprefix*news_feeds` ' . + 'ON `*dbprefix*news_feeds`.`id` = `*dbprefix*news_items`.`feed_id` ' . + 'WHERE `*dbprefix*news_items`.`id` = ? ' . + 'AND `*dbprefix*news_feeds`.`user_id` = ? '; + $this->setMapperResult($sql, array($id, $userId)); $this->setExpectedException('\OCA\AppFramework\Db\DoesNotExistException'); @@ -105,13 +109,32 @@ class Test extends \OCA\AppFramework\Utility\MapperTestUtility { array('id' => $this->items[0]->getId()), array('id' => $this->items[1]->getId()) ); - $sql = 'SELECT * FROM `*PREFIX*news_items` ' . - 'WHERE user_id = ? ' . - 'AND id = ?'; + $sql = 'SELECT `*dbprefix*news_items`.* FROM `*dbprefix*news_items` ' . + 'JOIN `*dbprefix*news_feeds` ' . + 'ON `*dbprefix*news_feeds`.`id` = `*dbprefix*news_items`.`feed_id` ' . + 'WHERE `*dbprefix*news_items`.`id` = ? ' . + 'AND `*dbprefix*news_feeds`.`user_id` = ? '; + $this->setMapperResult($sql, array($id, $userId), $rows); $this->setExpectedException('\OCA\AppFramework\Db\MultipleObjectsReturnedException'); $result = $this->itemMapper->find($id, $userId); } + + public function testFindAllFromFolder() { + $userId = 'john'; + $folderId = 3; + $status = 2; + $sql = 'SELECT `*dbprefix*news_items`.* FROM `*dbprefix*news_items` ' . + 'JOIN `*dbprefix*news_feeds` ' . + 'ON `*dbprefix*news_feeds`.`id` = `*dbprefix*news_items`.`feed_id` ' . + 'WHERE `*dbprefix*news_feeds`.`user_id` = ? ' . + 'AND `*dbprefix*news_feeds`.`folder_id` = ? ' . + 'AND ((`*dbprefix*news_items`.`status` & ?) > 0)'; + + $this->setMapperResult($sql, array($userId, $folderId, $status)); + $result = $this->findAllFromFolder($userId, $folderId, $status); + + } }
\ No newline at end of file diff --git a/tests/db/ItemMapperTest.php~ b/tests/db/ItemMapperTest.php~ new file mode 100644 index 000000000..5416dcedd --- /dev/null +++ b/tests/db/ItemMapperTest.php~ @@ -0,0 +1,141 @@ +<?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 ItemMapperTest extends \OCA\AppFramework\Utility\MapperTestUtility { + + private $itemMapper; + private $items; + + protected function setUp(){ + $this->beforeEach(); + + $this->itemMapper = new ItemMapper($this->api); + + // create mock items + $item1 = new Item(); + $item2 = new Item(); + + $this->items = array( + $item1, + $item2 + ); + } + + + public function testFindAllFromFeed(){ + $userId = 'john'; + $feedId = 3; + $rows = array( + array('id' => $this->items[0]->getId()), + array('id' => $this->items[1]->getId()) + ); + $sql = 'SELECT * FROM `*PREFIX*news_items` ' . + 'WHERE user_id = ? ' . + 'AND feed_id = ?'; + + $this->setMapperResult($sql, array($feedId, $userId), $rows); + + $result = $this->itemMapper->findAllFromFeed($feedId, $userId); + + $this->assertEquals($this->items, $result); + + } + + public function testFind(){ + $userId = 'john'; + $id = 3; + $rows = array( + array('id' => $this->items[0]->getId()), + ); + $sql = 'SELECT `*dbprefix*news_items`.* FROM `*dbprefix*news_items` ' . + 'JOIN `*dbprefix*news_feeds` ' . + 'ON `*dbprefix*news_feeds`.`id` = `*dbprefix*news_items`.`feed_id` ' . + 'WHERE `*dbprefix*news_items`.`id` = ? ' . + 'AND `*dbprefix*news_feeds`.`user_id` = ? '; + + $this->setMapperResult($sql, array($id, $userId), $rows); + + $result = $this->itemMapper->find($id, $userId); + $this->assertEquals($this->items[0], $result); + + } + + public function testFindNotFound(){ + $userId = 'john'; + $id = 3; + $sql = 'SELECT `*dbprefix*news_items`.* FROM `*dbprefix*news_items` ' . + 'JOIN `*dbprefix*news_feeds` ' . + 'ON `*dbprefix*news_feeds`.`id` = `*dbprefix*news_items`.`feed_id` ' . + 'WHERE `*dbprefix*news_items`.`id` = ? ' . + 'AND `*dbprefix*news_feeds`.`user_id` = ? '; + + $this->setMapperResult($sql, array($id, $userId)); + + $this->setExpectedException('\OCA\AppFramework\Db\DoesNotExistException'); + $result = $this->itemMapper->find($id, $userId); + } + + public function testFindMoreThanOneResultFound(){ + $userId = 'john'; + $id = 3; + $rows = array( + array('id' => $this->items[0]->getId()), + array('id' => $this->items[1]->getId()) + ); + $sql = 'SELECT `*dbprefix*news_items`.* FROM `*dbprefix*news_items` ' . + 'JOIN `*dbprefix*news_feeds` ' . + 'ON `*dbprefix*news_feeds`.`id` = `*dbprefix*news_items`.`feed_id` ' . + 'WHERE `*dbprefix*news_items`.`id` = ? ' . + 'AND `*dbprefix*news_feeds`.`user_id` = ? '; + + + $this->setMapperResult($sql, array($id, $userId), $rows); + + $this->setExpectedException('\OCA\AppFramework\Db\MultipleObjectsReturnedException'); + $result = $this->itemMapper->find($id, $userId); + } + + public function testFindAllFromFolder() { + $userId = 'john'; + $folderId = 3; + $status = 2; + $sql = 'SELECT `*dbprefix*news_items`.* FROM `*dbprefix*news_items` ' . + 'JOIN `*dbprefix*news_feeds` ' . + 'ON `*dbprefix*news_feeds`.`id` = `*dbprefix*news_items`.`feed_id` ' . + 'WHERE `*dbprefix*news_feeds`.`user_id` = ? ' . + 'AND `*dbprefix*news_feeds`.`folder_id` = ? ' . + 'AND ((`*dbprefix*news_items`.`status` & ?) > 0)'; + + $this->setMapperResult($sql, array($userId, $folderId, $status)); + $result = $this->findAllFromFolder($userId, $folderId, $status); + + + } +}
\ No newline at end of file diff --git a/tests/db/NewsMapperTest.php~ b/tests/db/NewsMapperTest.php~ new file mode 100644 index 000000000..637579143 --- /dev/null +++ b/tests/db/NewsMapperTest.php~ @@ -0,0 +1,50 @@ +<?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 Test extends \OCA\AppFramework\Utility\MapperTestUtility { + + private $itemMapper; + private $items; + + protected function setUp(){ + $this->beforeEach(); + + $this->itemMapper = new ItemMapper($this->api); + + // create mock items + $item1 = new Item(); + $item2 = new Item(); + + $this->items = array( + $item1, + $item2 + ); + } +}
\ No newline at end of file |