summaryrefslogtreecommitdiffstats
path: root/tests/unit/db/FolderMapperTest.php
diff options
context:
space:
mode:
Diffstat (limited to 'tests/unit/db/FolderMapperTest.php')
-rw-r--r--tests/unit/db/FolderMapperTest.php238
1 files changed, 119 insertions, 119 deletions
diff --git a/tests/unit/db/FolderMapperTest.php b/tests/unit/db/FolderMapperTest.php
index 6a2e94588..1078d205f 100644
--- a/tests/unit/db/FolderMapperTest.php
+++ b/tests/unit/db/FolderMapperTest.php
@@ -16,173 +16,173 @@ namespace OCA\News\Db;
class FolderMapperTest extends \Test\AppFramework\Db\MapperTestUtility {
- private $folderMapper;
- private $folders;
- private $user;
+ private $folderMapper;
+ private $folders;
+ private $user;
- protected function setUp(){
- parent::setUp();
+ protected function setUp(){
+ parent::setUp();
- $this->folderMapper = new FolderMapper($this->db);
+ $this->folderMapper = new FolderMapper($this->db);
- // create mock folders
- $folder1 = new Folder();
- $folder2 = new Folder();
+ // 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()]
- ];
- }
+ $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` = ?';
+ 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);
+ $this->setMapperResult($sql, [$id, $userId], $rows);
- $result = $this->folderMapper->find($id, $userId);
- $this->assertEquals($this->folders[0], $result);
+ $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` = ?';
+ public function testFindNotFound(){
+ $userId = 'john';
+ $id = 3;
+ $sql = 'SELECT * FROM `*PREFIX*news_folders` ' .
+ 'WHERE `id` = ? ' .
+ 'AND `user_id` = ?';
- $this->setMapperResult($sql, [$id, $userId]);
+ $this->setMapperResult($sql, [$id, $userId]);
- $this->setExpectedException('\OCP\AppFramework\Db\DoesNotExistException');
- $this->folderMapper->find($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` = ?';
+ 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->setMapperResult($sql, [$id, $userId], $rows);
- $this->setExpectedException('\OCP\AppFramework\Db\MultipleObjectsReturnedException');
- $this->folderMapper->find($id, $userId);
- }
+ $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';
+ 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);
+ $this->setMapperResult($sql, [$userId], $rows);
- $result = $this->folderMapper->findAllFromUser($userId);
- $this->assertEquals($this->folders, $result);
- }
+ $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` = ?';
+ 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);
+ $this->setMapperResult($sql, [$folderName, $userId], $rows);
- $result = $this->folderMapper->findByName($folderName, $userId);
- $this->assertEquals($this->folders, $result);
- }
+ $result = $this->folderMapper->findByName($folderName, $userId);
+ $this->assertEquals($this->folders, $result);
+ }
- public function testDelete(){
- $folder = new Folder();
- $folder->setId(3);
+ public function testDelete(){
+ $folder = new Folder();
+ $folder->setId(3);
- $sql = 'DELETE FROM `*PREFIX*news_folders` WHERE `id` = ?';
- $arguments = [$folder->getId()];
+ $sql = 'DELETE FROM `*PREFIX*news_folders` WHERE `id` = ?';
+ $arguments = [$folder->getId()];
- $sql2 = 'DELETE FROM `*PREFIX*news_feeds` WHERE `folder_id` = ?';
+ $sql2 = 'DELETE FROM `*PREFIX*news_feeds` WHERE `folder_id` = ?';
- $sql3 = 'DELETE FROM `*PREFIX*news_items` WHERE `feed_id` NOT IN '.
- '(SELECT `feeds`.`id` FROM `*PREFIX*news_feeds` `feeds`)';
- $arguments2 = [$folder->getId()];
+ $sql3 = 'DELETE FROM `*PREFIX*news_items` WHERE `feed_id` NOT IN '.
+ '(SELECT `feeds`.`id` FROM `*PREFIX*news_feeds` `feeds`)';
+ $arguments2 = [$folder->getId()];
- $this->setMapperResult($sql, $arguments);
- $this->setMapperResult($sql2, $arguments2);
- $this->setMapperResult($sql3);
+ $this->setMapperResult($sql, $arguments);
+ $this->setMapperResult($sql2, $arguments2);
+ $this->setMapperResult($sql3);
- $this->folderMapper->delete($folder);
- }
+ $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);
+ 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);
- }
+ $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);
+ 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);
- }
+ $this->assertEquals($this->folders, $result);
+ }
- public function testGetAllPurgeDeletedUser(){
- $rows = $this->twoRows;
+ 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);
+ $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);
- }
+ $this->assertEquals($this->folders, $result);
+ }
- public function testDeleteFromUser(){
- $userId = 'john';
- $sql = 'DELETE FROM `*PREFIX*news_folders` WHERE `user_id` = ?';
+ public function testDeleteFromUser(){
+ $userId = 'john';
+ $sql = 'DELETE FROM `*PREFIX*news_folders` WHERE `user_id` = ?';
- $this->setMapperResult($sql, [$userId]);
+ $this->setMapperResult($sql, [$userId]);
- $this->folderMapper->deleteUser($userId);
- }
+ $this->folderMapper->deleteUser($userId);
+ }
} \ No newline at end of file
generated by cgit v1.2.3 (git 2.25.1) at 2024-05-11 16:00:20 +0000