1
0
mirror of https://github.com/chylex/Nextcloud-News.git synced 2024-11-24 04:42:46 +01:00
Nextcloud-News/tests/Unit/Db/ItemMapperAfterTest.php
anoy ed066a8129 adapt tests to QBMapper changes in NC22
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-07-17 20:31:29 +02:00

590 lines
18 KiB
PHP

<?php
/**
* Nextcloud - 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 2012 Alessandro Cosentino
* @copyright 2012-2014 Bernhard Posselt
*/
namespace OCA\News\Tests\Unit\Db;
use OCA\News\Db\Item;
use OCA\News\Db\ItemMapperV2;
use OCA\News\Service\Exceptions\ServiceValidationException;
use OCA\News\Utility\Time;
/**
* Class ItemMapperTest
*
* @package OCA\News\Tests\Unit\Db
*/
class ItemMapperAfterTest extends MapperTestUtility
{
/** @var ItemMapperV2 */
private $class;
/**
* @covers \OCA\News\Db\ItemMapperV2::__construct
*/
protected function setUp(): void
{
parent::setUp();
$time = $this->getMockBuilder(Time::class)
->getMock();
$this->class = new ItemMapperV2($this->db, $time);
}
public function testFindAllInFeedAfter()
{
$this->db->expects($this->once())
->method('getQueryBuilder')
->willReturn($this->builder);
$this->builder->expects($this->once())
->method('select')
->with('items.*')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('from')
->with('news_items', 'items')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('innerJoin')
->with('items', 'news_feeds', 'feeds', 'items.feed_id = feeds.id')
->will($this->returnSelf());
$this->builder->expects($this->exactly(4))
->method('andWhere')
->withConsecutive(
['items.last_modified >= :updatedSince'],
['feeds.user_id = :userId'],
['feeds.id = :feedId'],
['feeds.deleted_at = 0']
)
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('setParameters')
->with([
'updatedSince' => 1610903351,
'feedId' => 4,
'userId' => 'jack',
])
->will($this->returnSelf());
$this->builder->expects($this->never())
->method('orderBy')
->with('items.last_modified', 'DESC')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('addOrderBy')
->with('items.id', 'DESC')
->willReturnSelf();
$this->builder->expects($this->once())
->method('executeQuery')
->willReturn($this->cursor);
$this->cursor->expects($this->exactly(2))
->method('fetch')
->willReturnOnConsecutiveCalls(
['id' => 4],
false
);
$result = $this->class->findAllInFeedAfter('jack', 4, 1610903351, false);
$this->assertEquals([Item::fromRow(['id' => 4])], $result);
}
public function testFindAllInFeedAfterHideRead()
{
$this->db->expects($this->once())
->method('getQueryBuilder')
->willReturn($this->builder);
$this->builder->expects($this->once())
->method('select')
->with('items.*')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('from')
->with('news_items', 'items')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('innerJoin')
->with('items', 'news_feeds', 'feeds', 'items.feed_id = feeds.id')
->will($this->returnSelf());
$this->builder->expects($this->exactly(5))
->method('andWhere')
->withConsecutive(
['items.last_modified >= :updatedSince'],
['feeds.user_id = :userId'],
['feeds.id = :feedId'],
['feeds.deleted_at = 0'],
['items.unread = :unread']
)
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('setParameters')
->with([
'updatedSince' => 1610903351,
'feedId' => 4,
'userId' => 'jack',
])
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('setParameter')
->with('unread', true)
->will($this->returnSelf());
$this->builder->expects($this->never())
->method('orderBy')
->with('items.last_modified', 'DESC')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('addOrderBy')
->with('items.id', 'DESC')
->willReturnSelf();
$this->builder->expects($this->once())
->method('executeQuery')
->willReturn($this->cursor);
$this->cursor->expects($this->exactly(2))
->method('fetch')
->willReturnOnConsecutiveCalls(
['id' => 4],
false
);
$result = $this->class->findAllInFeedAfter('jack', 4, 1610903351, true);
$this->assertEquals([Item::fromRow(['id' => 4])], $result);
}
public function testFindAllInFolderAfter()
{
$this->db->expects($this->once())
->method('getQueryBuilder')
->willReturn($this->builder);
$this->builder->expects($this->once())
->method('select')
->with('items.*')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('from')
->with('news_items', 'items')
->will($this->returnSelf());
$this->builder->expects($this->exactly(2))
->method('innerJoin')
->withConsecutive(
['items', 'news_feeds', 'feeds', 'items.feed_id = feeds.id'],
['feeds', 'news_folders', 'folders', 'feeds.folder_id = folders.id']
)
->will($this->returnSelf());
$this->builder->expects($this->exactly(4))
->method('andWhere')
->withConsecutive(
['items.last_modified >= :updatedSince'],
['feeds.user_id = :userId'],
['feeds.deleted_at = 0'],
['folders.id = :folderId']
)
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('setParameters')
->with([
'updatedSince' => 1610903351,
'folderId' => 4,
'userId' => 'jack',
])
->will($this->returnSelf());
$this->builder->expects($this->never())
->method('orderBy')
->with('items.last_modified', 'DESC')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('addOrderBy')
->with('items.id', 'DESC')
->willReturnSelf();
$this->builder->expects($this->once())
->method('executeQuery')
->willReturn($this->cursor);
$this->cursor->expects($this->exactly(2))
->method('fetch')
->willReturnOnConsecutiveCalls(
['id' => 4],
false
);
$result = $this->class->findAllInFolderAfter('jack', 4, 1610903351, false);
$this->assertEquals([Item::fromRow(['id' => 4])], $result);
}
public function testFindAllInFolderAfterHideRead()
{
$this->db->expects($this->once())
->method('getQueryBuilder')
->willReturn($this->builder);
$this->builder->expects($this->once())
->method('select')
->with('items.*')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('from')
->with('news_items', 'items')
->will($this->returnSelf());
$this->builder->expects($this->exactly(2))
->method('innerJoin')
->withConsecutive(
['items', 'news_feeds', 'feeds', 'items.feed_id = feeds.id'],
['feeds', 'news_folders', 'folders', 'feeds.folder_id = folders.id']
)
->will($this->returnSelf());
$this->builder->expects($this->exactly(5))
->method('andWhere')
->withConsecutive(
['items.last_modified >= :updatedSince'],
['feeds.user_id = :userId'],
['feeds.deleted_at = 0'],
['folders.id = :folderId'],
['items.unread = :unread']
)
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('setParameters')
->with([
'updatedSince' => 1610903351,
'folderId' => 4,
'userId' => 'jack',
])
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('setParameter')
->with('unread', true)
->will($this->returnSelf());
$this->builder->expects($this->never())
->method('orderBy')
->with('items.last_modified', 'DESC')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('addOrderBy')
->with('items.id', 'DESC')
->willReturnSelf();
$this->builder->expects($this->once())
->method('executeQuery')
->willReturn($this->cursor);
$this->cursor->expects($this->exactly(2))
->method('fetch')
->willReturnOnConsecutiveCalls(
['id' => 4],
false
);
$result = $this->class->findAllInFolderAfter('jack', 4, 1610903351, true);
$this->assertEquals([Item::fromRow(['id' => 4])], $result);
}
public function testFindAllAfterUnread()
{
$this->db->expects($this->once())
->method('getQueryBuilder')
->willReturn($this->builder);
$this->builder->expects($this->once())
->method('select')
->with('items.*')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('from')
->with('news_items', 'items')
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('innerJoin')
->withConsecutive(['items', 'news_feeds', 'feeds', 'items.feed_id = feeds.id'])
->will($this->returnSelf());
$this->builder->expects($this->exactly(4))
->method('andWhere')
->withConsecutive(
['items.last_modified >= :updatedSince'],
['feeds.deleted_at = 0'],
['feeds.user_id = :userId'],
['items.unread = :unread']
)
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('setParameters')
->with([
'updatedSince' => 1610903351,
'userId' => 'jack',
])
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('setParameter')
->with('unread', true)
->will($this->returnSelf());
$this->builder->expects($this->never())
->method('orderBy')
->with('items.last_modified', 'DESC')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('addOrderBy')
->with('items.id', 'DESC')
->willReturnSelf();
$this->builder->expects($this->once())
->method('executeQuery')
->willReturn($this->cursor);
$this->cursor->expects($this->exactly(2))
->method('fetch')
->willReturnOnConsecutiveCalls(
['id' => 4],
false
);
$result = $this->class->findAllAfter('jack', 6, 1610903351);
$this->assertEquals([Item::fromRow(['id' => 4])], $result);
}
public function testFindAllAfterStarred()
{
$this->db->expects($this->once())
->method('getQueryBuilder')
->willReturn($this->builder);
$this->builder->expects($this->once())
->method('select')
->with('items.*')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('from')
->with('news_items', 'items')
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('innerJoin')
->withConsecutive(['items', 'news_feeds', 'feeds', 'items.feed_id = feeds.id'])
->will($this->returnSelf());
$this->builder->expects($this->exactly(4))
->method('andWhere')
->withConsecutive(
['items.last_modified >= :updatedSince'],
['feeds.deleted_at = 0'],
['feeds.user_id = :userId'],
['items.starred = :starred']
)
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('setParameters')
->with([
'updatedSince' => 1610903351,
'userId' => 'jack',
])
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('setParameter')
->with('starred', true)
->will($this->returnSelf());
$this->builder->expects($this->never())
->method('orderBy')
->with('items.last_modified', 'DESC')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('addOrderBy')
->with('items.id', 'DESC')
->willReturnSelf();
$this->builder->expects($this->once())
->method('executeQuery')
->willReturn($this->cursor);
$this->cursor->expects($this->exactly(2))
->method('fetch')
->willReturnOnConsecutiveCalls(
['id' => 4],
false
);
$result = $this->class->findAllAfter('jack', 2, 1610903351);
$this->assertEquals([Item::fromRow(['id' => 4])], $result);
}
public function testFindAllAfterAll()
{
$this->db->expects($this->once())
->method('getQueryBuilder')
->willReturn($this->builder);
$this->builder->expects($this->once())
->method('select')
->with('items.*')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('from')
->with('news_items', 'items')
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('innerJoin')
->withConsecutive(['items', 'news_feeds', 'feeds', 'items.feed_id = feeds.id'])
->will($this->returnSelf());
$this->builder->expects($this->exactly(3))
->method('andWhere')
->withConsecutive(
['items.last_modified >= :updatedSince'],
['feeds.deleted_at = 0'],
['feeds.user_id = :userId']
)
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('setParameters')
->with([
'updatedSince' => 1610903351,
'userId' => 'jack',
])
->will($this->returnSelf());
$this->builder->expects($this->never())
->method('orderBy')
->with('items.last_modified', 'DESC')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('addOrderBy')
->with('items.id', 'DESC')
->willReturnSelf();
$this->builder->expects($this->once())
->method('executeQuery')
->willReturn($this->cursor);
$this->cursor->expects($this->exactly(2))
->method('fetch')
->willReturnOnConsecutiveCalls(
['id' => 4],
false
);
$result = $this->class->findAllAfter('jack', 3, 1610903351);
$this->assertEquals([Item::fromRow(['id' => 4])], $result);
}
public function testFindAllAfterInvalid()
{
$this->expectException(ServiceValidationException::class);
$this->expectExceptionMessage('Unexpected Feed type in call');
$this->db->expects($this->once())
->method('getQueryBuilder')
->willReturn($this->builder);
$this->builder->expects($this->once())
->method('select')
->with('items.*')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('from')
->with('news_items', 'items')
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('innerJoin')
->withConsecutive(['items', 'news_feeds', 'feeds', 'items.feed_id = feeds.id'])
->will($this->returnSelf());
$this->builder->expects($this->exactly(3))
->method('andWhere')
->withConsecutive(
['items.last_modified >= :updatedSince'],
['feeds.deleted_at = 0'],
['feeds.user_id = :userId']
)
->will($this->returnSelf());
$this->builder->expects($this->exactly(1))
->method('setParameters')
->with([
'updatedSince' => 1610903351,
'userId' => 'jack',
])
->will($this->returnSelf());
$this->builder->expects($this->never())
->method('orderBy')
->with('items.last_modified', 'DESC')
->will($this->returnSelf());
$this->builder->expects($this->once())
->method('addOrderBy')
->with('items.id', 'DESC')
->willReturnSelf();
$this->builder->expects($this->never())
->method('executeQuery')
->willReturn($this->cursor);
$this->cursor->expects($this->never())
->method('fetch')
->willReturnOnConsecutiveCalls(
['id' => 4],
false
);
$result = $this->class->findAllAfter('jack', 232, 1610903351);
$this->assertEquals([Item::fromRow(['id' => 4])], $result);
}
}