summaryrefslogtreecommitdiffstats
path: root/tests/unit/db/FolderMapperTest.php
diff options
context:
space:
mode:
authorBernhard Posselt <dev@bernhard-posselt.com>2016-07-23 21:24:54 +0200
committerBernhard Posselt <dev@bernhard-posselt.com>2016-07-23 21:24:54 +0200
commit004fcbbcc7609ca83807f2e38967ef54f469bf72 (patch)
tree49eb99b4ea92b2045793fc567f719b31ec7f9042 /tests/unit/db/FolderMapperTest.php
parent60abc0ed4438c9b6fda245b0dc33cb483bc2aeaf (diff)
Move to new directory structure
Diffstat (limited to 'tests/unit/db/FolderMapperTest.php')
-rw-r--r--tests/unit/db/FolderMapperTest.php196
1 files changed, 0 insertions, 196 deletions
diff --git a/tests/unit/db/FolderMapperTest.php b/tests/unit/db/FolderMapperTest.php
deleted file mode 100644
index fcb82e7e1..000000000
--- a/tests/unit/db/FolderMapperTest.php
+++ /dev/null
@@ -1,196 +0,0 @@
-<?php
-/**
- * ownCloud - News
- *
- * This file is licensed under the Affero General Public License version 3 or
- * later. See the COPYING file.
- *
- * @author Alessandro Cosentino <cosenal@gmail.com>
- * @author Bernhard Posselt <dev@bernhard-posselt.com>
- * @copyright Alessandro Cosentino 2012
- * @copyright Bernhard Posselt 2012, 2014
- */
-
-namespace OCA\News\Db;
-
-
-use OCA\News\Utility\Time;
-
-class FolderMapperTest extends \OCA\News\Tests\Unit\Db\MapperTestUtility {
-
- private $folderMapper;
- private $folders;
- private $user;
-
- protected function setUp(){
- parent::setUp();
-
- $this->folderMapper = new FolderMapper($this->db, new Time());
-
- // create mock folders
- $folder1 = new Folder();
- $folder2 = new Folder();
-
- $this->folders = [$folder1, $folder2];
- $this->user = 'hh';
- $this->twoRows = [
- ['id' => $this->folders[0]->getId()],
- ['id' => $this->folders[1]->getId()]
- ];
- }
-
-
- public function testFind(){
- $userId = 'john';
- $id = 3;
- $rows = [['id' => $this->folders[0]->getId()]];
- $sql = 'SELECT * FROM `*PREFIX*news_folders` ' .
- 'WHERE `id` = ? ' .
- 'AND `user_id` = ?';
-
- $this->setMapperResult($sql, [$id, $userId], $rows);
-
- $result = $this->folderMapper->find($id, $userId);
- $this->assertEquals($this->folders[0], $result);
-
- }
-
-
- public function testFindNotFound(){
- $userId = 'john';
- $id = 3;
- $sql = 'SELECT * FROM `*PREFIX*news_folders` ' .
- 'WHERE `id` = ? ' .
- 'AND `user_id` = ?';
-
- $this->setMapperResult($sql, [$id, $userId]);
-
- $this->setExpectedException(
- '\OCP\AppFramework\Db\DoesNotExistException'
- );
- $this->folderMapper->find($id, $userId);
- }
-
-
- public function testFindMoreThanOneResultFound(){
- $userId = 'john';
- $id = 3;
- $rows = $this->twoRows;
- $sql = 'SELECT * FROM `*PREFIX*news_folders` ' .
- 'WHERE `id` = ? ' .
- 'AND `user_id` = ?';
-
- $this->setMapperResult($sql, [$id, $userId], $rows);
-
- $this->setExpectedException(
- '\OCP\AppFramework\Db\MultipleObjectsReturnedException'
- );
- $this->folderMapper->find($id, $userId);
- }
-
-
-
- public function testFindAllFromUser(){
- $userId = 'john';
- $rows = $this->twoRows;
- $sql = 'SELECT * FROM `*PREFIX*news_folders` ' .
- 'WHERE `user_id` = ? ' .
- 'AND `deleted_at` = 0';
-
- $this->setMapperResult($sql, [$userId], $rows);
-
- $result = $this->folderMapper->findAllFromUser($userId);
- $this->assertEquals($this->folders, $result);
- }
-
-
- public function testFindByName(){
- $folderName = 'heheh';
- $userId = 'john';
- $rows = $this->twoRows;
- $sql = 'SELECT * FROM `*PREFIX*news_folders` ' .
- 'WHERE `name` = ? ' .
- 'AND `user_id` = ?';
-
- $this->setMapperResult($sql, [$folderName, $userId], $rows);
-
- $result = $this->folderMapper->findByName($folderName, $userId);
- $this->assertEquals($this->folders, $result);
- }
-
-
- public function testDelete(){
- $folder = new Folder();
- $folder->setId(3);
-
- $sql = 'DELETE FROM `*PREFIX*news_folders` WHERE `id` = ?';
- $arguments = [$folder->getId()];
-
- $sql2 = 'DELETE FROM `*PREFIX*news_feeds` WHERE `folder_id` = ?';
- $arguments2 = [$folder->getId()];
-
- $sql3 = 'DELETE FROM `*PREFIX*news_items` WHERE `feed_id` NOT IN '.
- '(SELECT `feeds`.`id` FROM `*PREFIX*news_feeds` `feeds`)';
-
- $this->setMapperResult($sql, $arguments, [], null, null, true);
- $this->setMapperResult($sql2, $arguments2, [], null, null, true);
- $this->setMapperResult($sql3, [], [], null, null, true);
-
- $this->folderMapper->delete($folder);
- }
-
-
- public function testGetPurgeDeleted(){
- $rows = $this->twoRows;
- $deleteOlderThan = 110;
- $sql = 'SELECT * FROM `*PREFIX*news_folders` ' .
- 'WHERE `deleted_at` > 0 ' .
- 'AND `deleted_at` < ? ';
- $this->setMapperResult($sql, [$deleteOlderThan], $rows);
- $result = $this->folderMapper->getToDelete($deleteOlderThan);
-
- $this->assertEquals($this->folders, $result);
- }
-
-
-
- public function testGetPurgeDeletedUser(){
- $rows = $this->twoRows;
- $deleteOlderThan = 110;
- $sql = 'SELECT * FROM `*PREFIX*news_folders` ' .
- 'WHERE `deleted_at` > 0 ' .
- 'AND `deleted_at` < ? ' .
- 'AND `user_id` = ?';
- $this->setMapperResult($sql, [$deleteOlderThan, $this->user], $rows);
- $result = $this->folderMapper->getToDelete(
- $deleteOlderThan, $this->user
- );
-
- $this->assertEquals($this->folders, $result);
- }
-
-
- public function testGetAllPurgeDeletedUser(){
- $rows = $this->twoRows;
-
- $sql = 'SELECT * FROM `*PREFIX*news_folders` ' .
- 'WHERE `deleted_at` > 0 ' .
- 'AND `user_id` = ?';
- $this->setMapperResult($sql, [$this->user], $rows);
- $result = $this->folderMapper->getToDelete(null, $this->user);
-
- $this->assertEquals($this->folders, $result);
- }
-
-
- public function testDeleteFromUser(){
- $userId = 'john';
- $sql = 'DELETE FROM `*PREFIX*news_folders` WHERE `user_id` = ?';
-
- $this->setMapperResult($sql, [$userId]);
-
- $this->folderMapper->deleteUser($userId);
- }
-
-
-} \ No newline at end of file