nextcloud / server

tests/lib/Comments/ManagerTest.php

Indentation +2554 added lines, -2554 removed lines

@@ -32,2571 +32,2571 @@
  * @group DB
  */
 class ManagerTest extends TestCase {
-	/** @var IDBConnection */
-	private $connection;
-	/** @var \PHPUnit\Framework\MockObject\MockObject|IRootFolder */
-	private $rootFolder;
-
-	protected function setUp(): void {
-		parent::setUp();
-
-		$this->connection = \OC::$server->getDatabaseConnection();
-		$this->rootFolder = $this->createMock(IRootFolder::class);
-
-		$sql = $this->connection->getDatabasePlatform()->getTruncateTableSQL('`*PREFIX*comments`');
-		$this->connection->prepare($sql)->execute();
-		$sql = $this->connection->getDatabasePlatform()->getTruncateTableSQL('`*PREFIX*reactions`');
-		$this->connection->prepare($sql)->execute();
-	}
-
-	protected function addDatabaseEntry($parentId, $topmostParentId, $creationDT = null, $latestChildDT = null, $objectId = null, $expireDate = null) {
-		if (is_null($creationDT)) {
-			$creationDT = new \DateTime();
-		}
-		if (is_null($latestChildDT)) {
-			$latestChildDT = new \DateTime('yesterday');
-		}
-		if (is_null($objectId)) {
-			$objectId = 'file64';
-		}
-
-		$qb = $this->connection->getQueryBuilder();
-		$qb
-			->insert('comments')
-			->values([
-				'parent_id' => $qb->createNamedParameter($parentId),
-				'topmost_parent_id' => $qb->createNamedParameter($topmostParentId),
-				'children_count' => $qb->createNamedParameter(2),
-				'actor_type' => $qb->createNamedParameter('users'),
-				'actor_id' => $qb->createNamedParameter('alice'),
-				'message' => $qb->createNamedParameter('nice one'),
-				'verb' => $qb->createNamedParameter('comment'),
-				'creation_timestamp' => $qb->createNamedParameter($creationDT, IQueryBuilder::PARAM_DATETIME_MUTABLE),
-				'latest_child_timestamp' => $qb->createNamedParameter($latestChildDT, IQueryBuilder::PARAM_DATETIME_MUTABLE),
-				'object_type' => $qb->createNamedParameter('files'),
-				'object_id' => $qb->createNamedParameter($objectId),
-				'expire_date' => $qb->createNamedParameter($expireDate, IQueryBuilder::PARAM_DATETIME_MUTABLE),
-				'reference_id' => $qb->createNamedParameter('referenceId'),
-				'meta_data' => $qb->createNamedParameter(json_encode(['last_edit_actor_id' => 'admin'])),
-			])
-			->execute();
-
-		return $qb->getLastInsertId();
-	}
-
-	protected function getManager() {
-		return new Manager(
-			$this->connection,
-			$this->createMock(LoggerInterface::class),
-			$this->createMock(IConfig::class),
-			$this->createMock(ITimeFactory::class),
-			new EmojiHelper($this->connection),
-			$this->createMock(IInitialStateService::class),
-			$this->rootFolder,
-			$this->createMock(IEventDispatcher::class),
-		);
-	}
-
-
-	public function testGetCommentNotFound(): void {
-		$this->expectException(\OCP\Comments\NotFoundException::class);
-
-		$manager = $this->getManager();
-		$manager->get('22');
-	}
-
-
-	public function testGetCommentNotFoundInvalidInput(): void {
-		$this->expectException(\InvalidArgumentException::class);
-
-		$manager = $this->getManager();
-		$manager->get('unexisting22');
-	}
-
-	public function testGetComment(): void {
-		$manager = $this->getManager();
-
-		$creationDT = new \DateTime();
-		$latestChildDT = new \DateTime('yesterday');
-
-		$qb = \OC::$server->getDatabaseConnection()->getQueryBuilder();
-		$qb
-			->insert('comments')
-			->values([
-				'parent_id' => $qb->createNamedParameter('2'),
-				'topmost_parent_id' => $qb->createNamedParameter('1'),
-				'children_count' => $qb->createNamedParameter(2),
-				'actor_type' => $qb->createNamedParameter('users'),
-				'actor_id' => $qb->createNamedParameter('alice'),
-				'message' => $qb->createNamedParameter('nice one'),
-				'verb' => $qb->createNamedParameter('comment'),
-				'creation_timestamp' => $qb->createNamedParameter($creationDT, 'datetime'),
-				'latest_child_timestamp' => $qb->createNamedParameter($latestChildDT, 'datetime'),
-				'object_type' => $qb->createNamedParameter('files'),
-				'object_id' => $qb->createNamedParameter('file64'),
-				'reference_id' => $qb->createNamedParameter('referenceId'),
-				'meta_data' => $qb->createNamedParameter(json_encode(['last_edit_actor_id' => 'admin'])),
-			])
-			->execute();
-
-		$id = strval($qb->getLastInsertId());
-
-		$comment = $manager->get($id);
-		$this->assertTrue($comment instanceof IComment);
-		$this->assertSame($comment->getId(), $id);
-		$this->assertSame($comment->getParentId(), '2');
-		$this->assertSame($comment->getTopmostParentId(), '1');
-		$this->assertSame($comment->getChildrenCount(), 2);
-		$this->assertSame($comment->getActorType(), 'users');
-		$this->assertSame($comment->getActorId(), 'alice');
-		$this->assertSame($comment->getMessage(), 'nice one');
-		$this->assertSame($comment->getVerb(), 'comment');
-		$this->assertSame($comment->getObjectType(), 'files');
-		$this->assertSame($comment->getObjectId(), 'file64');
-		$this->assertEquals($comment->getCreationDateTime()->getTimestamp(), $creationDT->getTimestamp());
-		$this->assertEquals($comment->getLatestChildDateTime(), $latestChildDT);
-		$this->assertEquals($comment->getReferenceId(), 'referenceId');
-		$this->assertEquals($comment->getMetaData(), ['last_edit_actor_id' => 'admin']);
-	}
-
-
-	public function testGetTreeNotFound(): void {
-		$this->expectException(\OCP\Comments\NotFoundException::class);
-
-		$manager = $this->getManager();
-		$manager->getTree('22');
-	}
-
-
-	public function testGetTreeNotFoundInvalidIpnut(): void {
-		$this->expectException(\InvalidArgumentException::class);
-
-		$manager = $this->getManager();
-		$manager->getTree('unexisting22');
-	}
-
-	public function testGetTree(): void {
-		$headId = $this->addDatabaseEntry(0, 0);
-
-		$this->addDatabaseEntry($headId, $headId, new \DateTime('-3 hours'));
-		$this->addDatabaseEntry($headId, $headId, new \DateTime('-2 hours'));
-		$id = $this->addDatabaseEntry($headId, $headId, new \DateTime('-1 hour'));
-
-		$manager = $this->getManager();
-		$tree = $manager->getTree($headId);
-
-		// Verifying the root comment
-		$this->assertTrue(isset($tree['comment']));
-		$this->assertTrue($tree['comment'] instanceof IComment);
-		$this->assertSame($tree['comment']->getId(), strval($headId));
-		$this->assertTrue(isset($tree['replies']));
-		$this->assertSame(count($tree['replies']), 3);
-
-		// one level deep
-		foreach ($tree['replies'] as $reply) {
-			$this->assertTrue($reply['comment'] instanceof IComment);
-			$this->assertSame($reply['comment']->getId(), strval($id));
-			$this->assertSame(count($reply['replies']), 0);
-			$id--;
-		}
-	}
-
-	public function testGetTreeNoReplies(): void {
-		$id = $this->addDatabaseEntry(0, 0);
-
-		$manager = $this->getManager();
-		$tree = $manager->getTree($id);
-
-		// Verifying the root comment
-		$this->assertTrue(isset($tree['comment']));
-		$this->assertTrue($tree['comment'] instanceof IComment);
-		$this->assertSame($tree['comment']->getId(), strval($id));
-		$this->assertTrue(isset($tree['replies']));
-		$this->assertSame(count($tree['replies']), 0);
-
-		// one level deep
-		foreach ($tree['replies'] as $reply) {
-			throw new \Exception('This ain`t happen');
-		}
-	}
-
-	public function testGetTreeWithLimitAndOffset(): void {
-		$headId = $this->addDatabaseEntry(0, 0);
-
-		$this->addDatabaseEntry($headId, $headId, new \DateTime('-3 hours'));
-		$this->addDatabaseEntry($headId, $headId, new \DateTime('-2 hours'));
-		$this->addDatabaseEntry($headId, $headId, new \DateTime('-1 hour'));
-		$idToVerify = $this->addDatabaseEntry($headId, $headId, new \DateTime());
-
-		$manager = $this->getManager();
-
-		for ($offset = 0; $offset < 3; $offset += 2) {
-			$tree = $manager->getTree(strval($headId), 2, $offset);
-
-			// Verifying the root comment
-			$this->assertTrue(isset($tree['comment']));
-			$this->assertTrue($tree['comment'] instanceof IComment);
-			$this->assertSame($tree['comment']->getId(), strval($headId));
-			$this->assertTrue(isset($tree['replies']));
-			$this->assertSame(count($tree['replies']), 2);
-
-			// one level deep
-			foreach ($tree['replies'] as $reply) {
-				$this->assertTrue($reply['comment'] instanceof IComment);
-				$this->assertSame($reply['comment']->getId(), strval($idToVerify));
-				$this->assertSame(count($reply['replies']), 0);
-				$idToVerify--;
-			}
-		}
-	}
-
-	public function testGetForObject(): void {
-		$this->addDatabaseEntry(0, 0);
-
-		$manager = $this->getManager();
-		$comments = $manager->getForObject('files', 'file64');
-
-		$this->assertTrue(is_array($comments));
-		$this->assertSame(count($comments), 1);
-		$this->assertTrue($comments[0] instanceof IComment);
-		$this->assertSame($comments[0]->getMessage(), 'nice one');
-	}
-
-	public function testGetForObjectWithLimitAndOffset(): void {
-		$this->addDatabaseEntry(0, 0, new \DateTime('-6 hours'));
-		$this->addDatabaseEntry(0, 0, new \DateTime('-5 hours'));
-		$this->addDatabaseEntry(1, 1, new \DateTime('-4 hours'));
-		$this->addDatabaseEntry(0, 0, new \DateTime('-3 hours'));
-		$this->addDatabaseEntry(2, 2, new \DateTime('-2 hours'));
-		$this->addDatabaseEntry(2, 2, new \DateTime('-1 hours'));
-		$idToVerify = $this->addDatabaseEntry(3, 1, new \DateTime());
-
-		$manager = $this->getManager();
-		$offset = 0;
-		do {
-			$comments = $manager->getForObject('files', 'file64', 3, $offset);
-
-			$this->assertTrue(is_array($comments));
-			foreach ($comments as $comment) {
-				$this->assertTrue($comment instanceof IComment);
-				$this->assertSame($comment->getMessage(), 'nice one');
-				$this->assertSame($comment->getId(), strval($idToVerify));
-				$idToVerify--;
-			}
-			$offset += 3;
-		} while (count($comments) > 0);
-	}
-
-	public function testGetForObjectWithDateTimeConstraint(): void {
-		$this->addDatabaseEntry(0, 0, new \DateTime('-6 hours'));
-		$this->addDatabaseEntry(0, 0, new \DateTime('-5 hours'));
-		$id1 = $this->addDatabaseEntry(0, 0, new \DateTime('-3 hours'));
-		$id2 = $this->addDatabaseEntry(2, 2, new \DateTime('-2 hours'));
-
-		$manager = $this->getManager();
-		$comments = $manager->getForObject('files', 'file64', 0, 0, new \DateTime('-4 hours'));
-
-		$this->assertSame(count($comments), 2);
-		$this->assertSame($comments[0]->getId(), strval($id2));
-		$this->assertSame($comments[1]->getId(), strval($id1));
-	}
-
-	public function testGetForObjectWithLimitAndOffsetAndDateTimeConstraint(): void {
-		$this->addDatabaseEntry(0, 0, new \DateTime('-7 hours'));
-		$this->addDatabaseEntry(0, 0, new \DateTime('-6 hours'));
-		$this->addDatabaseEntry(1, 1, new \DateTime('-5 hours'));
-		$this->addDatabaseEntry(0, 0, new \DateTime('-3 hours'));
-		$this->addDatabaseEntry(2, 2, new \DateTime('-2 hours'));
-		$this->addDatabaseEntry(2, 2, new \DateTime('-1 hours'));
-		$idToVerify = $this->addDatabaseEntry(3, 1, new \DateTime());
-
-		$manager = $this->getManager();
-		$offset = 0;
-		do {
-			$comments = $manager->getForObject('files', 'file64', 3, $offset, new \DateTime('-4 hours'));
-
-			$this->assertTrue(is_array($comments));
-			foreach ($comments as $comment) {
-				$this->assertTrue($comment instanceof IComment);
-				$this->assertSame($comment->getMessage(), 'nice one');
-				$this->assertSame($comment->getId(), strval($idToVerify));
-				$this->assertTrue(intval($comment->getId()) >= 4);
-				$idToVerify--;
-			}
-			$offset += 3;
-		} while (count($comments) > 0);
-	}
-
-	public function testGetNumberOfCommentsForObject(): void {
-		for ($i = 1; $i < 5; $i++) {
-			$this->addDatabaseEntry(0, 0);
-		}
-
-		$manager = $this->getManager();
-
-		$amount = $manager->getNumberOfCommentsForObject('untype', '00');
-		$this->assertSame($amount, 0);
-
-		$amount = $manager->getNumberOfCommentsForObject('files', 'file64');
-		$this->assertSame($amount, 4);
-	}
-
-	public function testGetNumberOfUnreadCommentsForFolder(): void {
-		$folder = $this->createMock(Folder::class);
-		$fileIds = range(1111, 1114);
-		$children = array_map(function (int $id) {
-			$file = $this->createMock(Folder::class);
-			$file->method('getId')
-				->willReturn($id);
-			return $file;
-		}, $fileIds);
-		$folder->method('getId')->willReturn(1000);
-		$folder->method('getDirectoryListing')->willReturn($children);
-		$this->rootFolder->method('getFirstNodeById')
-			->with($folder->getId())
-			->willReturn($folder);
-
-		// 2 comment for 1111 with 1 before read marker
-		// 2 comments for 1112 with no read marker
-		// 1 comment for 1113 before read marker
-		// 1 comment for 1114 with no read marker
-		$this->addDatabaseEntry(0, 0, null, null, $fileIds[1]);
-		for ($i = 0; $i < 4; $i++) {
-			$this->addDatabaseEntry(0, 0, null, null, $fileIds[$i]);
-		}
-		$this->addDatabaseEntry(0, 0, (new \DateTime())->modify('-2 days'), null, $fileIds[0]);
-		/** @var IUser|\PHPUnit\Framework\MockObject\MockObject $user */
-		$user = $this->createMock(IUser::class);
-		$user->expects($this->any())
-			->method('getUID')
-			->willReturn('comment_test');
-
-		$manager = $this->getManager();
-
-		$manager->setReadMark('files', (string)$fileIds[0], (new \DateTime())->modify('-1 days'), $user);
-		$manager->setReadMark('files', (string)$fileIds[2], (new \DateTime()), $user);
-
-		$amount = $manager->getNumberOfUnreadCommentsForFolder($folder->getId(), $user);
-		$this->assertEquals([
-			$fileIds[0] => 1,
-			$fileIds[1] => 2,
-			$fileIds[3] => 1,
-		], $amount);
-	}
-
-	/**
-	 * @dataProvider dataGetForObjectSince
-	 * @param $lastKnown
-	 * @param $order
-	 * @param $limit
-	 * @param $resultFrom
-	 * @param $resultTo
-	 */
-	public function testGetForObjectSince($lastKnown, $order, $limit, $resultFrom, $resultTo): void {
-		$ids = [];
-		$ids[] = $this->addDatabaseEntry(0, 0);
-		$ids[] = $this->addDatabaseEntry(0, 0);
-		$ids[] = $this->addDatabaseEntry(0, 0);
-		$ids[] = $this->addDatabaseEntry(0, 0);
-		$ids[] = $this->addDatabaseEntry(0, 0);
-
-		$manager = $this->getManager();
-		$comments = $manager->getForObjectSince('files', 'file64', ($lastKnown === null ? 0 : $ids[$lastKnown]), $order, $limit);
-
-		$expected = array_slice($ids, $resultFrom, $resultTo - $resultFrom + 1);
-		if ($order === 'desc') {
-			$expected = array_reverse($expected);
-		}
-
-		$this->assertSame($expected, array_map(function (IComment $c) {
-			return (int)$c->getId();
-		}, $comments));
-	}
-
-	public function dataGetForObjectSince() {
-		return [
-			[null, 'asc', 20, 0, 4],
-			[null, 'asc', 2, 0, 1],
-			[null, 'desc', 20, 0, 4],
-			[null, 'desc', 2, 3, 4],
-			[1, 'asc', 20, 2, 4],
-			[1, 'asc', 2, 2, 3],
-			[3, 'desc', 20, 0, 2],
-			[3, 'desc', 2, 1, 2],
-		];
-	}
-
-	public function invalidCreateArgsProvider() {
-		return [
-			['', 'aId-1', 'oType-1', 'oId-1'],
-			['aType-1', '', 'oType-1', 'oId-1'],
-			['aType-1', 'aId-1', '', 'oId-1'],
-			['aType-1', 'aId-1', 'oType-1', ''],
-			[1, 'aId-1', 'oType-1', 'oId-1'],
-			['aType-1', 1, 'oType-1', 'oId-1'],
-			['aType-1', 'aId-1', 1, 'oId-1'],
-			['aType-1', 'aId-1', 'oType-1', 1],
-		];
-	}
-
-	/**
-	 * @dataProvider invalidCreateArgsProvider
-	 * @param string $aType
-	 * @param string $aId
-	 * @param string $oType
-	 * @param string $oId
-	 */
-	public function testCreateCommentInvalidArguments($aType, $aId, $oType, $oId): void {
-		$this->expectException(\InvalidArgumentException::class);
-
-		$manager = $this->getManager();
-		$manager->create($aType, $aId, $oType, $oId);
-	}
-
-	public function testCreateComment(): void {
-		$actorType = 'bot';
-		$actorId = 'bob';
-		$objectType = 'weather';
-		$objectId = 'bielefeld';
-
-		$comment = $this->getManager()->create($actorType, $actorId, $objectType, $objectId);
-		$this->assertTrue($comment instanceof IComment);
-		$this->assertSame($comment->getActorType(), $actorType);
-		$this->assertSame($comment->getActorId(), $actorId);
-		$this->assertSame($comment->getObjectType(), $objectType);
-		$this->assertSame($comment->getObjectId(), $objectId);
-	}
-
-
-	public function testDelete(): void {
-		$this->expectException(\OCP\Comments\NotFoundException::class);
-
-		$manager = $this->getManager();
-
-		$done = $manager->delete('404');
-		$this->assertFalse($done);
-
-		$done = $manager->delete('%');
-		$this->assertFalse($done);
-
-		$done = $manager->delete('');
-		$this->assertFalse($done);
-
-		$id = strval($this->addDatabaseEntry(0, 0));
-		$comment = $manager->get($id);
-		$this->assertTrue($comment instanceof IComment);
-		$done = $manager->delete($id);
-		$this->assertTrue($done);
-		$manager->get($id);
-	}
-
-	/**
-	 * @dataProvider providerTestSave
-	 */
-	public function testSave(string $message, string $actorId, string $verb, ?string $parentId, ?string $id = ''): IComment {
-		$manager = $this->getManager();
-		$comment = new Comment();
-		$comment
-			->setId($id)
-			->setActor('users', $actorId)
-			->setObject('files', 'file64')
-			->setMessage($message)
-			->setVerb($verb);
-		if ($parentId) {
-			$comment->setParentId($parentId);
-		}
-
-		$saveSuccessful = $manager->save($comment);
-		$this->assertTrue($saveSuccessful, 'Comment saving was not successful');
-		$this->assertNotEquals('', $comment->getId(), 'Comment ID should not be empty');
-		$this->assertNotEquals('0', $comment->getId(), 'Comment ID should not be string \'0\'');
-		$this->assertNotNull($comment->getCreationDateTime(), 'Comment creation date should not be null');
-
-		$loadedComment = $manager->get($comment->getId());
-		$this->assertSame($comment->getMessage(), $loadedComment->getMessage(), 'Comment message should match');
-		$this->assertEquals($comment->getCreationDateTime()->getTimestamp(), $loadedComment->getCreationDateTime()->getTimestamp(), 'Comment creation date should match');
-		return $comment;
-	}
-
-	public function providerTestSave(): array {
-		return [
-			['very beautiful, I am impressed!', 'alice', 'comment', null]
-		];
-	}
-
-	public function testSaveUpdate(): void {
-		$manager = $this->getManager();
-		$comment = new Comment();
-		$comment
-			->setActor('users', 'alice')
-			->setObject('files', 'file64')
-			->setMessage('very beautiful, I am impressed!')
-			->setVerb('comment')
-			->setExpireDate(new \DateTime('+2 hours'));
-
-		$manager->save($comment);
-
-		$loadedComment = $manager->get($comment->getId());
-		// Compare current object with database values
-		$this->assertSame($comment->getMessage(), $loadedComment->getMessage());
-		$this->assertSame(
-			$comment->getExpireDate()->format('Y-m-d H:i:s'),
-			$loadedComment->getExpireDate()->format('Y-m-d H:i:s')
-		);
-
-		// Preserve the original comment to compare after update
-		$original = clone $comment;
-
-		// Update values
-		$comment->setMessage('very beautiful, I am really so much impressed!')
-			->setExpireDate(new \DateTime('+1 hours'));
-		$manager->save($comment);
-
-		$loadedComment = $manager->get($comment->getId());
-		// Compare current object with database values
-		$this->assertSame($comment->getMessage(), $loadedComment->getMessage());
-		$this->assertSame(
-			$comment->getExpireDate()->format('Y-m-d H:i:s'),
-			$loadedComment->getExpireDate()->format('Y-m-d H:i:s')
-		);
-
-		// Compare original object with database values
-		$this->assertNotSame($original->getMessage(), $loadedComment->getMessage());
-		$this->assertNotSame(
-			$original->getExpireDate()->format('Y-m-d H:i:s'),
-			$loadedComment->getExpireDate()->format('Y-m-d H:i:s')
-		);
-	}
-
-
-	public function testSaveUpdateException(): void {
-		$this->expectException(\OCP\Comments\NotFoundException::class);
-
-		$manager = $this->getManager();
-		$comment = new Comment();
-		$comment
-			->setActor('users', 'alice')
-			->setObject('files', 'file64')
-			->setMessage('very beautiful, I am impressed!')
-			->setVerb('comment');
-
-		$manager->save($comment);
-
-		$manager->delete($comment->getId());
-		$comment->setMessage('very beautiful, I am really so much impressed!');
-		$manager->save($comment);
-	}
-
-
-	public function testSaveIncomplete(): void {
-		$this->expectException(\UnexpectedValueException::class);
-
-		$manager = $this->getManager();
-		$comment = new Comment();
-		$comment->setMessage('from no one to nothing');
-		$manager->save($comment);
-	}
-
-	public function testSaveAsChild(): void {
-		$id = $this->addDatabaseEntry(0, 0);
-
-		$manager = $this->getManager();
-
-		for ($i = 0; $i < 3; $i++) {
-			$comment = new Comment();
-			$comment
-				->setActor('users', 'alice')
-				->setObject('files', 'file64')
-				->setParentId(strval($id))
-				->setMessage('full ack')
-				->setVerb('comment')
-				// setting the creation time avoids using sleep() while making sure to test with different timestamps
-				->setCreationDateTime(new \DateTime('+' . $i . ' minutes'));
-
-			$manager->save($comment);
-
-			$this->assertSame($comment->getTopmostParentId(), strval($id));
-			$parentComment = $manager->get(strval($id));
-			$this->assertSame($parentComment->getChildrenCount(), $i + 1);
-			$this->assertEquals($parentComment->getLatestChildDateTime()->getTimestamp(), $comment->getCreationDateTime()->getTimestamp());
-		}
-	}
-
-	public function invalidActorArgsProvider() {
-		return
-			[
-				['', ''],
-				[1, 'alice'],
-				['users', 1],
-			];
-	}
-
-	/**
-	 * @dataProvider invalidActorArgsProvider
-	 * @param string $type
-	 * @param string $id
-	 */
-	public function testDeleteReferencesOfActorInvalidInput($type, $id): void {
-		$this->expectException(\InvalidArgumentException::class);
-
-		$manager = $this->getManager();
-		$manager->deleteReferencesOfActor($type, $id);
-	}
-
-	public function testDeleteReferencesOfActor(): void {
-		$ids = [];
-		$ids[] = $this->addDatabaseEntry(0, 0);
-		$ids[] = $this->addDatabaseEntry(0, 0);
-		$ids[] = $this->addDatabaseEntry(0, 0);
-
-		$manager = $this->getManager();
-
-		// just to make sure they are really set, with correct actor data
-		$comment = $manager->get(strval($ids[1]));
-		$this->assertSame($comment->getActorType(), 'users');
-		$this->assertSame($comment->getActorId(), 'alice');
-
-		$wasSuccessful = $manager->deleteReferencesOfActor('users', 'alice');
-		$this->assertTrue($wasSuccessful);
-
-		foreach ($ids as $id) {
-			$comment = $manager->get(strval($id));
-			$this->assertSame($comment->getActorType(), ICommentsManager::DELETED_USER);
-			$this->assertSame($comment->getActorId(), ICommentsManager::DELETED_USER);
-		}
-
-		// actor info is gone from DB, but when database interaction is alright,
-		// we still expect to get true back
-		$wasSuccessful = $manager->deleteReferencesOfActor('users', 'alice');
-		$this->assertTrue($wasSuccessful);
-	}
-
-	public function testDeleteReferencesOfActorWithUserManagement(): void {
-		$user = \OC::$server->getUserManager()->createUser('xenia', 'NotAnEasyPassword123456+');
-		$this->assertTrue($user instanceof IUser);
-
-		$manager = \OC::$server->get(ICommentsManager::class);
-		$comment = $manager->create('users', $user->getUID(), 'files', 'file64');
-		$comment
-			->setMessage('Most important comment I ever left on the Internet.')
-			->setVerb('comment');
-		$status = $manager->save($comment);
-		$this->assertTrue($status);
-
-		$commentID = $comment->getId();
-		$user->delete();
-
-		$comment = $manager->get($commentID);
-		$this->assertSame($comment->getActorType(), ICommentsManager::DELETED_USER);
-		$this->assertSame($comment->getActorId(), ICommentsManager::DELETED_USER);
-	}
-
-	public function invalidObjectArgsProvider() {
-		return
-			[
-				['', ''],
-				[1, 'file64'],
-				['files', 1],
-			];
-	}
-
-	/**
-	 * @dataProvider invalidObjectArgsProvider
-	 * @param string $type
-	 * @param string $id
-	 */
-	public function testDeleteCommentsAtObjectInvalidInput($type, $id): void {
-		$this->expectException(\InvalidArgumentException::class);
-
-		$manager = $this->getManager();
-		$manager->deleteCommentsAtObject($type, $id);
-	}
-
-	public function testDeleteCommentsAtObject(): void {
-		$ids = [];
-		$ids[] = $this->addDatabaseEntry(0, 0);
-		$ids[] = $this->addDatabaseEntry(0, 0);
-		$ids[] = $this->addDatabaseEntry(0, 0);
-
-		$manager = $this->getManager();
-
-		// just to make sure they are really set, with correct actor data
-		$comment = $manager->get(strval($ids[1]));
-		$this->assertSame($comment->getObjectType(), 'files');
-		$this->assertSame($comment->getObjectId(), 'file64');
-
-		$wasSuccessful = $manager->deleteCommentsAtObject('files', 'file64');
-		$this->assertTrue($wasSuccessful);
-
-		$verified = 0;
-		foreach ($ids as $id) {
-			try {
-				$manager->get(strval($id));
-			} catch (NotFoundException $e) {
-				$verified++;
-			}
-		}
-		$this->assertSame($verified, 3);
-
-		// actor info is gone from DB, but when database interaction is alright,
-		// we still expect to get true back
-		$wasSuccessful = $manager->deleteCommentsAtObject('files', 'file64');
-		$this->assertTrue($wasSuccessful);
-	}
-
-	public function testDeleteCommentsExpiredAtObjectTypeAndId(): void {
-		$ids = [];
-		$ids[] = $this->addDatabaseEntry(0, 0, null, null, null, new \DateTime('+2 hours'));
-		$ids[] = $this->addDatabaseEntry(0, 0, null, null, null, new \DateTime('+2 hours'));
-		$ids[] = $this->addDatabaseEntry(0, 0, null, null, null, new \DateTime('+2 hours'));
-		$ids[] = $this->addDatabaseEntry(0, 0, null, null, null, new \DateTime('-2 hours'));
-		$ids[] = $this->addDatabaseEntry(0, 0, null, null, null, new \DateTime('-2 hours'));
-		$ids[] = $this->addDatabaseEntry(0, 0, null, null, null, new \DateTime('-2 hours'));
-
-		$manager = new Manager(
-			$this->connection,
-			$this->createMock(LoggerInterface::class),
-			$this->createMock(IConfig::class),
-			Server::get(ITimeFactory::class),
-			new EmojiHelper($this->connection),
-			$this->createMock(IInitialStateService::class),
-			$this->rootFolder,
-			$this->createMock(IEventDispatcher::class)
-		);
-
-		// just to make sure they are really set, with correct actor data
-		$comment = $manager->get((string)$ids[1]);
-		$this->assertSame($comment->getObjectType(), 'files');
-		$this->assertSame($comment->getObjectId(), 'file64');
-
-		$deleted = $manager->deleteCommentsExpiredAtObject('files', 'file64');
-		$this->assertTrue($deleted);
-
-		$deleted = 0;
-		$exists = 0;
-		foreach ($ids as $id) {
-			try {
-				$manager->get((string)$id);
-				$exists++;
-			} catch (NotFoundException $e) {
-				$deleted++;
-			}
-		}
-		$this->assertSame($exists, 3);
-		$this->assertSame($deleted, 3);
-
-		// actor info is gone from DB, but when database interaction is alright,
-		// we still expect to get true back
-		$deleted = $manager->deleteCommentsExpiredAtObject('files', 'file64');
-		$this->assertFalse($deleted);
-	}
-
-	public function testDeleteCommentsExpiredAtObjectType(): void {
-		$ids = [];
-		$ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file1', new \DateTime('-2 hours'));
-		$ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file2', new \DateTime('-2 hours'));
-		$ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file3', new \DateTime('-2 hours'));
-		$ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file3', new \DateTime());
-		$ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file3', new \DateTime());
-		$ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file3', new \DateTime());
-
-		$manager = new Manager(
-			$this->connection,
-			$this->createMock(LoggerInterface::class),
-			$this->createMock(IConfig::class),
-			Server::get(ITimeFactory::class),
-			new EmojiHelper($this->connection),
-			$this->createMock(IInitialStateService::class),
-			$this->rootFolder,
-			$this->createMock(IEventDispatcher::class)
-		);
-
-		$deleted = $manager->deleteCommentsExpiredAtObject('files');
-		$this->assertTrue($deleted);
-
-		$deleted = 0;
-		$exists = 0;
-		foreach ($ids as $id) {
-			try {
-				$manager->get((string)$id);
-				$exists++;
-			} catch (NotFoundException $e) {
-				$deleted++;
-			}
-		}
-		$this->assertSame($exists, 0);
-		$this->assertSame($deleted, 6);
-
-		// actor info is gone from DB, but when database interaction is alright,
-		// we still expect to get true back
-		$deleted = $manager->deleteCommentsExpiredAtObject('files');
-		$this->assertFalse($deleted);
-	}
-
-	public function testSetMarkRead(): void {
-		/** @var IUser|\PHPUnit\Framework\MockObject\MockObject $user */
-		$user = $this->createMock(IUser::class);
-		$user->expects($this->any())
-			->method('getUID')
-			->willReturn('alice');
-
-		$dateTimeSet = new \DateTime();
-
-		$manager = $this->getManager();
-		$manager->setReadMark('robot', '36', $dateTimeSet, $user);
-
-		$dateTimeGet = $manager->getReadMark('robot', '36', $user);
-
-		$this->assertEquals($dateTimeGet->getTimestamp(), $dateTimeSet->getTimestamp());
-	}
-
-	public function testSetMarkReadUpdate(): void {
-		/** @var IUser|\PHPUnit\Framework\MockObject\MockObject $user */
-		$user = $this->createMock(IUser::class);
-		$user->expects($this->any())
-			->method('getUID')
-			->willReturn('alice');
-
-		$dateTimeSet = new \DateTime('yesterday');
-
-		$manager = $this->getManager();
-		$manager->setReadMark('robot', '36', $dateTimeSet, $user);
-
-		$dateTimeSet = new \DateTime('today');
-		$manager->setReadMark('robot', '36', $dateTimeSet, $user);
-
-		$dateTimeGet = $manager->getReadMark('robot', '36', $user);
-
-		$this->assertEquals($dateTimeGet, $dateTimeSet);
-	}
-
-	public function testReadMarkDeleteUser(): void {
-		/** @var IUser|\PHPUnit\Framework\MockObject\MockObject $user */
-		$user = $this->createMock(IUser::class);
-		$user->expects($this->any())
-			->method('getUID')
-			->willReturn('alice');
-
-		$dateTimeSet = new \DateTime();
-
-		$manager = $this->getManager();
-		$manager->setReadMark('robot', '36', $dateTimeSet, $user);
-
-		$manager->deleteReadMarksFromUser($user);
-		$dateTimeGet = $manager->getReadMark('robot', '36', $user);
-
-		$this->assertNull($dateTimeGet);
-	}
-
-	public function testReadMarkDeleteObject(): void {
-		/** @var IUser|\PHPUnit\Framework\MockObject\MockObject $user */
-		$user = $this->createMock(IUser::class);
-		$user->expects($this->any())
-			->method('getUID')
-			->willReturn('alice');
+    /** @var IDBConnection */
+    private $connection;
+    /** @var \PHPUnit\Framework\MockObject\MockObject|IRootFolder */
+    private $rootFolder;
+
+    protected function setUp(): void {
+        parent::setUp();
+
+        $this->connection = \OC::$server->getDatabaseConnection();
+        $this->rootFolder = $this->createMock(IRootFolder::class);
+
+        $sql = $this->connection->getDatabasePlatform()->getTruncateTableSQL('`*PREFIX*comments`');
+        $this->connection->prepare($sql)->execute();
+        $sql = $this->connection->getDatabasePlatform()->getTruncateTableSQL('`*PREFIX*reactions`');
+        $this->connection->prepare($sql)->execute();
+    }
+
+    protected function addDatabaseEntry($parentId, $topmostParentId, $creationDT = null, $latestChildDT = null, $objectId = null, $expireDate = null) {
+        if (is_null($creationDT)) {
+            $creationDT = new \DateTime();
+        }
+        if (is_null($latestChildDT)) {
+            $latestChildDT = new \DateTime('yesterday');
+        }
+        if (is_null($objectId)) {
+            $objectId = 'file64';
+        }
+
+        $qb = $this->connection->getQueryBuilder();
+        $qb
+            ->insert('comments')
+            ->values([
+                'parent_id' => $qb->createNamedParameter($parentId),
+                'topmost_parent_id' => $qb->createNamedParameter($topmostParentId),
+                'children_count' => $qb->createNamedParameter(2),
+                'actor_type' => $qb->createNamedParameter('users'),
+                'actor_id' => $qb->createNamedParameter('alice'),
+                'message' => $qb->createNamedParameter('nice one'),
+                'verb' => $qb->createNamedParameter('comment'),
+                'creation_timestamp' => $qb->createNamedParameter($creationDT, IQueryBuilder::PARAM_DATETIME_MUTABLE),
+                'latest_child_timestamp' => $qb->createNamedParameter($latestChildDT, IQueryBuilder::PARAM_DATETIME_MUTABLE),
+                'object_type' => $qb->createNamedParameter('files'),
+                'object_id' => $qb->createNamedParameter($objectId),
+                'expire_date' => $qb->createNamedParameter($expireDate, IQueryBuilder::PARAM_DATETIME_MUTABLE),
+                'reference_id' => $qb->createNamedParameter('referenceId'),
+                'meta_data' => $qb->createNamedParameter(json_encode(['last_edit_actor_id' => 'admin'])),
+            ])
+            ->execute();
+
+        return $qb->getLastInsertId();
+    }
+
+    protected function getManager() {
+        return new Manager(
+            $this->connection,
+            $this->createMock(LoggerInterface::class),
+            $this->createMock(IConfig::class),
+            $this->createMock(ITimeFactory::class),
+            new EmojiHelper($this->connection),
+            $this->createMock(IInitialStateService::class),
+            $this->rootFolder,
+            $this->createMock(IEventDispatcher::class),
+        );
+    }
+
+
+    public function testGetCommentNotFound(): void {
+        $this->expectException(\OCP\Comments\NotFoundException::class);
+
+        $manager = $this->getManager();
+        $manager->get('22');
+    }
+
+
+    public function testGetCommentNotFoundInvalidInput(): void {
+        $this->expectException(\InvalidArgumentException::class);
+
+        $manager = $this->getManager();
+        $manager->get('unexisting22');
+    }
+
+    public function testGetComment(): void {
+        $manager = $this->getManager();
+
+        $creationDT = new \DateTime();
+        $latestChildDT = new \DateTime('yesterday');
+
+        $qb = \OC::$server->getDatabaseConnection()->getQueryBuilder();
+        $qb
+            ->insert('comments')
+            ->values([
+                'parent_id' => $qb->createNamedParameter('2'),
+                'topmost_parent_id' => $qb->createNamedParameter('1'),
+                'children_count' => $qb->createNamedParameter(2),
+                'actor_type' => $qb->createNamedParameter('users'),
+                'actor_id' => $qb->createNamedParameter('alice'),
+                'message' => $qb->createNamedParameter('nice one'),
+                'verb' => $qb->createNamedParameter('comment'),
+                'creation_timestamp' => $qb->createNamedParameter($creationDT, 'datetime'),
+                'latest_child_timestamp' => $qb->createNamedParameter($latestChildDT, 'datetime'),
+                'object_type' => $qb->createNamedParameter('files'),
+                'object_id' => $qb->createNamedParameter('file64'),
+                'reference_id' => $qb->createNamedParameter('referenceId'),
+                'meta_data' => $qb->createNamedParameter(json_encode(['last_edit_actor_id' => 'admin'])),
+            ])
+            ->execute();
+
+        $id = strval($qb->getLastInsertId());
+
+        $comment = $manager->get($id);
+        $this->assertTrue($comment instanceof IComment);
+        $this->assertSame($comment->getId(), $id);
+        $this->assertSame($comment->getParentId(), '2');
+        $this->assertSame($comment->getTopmostParentId(), '1');
+        $this->assertSame($comment->getChildrenCount(), 2);
+        $this->assertSame($comment->getActorType(), 'users');
+        $this->assertSame($comment->getActorId(), 'alice');
+        $this->assertSame($comment->getMessage(), 'nice one');
+        $this->assertSame($comment->getVerb(), 'comment');
+        $this->assertSame($comment->getObjectType(), 'files');
+        $this->assertSame($comment->getObjectId(), 'file64');
+        $this->assertEquals($comment->getCreationDateTime()->getTimestamp(), $creationDT->getTimestamp());
+        $this->assertEquals($comment->getLatestChildDateTime(), $latestChildDT);
+        $this->assertEquals($comment->getReferenceId(), 'referenceId');
+        $this->assertEquals($comment->getMetaData(), ['last_edit_actor_id' => 'admin']);
+    }
+
+
+    public function testGetTreeNotFound(): void {
+        $this->expectException(\OCP\Comments\NotFoundException::class);
+
+        $manager = $this->getManager();
+        $manager->getTree('22');
+    }
+
+
+    public function testGetTreeNotFoundInvalidIpnut(): void {
+        $this->expectException(\InvalidArgumentException::class);
+
+        $manager = $this->getManager();
+        $manager->getTree('unexisting22');
+    }
+
+    public function testGetTree(): void {
+        $headId = $this->addDatabaseEntry(0, 0);
+
+        $this->addDatabaseEntry($headId, $headId, new \DateTime('-3 hours'));
+        $this->addDatabaseEntry($headId, $headId, new \DateTime('-2 hours'));
+        $id = $this->addDatabaseEntry($headId, $headId, new \DateTime('-1 hour'));
+
+        $manager = $this->getManager();
+        $tree = $manager->getTree($headId);
+
+        // Verifying the root comment
+        $this->assertTrue(isset($tree['comment']));
+        $this->assertTrue($tree['comment'] instanceof IComment);
+        $this->assertSame($tree['comment']->getId(), strval($headId));
+        $this->assertTrue(isset($tree['replies']));
+        $this->assertSame(count($tree['replies']), 3);
+
+        // one level deep
+        foreach ($tree['replies'] as $reply) {
+            $this->assertTrue($reply['comment'] instanceof IComment);
+            $this->assertSame($reply['comment']->getId(), strval($id));
+            $this->assertSame(count($reply['replies']), 0);
+            $id--;
+        }
+    }
+
+    public function testGetTreeNoReplies(): void {
+        $id = $this->addDatabaseEntry(0, 0);
+
+        $manager = $this->getManager();
+        $tree = $manager->getTree($id);
+
+        // Verifying the root comment
+        $this->assertTrue(isset($tree['comment']));
+        $this->assertTrue($tree['comment'] instanceof IComment);
+        $this->assertSame($tree['comment']->getId(), strval($id));
+        $this->assertTrue(isset($tree['replies']));
+        $this->assertSame(count($tree['replies']), 0);
+
+        // one level deep
+        foreach ($tree['replies'] as $reply) {
+            throw new \Exception('This ain`t happen');
+        }
+    }
+
+    public function testGetTreeWithLimitAndOffset(): void {
+        $headId = $this->addDatabaseEntry(0, 0);
+
+        $this->addDatabaseEntry($headId, $headId, new \DateTime('-3 hours'));
+        $this->addDatabaseEntry($headId, $headId, new \DateTime('-2 hours'));
+        $this->addDatabaseEntry($headId, $headId, new \DateTime('-1 hour'));
+        $idToVerify = $this->addDatabaseEntry($headId, $headId, new \DateTime());
+
+        $manager = $this->getManager();
+
+        for ($offset = 0; $offset < 3; $offset += 2) {
+            $tree = $manager->getTree(strval($headId), 2, $offset);
+
+            // Verifying the root comment
+            $this->assertTrue(isset($tree['comment']));
+            $this->assertTrue($tree['comment'] instanceof IComment);
+            $this->assertSame($tree['comment']->getId(), strval($headId));
+            $this->assertTrue(isset($tree['replies']));
+            $this->assertSame(count($tree['replies']), 2);
+
+            // one level deep
+            foreach ($tree['replies'] as $reply) {
+                $this->assertTrue($reply['comment'] instanceof IComment);
+                $this->assertSame($reply['comment']->getId(), strval($idToVerify));
+                $this->assertSame(count($reply['replies']), 0);
+                $idToVerify--;
+            }
+        }
+    }
+
+    public function testGetForObject(): void {
+        $this->addDatabaseEntry(0, 0);
+
+        $manager = $this->getManager();
+        $comments = $manager->getForObject('files', 'file64');
+
+        $this->assertTrue(is_array($comments));
+        $this->assertSame(count($comments), 1);
+        $this->assertTrue($comments[0] instanceof IComment);
+        $this->assertSame($comments[0]->getMessage(), 'nice one');
+    }
+
+    public function testGetForObjectWithLimitAndOffset(): void {
+        $this->addDatabaseEntry(0, 0, new \DateTime('-6 hours'));
+        $this->addDatabaseEntry(0, 0, new \DateTime('-5 hours'));
+        $this->addDatabaseEntry(1, 1, new \DateTime('-4 hours'));
+        $this->addDatabaseEntry(0, 0, new \DateTime('-3 hours'));
+        $this->addDatabaseEntry(2, 2, new \DateTime('-2 hours'));
+        $this->addDatabaseEntry(2, 2, new \DateTime('-1 hours'));
+        $idToVerify = $this->addDatabaseEntry(3, 1, new \DateTime());
+
+        $manager = $this->getManager();
+        $offset = 0;
+        do {
+            $comments = $manager->getForObject('files', 'file64', 3, $offset);
+
+            $this->assertTrue(is_array($comments));
+            foreach ($comments as $comment) {
+                $this->assertTrue($comment instanceof IComment);
+                $this->assertSame($comment->getMessage(), 'nice one');
+                $this->assertSame($comment->getId(), strval($idToVerify));
+                $idToVerify--;
+            }
+            $offset += 3;
+        } while (count($comments) > 0);
+    }
+
+    public function testGetForObjectWithDateTimeConstraint(): void {
+        $this->addDatabaseEntry(0, 0, new \DateTime('-6 hours'));
+        $this->addDatabaseEntry(0, 0, new \DateTime('-5 hours'));
+        $id1 = $this->addDatabaseEntry(0, 0, new \DateTime('-3 hours'));
+        $id2 = $this->addDatabaseEntry(2, 2, new \DateTime('-2 hours'));
+
+        $manager = $this->getManager();
+        $comments = $manager->getForObject('files', 'file64', 0, 0, new \DateTime('-4 hours'));
+
+        $this->assertSame(count($comments), 2);
+        $this->assertSame($comments[0]->getId(), strval($id2));
+        $this->assertSame($comments[1]->getId(), strval($id1));
+    }
+
+    public function testGetForObjectWithLimitAndOffsetAndDateTimeConstraint(): void {
+        $this->addDatabaseEntry(0, 0, new \DateTime('-7 hours'));
+        $this->addDatabaseEntry(0, 0, new \DateTime('-6 hours'));
+        $this->addDatabaseEntry(1, 1, new \DateTime('-5 hours'));
+        $this->addDatabaseEntry(0, 0, new \DateTime('-3 hours'));
+        $this->addDatabaseEntry(2, 2, new \DateTime('-2 hours'));
+        $this->addDatabaseEntry(2, 2, new \DateTime('-1 hours'));
+        $idToVerify = $this->addDatabaseEntry(3, 1, new \DateTime());
+
+        $manager = $this->getManager();
+        $offset = 0;
+        do {
+            $comments = $manager->getForObject('files', 'file64', 3, $offset, new \DateTime('-4 hours'));
+
+            $this->assertTrue(is_array($comments));
+            foreach ($comments as $comment) {
+                $this->assertTrue($comment instanceof IComment);
+                $this->assertSame($comment->getMessage(), 'nice one');
+                $this->assertSame($comment->getId(), strval($idToVerify));
+                $this->assertTrue(intval($comment->getId()) >= 4);
+                $idToVerify--;
+            }
+            $offset += 3;
+        } while (count($comments) > 0);
+    }
+
+    public function testGetNumberOfCommentsForObject(): void {
+        for ($i = 1; $i < 5; $i++) {
+            $this->addDatabaseEntry(0, 0);
+        }
+
+        $manager = $this->getManager();
+
+        $amount = $manager->getNumberOfCommentsForObject('untype', '00');
+        $this->assertSame($amount, 0);
+
+        $amount = $manager->getNumberOfCommentsForObject('files', 'file64');
+        $this->assertSame($amount, 4);
+    }
+
+    public function testGetNumberOfUnreadCommentsForFolder(): void {
+        $folder = $this->createMock(Folder::class);
+        $fileIds = range(1111, 1114);
+        $children = array_map(function (int $id) {
+            $file = $this->createMock(Folder::class);
+            $file->method('getId')
+                ->willReturn($id);
+            return $file;
+        }, $fileIds);
+        $folder->method('getId')->willReturn(1000);
+        $folder->method('getDirectoryListing')->willReturn($children);
+        $this->rootFolder->method('getFirstNodeById')
+            ->with($folder->getId())
+            ->willReturn($folder);
+
+        // 2 comment for 1111 with 1 before read marker
+        // 2 comments for 1112 with no read marker
+        // 1 comment for 1113 before read marker
+        // 1 comment for 1114 with no read marker
+        $this->addDatabaseEntry(0, 0, null, null, $fileIds[1]);
+        for ($i = 0; $i < 4; $i++) {
+            $this->addDatabaseEntry(0, 0, null, null, $fileIds[$i]);
+        }
+        $this->addDatabaseEntry(0, 0, (new \DateTime())->modify('-2 days'), null, $fileIds[0]);
+        /** @var IUser|\PHPUnit\Framework\MockObject\MockObject $user */
+        $user = $this->createMock(IUser::class);
+        $user->expects($this->any())
+            ->method('getUID')
+            ->willReturn('comment_test');
+
+        $manager = $this->getManager();
+
+        $manager->setReadMark('files', (string)$fileIds[0], (new \DateTime())->modify('-1 days'), $user);
+        $manager->setReadMark('files', (string)$fileIds[2], (new \DateTime()), $user);
+
+        $amount = $manager->getNumberOfUnreadCommentsForFolder($folder->getId(), $user);
+        $this->assertEquals([
+            $fileIds[0] => 1,
+            $fileIds[1] => 2,
+            $fileIds[3] => 1,
+        ], $amount);
+    }
+
+    /**
+     * @dataProvider dataGetForObjectSince
+     * @param $lastKnown
+     * @param $order
+     * @param $limit
+     * @param $resultFrom
+     * @param $resultTo
+     */
+    public function testGetForObjectSince($lastKnown, $order, $limit, $resultFrom, $resultTo): void {
+        $ids = [];
+        $ids[] = $this->addDatabaseEntry(0, 0);
+        $ids[] = $this->addDatabaseEntry(0, 0);
+        $ids[] = $this->addDatabaseEntry(0, 0);
+        $ids[] = $this->addDatabaseEntry(0, 0);
+        $ids[] = $this->addDatabaseEntry(0, 0);
+
+        $manager = $this->getManager();
+        $comments = $manager->getForObjectSince('files', 'file64', ($lastKnown === null ? 0 : $ids[$lastKnown]), $order, $limit);
+
+        $expected = array_slice($ids, $resultFrom, $resultTo - $resultFrom + 1);
+        if ($order === 'desc') {
+            $expected = array_reverse($expected);
+        }
+
+        $this->assertSame($expected, array_map(function (IComment $c) {
+            return (int)$c->getId();
+        }, $comments));
+    }
+
+    public function dataGetForObjectSince() {
+        return [
+            [null, 'asc', 20, 0, 4],
+            [null, 'asc', 2, 0, 1],
+            [null, 'desc', 20, 0, 4],
+            [null, 'desc', 2, 3, 4],
+            [1, 'asc', 20, 2, 4],
+            [1, 'asc', 2, 2, 3],
+            [3, 'desc', 20, 0, 2],
+            [3, 'desc', 2, 1, 2],
+        ];
+    }
+
+    public function invalidCreateArgsProvider() {
+        return [
+            ['', 'aId-1', 'oType-1', 'oId-1'],
+            ['aType-1', '', 'oType-1', 'oId-1'],
+            ['aType-1', 'aId-1', '', 'oId-1'],
+            ['aType-1', 'aId-1', 'oType-1', ''],
+            [1, 'aId-1', 'oType-1', 'oId-1'],
+            ['aType-1', 1, 'oType-1', 'oId-1'],
+            ['aType-1', 'aId-1', 1, 'oId-1'],
+            ['aType-1', 'aId-1', 'oType-1', 1],
+        ];
+    }
+
+    /**
+     * @dataProvider invalidCreateArgsProvider
+     * @param string $aType
+     * @param string $aId
+     * @param string $oType
+     * @param string $oId
+     */
+    public function testCreateCommentInvalidArguments($aType, $aId, $oType, $oId): void {
+        $this->expectException(\InvalidArgumentException::class);
+
+        $manager = $this->getManager();
+        $manager->create($aType, $aId, $oType, $oId);
+    }
+
+    public function testCreateComment(): void {
+        $actorType = 'bot';
+        $actorId = 'bob';
+        $objectType = 'weather';
+        $objectId = 'bielefeld';
+
+        $comment = $this->getManager()->create($actorType, $actorId, $objectType, $objectId);
+        $this->assertTrue($comment instanceof IComment);
+        $this->assertSame($comment->getActorType(), $actorType);
+        $this->assertSame($comment->getActorId(), $actorId);
+        $this->assertSame($comment->getObjectType(), $objectType);
+        $this->assertSame($comment->getObjectId(), $objectId);
+    }
+
+
+    public function testDelete(): void {
+        $this->expectException(\OCP\Comments\NotFoundException::class);
+
+        $manager = $this->getManager();
+
+        $done = $manager->delete('404');
+        $this->assertFalse($done);
+
+        $done = $manager->delete('%');
+        $this->assertFalse($done);
+
+        $done = $manager->delete('');
+        $this->assertFalse($done);
+
+        $id = strval($this->addDatabaseEntry(0, 0));
+        $comment = $manager->get($id);
+        $this->assertTrue($comment instanceof IComment);
+        $done = $manager->delete($id);
+        $this->assertTrue($done);
+        $manager->get($id);
+    }
+
+    /**
+     * @dataProvider providerTestSave
+     */
+    public function testSave(string $message, string $actorId, string $verb, ?string $parentId, ?string $id = ''): IComment {
+        $manager = $this->getManager();
+        $comment = new Comment();
+        $comment
+            ->setId($id)
+            ->setActor('users', $actorId)
+            ->setObject('files', 'file64')
+            ->setMessage($message)
+            ->setVerb($verb);
+        if ($parentId) {
+            $comment->setParentId($parentId);
+        }
+
+        $saveSuccessful = $manager->save($comment);
+        $this->assertTrue($saveSuccessful, 'Comment saving was not successful');
+        $this->assertNotEquals('', $comment->getId(), 'Comment ID should not be empty');
+        $this->assertNotEquals('0', $comment->getId(), 'Comment ID should not be string \'0\'');
+        $this->assertNotNull($comment->getCreationDateTime(), 'Comment creation date should not be null');
+
+        $loadedComment = $manager->get($comment->getId());
+        $this->assertSame($comment->getMessage(), $loadedComment->getMessage(), 'Comment message should match');
+        $this->assertEquals($comment->getCreationDateTime()->getTimestamp(), $loadedComment->getCreationDateTime()->getTimestamp(), 'Comment creation date should match');
+        return $comment;
+    }
+
+    public function providerTestSave(): array {
+        return [
+            ['very beautiful, I am impressed!', 'alice', 'comment', null]
+        ];
+    }
+
+    public function testSaveUpdate(): void {
+        $manager = $this->getManager();
+        $comment = new Comment();
+        $comment
+            ->setActor('users', 'alice')
+            ->setObject('files', 'file64')
+            ->setMessage('very beautiful, I am impressed!')
+            ->setVerb('comment')
+            ->setExpireDate(new \DateTime('+2 hours'));
+
+        $manager->save($comment);
+
+        $loadedComment = $manager->get($comment->getId());
+        // Compare current object with database values
+        $this->assertSame($comment->getMessage(), $loadedComment->getMessage());
+        $this->assertSame(
+            $comment->getExpireDate()->format('Y-m-d H:i:s'),
+            $loadedComment->getExpireDate()->format('Y-m-d H:i:s')
+        );
+
+        // Preserve the original comment to compare after update
+        $original = clone $comment;
+
+        // Update values
+        $comment->setMessage('very beautiful, I am really so much impressed!')
+            ->setExpireDate(new \DateTime('+1 hours'));
+        $manager->save($comment);
+
+        $loadedComment = $manager->get($comment->getId());
+        // Compare current object with database values
+        $this->assertSame($comment->getMessage(), $loadedComment->getMessage());
+        $this->assertSame(
+            $comment->getExpireDate()->format('Y-m-d H:i:s'),
+            $loadedComment->getExpireDate()->format('Y-m-d H:i:s')
+        );
+
+        // Compare original object with database values
+        $this->assertNotSame($original->getMessage(), $loadedComment->getMessage());
+        $this->assertNotSame(
+            $original->getExpireDate()->format('Y-m-d H:i:s'),
+            $loadedComment->getExpireDate()->format('Y-m-d H:i:s')
+        );
+    }
+
+
+    public function testSaveUpdateException(): void {
+        $this->expectException(\OCP\Comments\NotFoundException::class);
+
+        $manager = $this->getManager();
+        $comment = new Comment();
+        $comment
+            ->setActor('users', 'alice')
+            ->setObject('files', 'file64')
+            ->setMessage('very beautiful, I am impressed!')
+            ->setVerb('comment');
+
+        $manager->save($comment);
+
+        $manager->delete($comment->getId());
+        $comment->setMessage('very beautiful, I am really so much impressed!');
+        $manager->save($comment);
+    }
+
+
+    public function testSaveIncomplete(): void {
+        $this->expectException(\UnexpectedValueException::class);
+
+        $manager = $this->getManager();
+        $comment = new Comment();
+        $comment->setMessage('from no one to nothing');
+        $manager->save($comment);
+    }
+
+    public function testSaveAsChild(): void {
+        $id = $this->addDatabaseEntry(0, 0);
+
+        $manager = $this->getManager();
+
+        for ($i = 0; $i < 3; $i++) {
+            $comment = new Comment();
+            $comment
+                ->setActor('users', 'alice')
+                ->setObject('files', 'file64')
+                ->setParentId(strval($id))
+                ->setMessage('full ack')
+                ->setVerb('comment')
+                // setting the creation time avoids using sleep() while making sure to test with different timestamps
+                ->setCreationDateTime(new \DateTime('+' . $i . ' minutes'));
+
+            $manager->save($comment);
+
+            $this->assertSame($comment->getTopmostParentId(), strval($id));
+            $parentComment = $manager->get(strval($id));
+            $this->assertSame($parentComment->getChildrenCount(), $i + 1);
+            $this->assertEquals($parentComment->getLatestChildDateTime()->getTimestamp(), $comment->getCreationDateTime()->getTimestamp());
+        }
+    }
+
+    public function invalidActorArgsProvider() {
+        return
+            [
+                ['', ''],
+                [1, 'alice'],
+                ['users', 1],
+            ];
+    }
+
+    /**
+     * @dataProvider invalidActorArgsProvider
+     * @param string $type
+     * @param string $id
+     */
+    public function testDeleteReferencesOfActorInvalidInput($type, $id): void {
+        $this->expectException(\InvalidArgumentException::class);
+
+        $manager = $this->getManager();
+        $manager->deleteReferencesOfActor($type, $id);
+    }
+
+    public function testDeleteReferencesOfActor(): void {
+        $ids = [];
+        $ids[] = $this->addDatabaseEntry(0, 0);
+        $ids[] = $this->addDatabaseEntry(0, 0);
+        $ids[] = $this->addDatabaseEntry(0, 0);
+
+        $manager = $this->getManager();
+
+        // just to make sure they are really set, with correct actor data
+        $comment = $manager->get(strval($ids[1]));
+        $this->assertSame($comment->getActorType(), 'users');
+        $this->assertSame($comment->getActorId(), 'alice');
+
+        $wasSuccessful = $manager->deleteReferencesOfActor('users', 'alice');
+        $this->assertTrue($wasSuccessful);
+
+        foreach ($ids as $id) {
+            $comment = $manager->get(strval($id));
+            $this->assertSame($comment->getActorType(), ICommentsManager::DELETED_USER);
+            $this->assertSame($comment->getActorId(), ICommentsManager::DELETED_USER);
+        }
+
+        // actor info is gone from DB, but when database interaction is alright,
+        // we still expect to get true back
+        $wasSuccessful = $manager->deleteReferencesOfActor('users', 'alice');
+        $this->assertTrue($wasSuccessful);
+    }
+
+    public function testDeleteReferencesOfActorWithUserManagement(): void {
+        $user = \OC::$server->getUserManager()->createUser('xenia', 'NotAnEasyPassword123456+');
+        $this->assertTrue($user instanceof IUser);
+
+        $manager = \OC::$server->get(ICommentsManager::class);
+        $comment = $manager->create('users', $user->getUID(), 'files', 'file64');
+        $comment
+            ->setMessage('Most important comment I ever left on the Internet.')
+            ->setVerb('comment');
+        $status = $manager->save($comment);
+        $this->assertTrue($status);
+
+        $commentID = $comment->getId();
+        $user->delete();
+
+        $comment = $manager->get($commentID);
+        $this->assertSame($comment->getActorType(), ICommentsManager::DELETED_USER);
+        $this->assertSame($comment->getActorId(), ICommentsManager::DELETED_USER);
+    }
+
+    public function invalidObjectArgsProvider() {
+        return
+            [
+                ['', ''],
+                [1, 'file64'],
+                ['files', 1],
+            ];
+    }
+
+    /**
+     * @dataProvider invalidObjectArgsProvider
+     * @param string $type
+     * @param string $id
+     */
+    public function testDeleteCommentsAtObjectInvalidInput($type, $id): void {
+        $this->expectException(\InvalidArgumentException::class);
+
+        $manager = $this->getManager();
+        $manager->deleteCommentsAtObject($type, $id);
+    }
+
+    public function testDeleteCommentsAtObject(): void {
+        $ids = [];
+        $ids[] = $this->addDatabaseEntry(0, 0);
+        $ids[] = $this->addDatabaseEntry(0, 0);
+        $ids[] = $this->addDatabaseEntry(0, 0);
+
+        $manager = $this->getManager();
+
+        // just to make sure they are really set, with correct actor data
+        $comment = $manager->get(strval($ids[1]));
+        $this->assertSame($comment->getObjectType(), 'files');
+        $this->assertSame($comment->getObjectId(), 'file64');
+
+        $wasSuccessful = $manager->deleteCommentsAtObject('files', 'file64');
+        $this->assertTrue($wasSuccessful);
+
+        $verified = 0;
+        foreach ($ids as $id) {
+            try {
+                $manager->get(strval($id));
+            } catch (NotFoundException $e) {
+                $verified++;
+            }
+        }
+        $this->assertSame($verified, 3);
+
+        // actor info is gone from DB, but when database interaction is alright,
+        // we still expect to get true back
+        $wasSuccessful = $manager->deleteCommentsAtObject('files', 'file64');
+        $this->assertTrue($wasSuccessful);
+    }
+
+    public function testDeleteCommentsExpiredAtObjectTypeAndId(): void {
+        $ids = [];
+        $ids[] = $this->addDatabaseEntry(0, 0, null, null, null, new \DateTime('+2 hours'));
+        $ids[] = $this->addDatabaseEntry(0, 0, null, null, null, new \DateTime('+2 hours'));
+        $ids[] = $this->addDatabaseEntry(0, 0, null, null, null, new \DateTime('+2 hours'));
+        $ids[] = $this->addDatabaseEntry(0, 0, null, null, null, new \DateTime('-2 hours'));
+        $ids[] = $this->addDatabaseEntry(0, 0, null, null, null, new \DateTime('-2 hours'));
+        $ids[] = $this->addDatabaseEntry(0, 0, null, null, null, new \DateTime('-2 hours'));
+
+        $manager = new Manager(
+            $this->connection,
+            $this->createMock(LoggerInterface::class),
+            $this->createMock(IConfig::class),
+            Server::get(ITimeFactory::class),
+            new EmojiHelper($this->connection),
+            $this->createMock(IInitialStateService::class),
+            $this->rootFolder,
+            $this->createMock(IEventDispatcher::class)
+        );
+
+        // just to make sure they are really set, with correct actor data
+        $comment = $manager->get((string)$ids[1]);
+        $this->assertSame($comment->getObjectType(), 'files');
+        $this->assertSame($comment->getObjectId(), 'file64');
+
+        $deleted = $manager->deleteCommentsExpiredAtObject('files', 'file64');
+        $this->assertTrue($deleted);
+
+        $deleted = 0;
+        $exists = 0;
+        foreach ($ids as $id) {
+            try {
+                $manager->get((string)$id);
+                $exists++;
+            } catch (NotFoundException $e) {
+                $deleted++;
+            }
+        }
+        $this->assertSame($exists, 3);
+        $this->assertSame($deleted, 3);
+
+        // actor info is gone from DB, but when database interaction is alright,
+        // we still expect to get true back
+        $deleted = $manager->deleteCommentsExpiredAtObject('files', 'file64');
+        $this->assertFalse($deleted);
+    }
+
+    public function testDeleteCommentsExpiredAtObjectType(): void {
+        $ids = [];
+        $ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file1', new \DateTime('-2 hours'));
+        $ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file2', new \DateTime('-2 hours'));
+        $ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file3', new \DateTime('-2 hours'));
+        $ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file3', new \DateTime());
+        $ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file3', new \DateTime());
+        $ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file3', new \DateTime());
+
+        $manager = new Manager(
+            $this->connection,
+            $this->createMock(LoggerInterface::class),
+            $this->createMock(IConfig::class),
+            Server::get(ITimeFactory::class),
+            new EmojiHelper($this->connection),
+            $this->createMock(IInitialStateService::class),
+            $this->rootFolder,
+            $this->createMock(IEventDispatcher::class)
+        );
+
+        $deleted = $manager->deleteCommentsExpiredAtObject('files');
+        $this->assertTrue($deleted);
+
+        $deleted = 0;
+        $exists = 0;
+        foreach ($ids as $id) {
+            try {
+                $manager->get((string)$id);
+                $exists++;
+            } catch (NotFoundException $e) {
+                $deleted++;
+            }
+        }
+        $this->assertSame($exists, 0);
+        $this->assertSame($deleted, 6);
+
+        // actor info is gone from DB, but when database interaction is alright,
+        // we still expect to get true back
+        $deleted = $manager->deleteCommentsExpiredAtObject('files');
+        $this->assertFalse($deleted);
+    }
+
+    public function testSetMarkRead(): void {
+        /** @var IUser|\PHPUnit\Framework\MockObject\MockObject $user */
+        $user = $this->createMock(IUser::class);
+        $user->expects($this->any())
+            ->method('getUID')
+            ->willReturn('alice');
+
+        $dateTimeSet = new \DateTime();
+
+        $manager = $this->getManager();
+        $manager->setReadMark('robot', '36', $dateTimeSet, $user);
+
+        $dateTimeGet = $manager->getReadMark('robot', '36', $user);
+
+        $this->assertEquals($dateTimeGet->getTimestamp(), $dateTimeSet->getTimestamp());
+    }
+
+    public function testSetMarkReadUpdate(): void {
+        /** @var IUser|\PHPUnit\Framework\MockObject\MockObject $user */
+        $user = $this->createMock(IUser::class);
+        $user->expects($this->any())
+            ->method('getUID')
+            ->willReturn('alice');
+
+        $dateTimeSet = new \DateTime('yesterday');
+
+        $manager = $this->getManager();
+        $manager->setReadMark('robot', '36', $dateTimeSet, $user);
+
+        $dateTimeSet = new \DateTime('today');
+        $manager->setReadMark('robot', '36', $dateTimeSet, $user);
+
+        $dateTimeGet = $manager->getReadMark('robot', '36', $user);
+
+        $this->assertEquals($dateTimeGet, $dateTimeSet);
+    }
+
+    public function testReadMarkDeleteUser(): void {
+        /** @var IUser|\PHPUnit\Framework\MockObject\MockObject $user */
+        $user = $this->createMock(IUser::class);
+        $user->expects($this->any())
+            ->method('getUID')
+            ->willReturn('alice');
+
+        $dateTimeSet = new \DateTime();
+
+        $manager = $this->getManager();
+        $manager->setReadMark('robot', '36', $dateTimeSet, $user);
+
+        $manager->deleteReadMarksFromUser($user);
+        $dateTimeGet = $manager->getReadMark('robot', '36', $user);
+
+        $this->assertNull($dateTimeGet);
+    }
+
+    public function testReadMarkDeleteObject(): void {
+        /** @var IUser|\PHPUnit\Framework\MockObject\MockObject $user */
+        $user = $this->createMock(IUser::class);
+        $user->expects($this->any())
+            ->method('getUID')
+            ->willReturn('alice');
 
-		$dateTimeSet = new \DateTime();
+        $dateTimeSet = new \DateTime();
 
-		$manager = $this->getManager();
-		$manager->setReadMark('robot', '36', $dateTimeSet, $user);
+        $manager = $this->getManager();
+        $manager->setReadMark('robot', '36', $dateTimeSet, $user);
 
-		$manager->deleteReadMarksOnObject('robot', '36');
-		$dateTimeGet = $manager->getReadMark('robot', '36', $user);
+        $manager->deleteReadMarksOnObject('robot', '36');
+        $dateTimeGet = $manager->getReadMark('robot', '36', $user);
 
-		$this->assertNull($dateTimeGet);
-	}
+        $this->assertNull($dateTimeGet);
+    }
 
-	public function testSendEvent(): void {
-		$handler1 = $this->getMockBuilder(ICommentsEventHandler::class)->getMock();
-		$handler1->expects($this->exactly(4))
-			->method('handle');
+    public function testSendEvent(): void {
+        $handler1 = $this->getMockBuilder(ICommentsEventHandler::class)->getMock();
+        $handler1->expects($this->exactly(4))
+            ->method('handle');
 
-		$handler2 = $this->getMockBuilder(ICommentsEventHandler::class)->getMock();
-		$handler1->expects($this->exactly(4))
-			->method('handle');
+        $handler2 = $this->getMockBuilder(ICommentsEventHandler::class)->getMock();
+        $handler1->expects($this->exactly(4))
+            ->method('handle');
 
-		$manager = $this->getManager();
-		$manager->registerEventHandler(function () use ($handler1) {
-			return $handler1;
-		});
-		$manager->registerEventHandler(function () use ($handler2) {
-			return $handler2;
-		});
+        $manager = $this->getManager();
+        $manager->registerEventHandler(function () use ($handler1) {
+            return $handler1;
+        });
+        $manager->registerEventHandler(function () use ($handler2) {
+            return $handler2;
+        });
 
-		$comment = new Comment();
-		$comment
-			->setActor('users', 'alice')
-			->setObject('files', 'file64')
-			->setMessage('very beautiful, I am impressed!')
-			->setVerb('comment');
+        $comment = new Comment();
+        $comment
+            ->setActor('users', 'alice')
+            ->setObject('files', 'file64')
+            ->setMessage('very beautiful, I am impressed!')
+            ->setVerb('comment');
 
-		// Add event
-		$manager->save($comment);
+        // Add event
+        $manager->save($comment);
 
-		// Update event
-		$comment->setMessage('Different topic');
-		$manager->save($comment);
+        // Update event
+        $comment->setMessage('Different topic');
+        $manager->save($comment);
 
-		// Delete event
-		$manager->delete($comment->getId());
-	}
+        // Delete event
+        $manager->delete($comment->getId());
+    }
 
-	public function testResolveDisplayName(): void {
-		$manager = $this->getManager();
+    public function testResolveDisplayName(): void {
+        $manager = $this->getManager();
 
-		$planetClosure = function ($name) {
-			return ucfirst($name);
-		};
-
-		$galaxyClosure = function ($name) {
-			return strtoupper($name);
-		};
-
-		$manager->registerDisplayNameResolver('planet', $planetClosure);
-		$manager->registerDisplayNameResolver('galaxy', $galaxyClosure);
-
-		$this->assertSame('Neptune', $manager->resolveDisplayName('planet', 'neptune'));
-		$this->assertSame('SOMBRERO', $manager->resolveDisplayName('galaxy', 'sombrero'));
-	}
-
-
-	public function testRegisterResolverDuplicate(): void {
-		$this->expectException(\OutOfBoundsException::class);
-
-		$manager = $this->getManager();
-
-		$planetClosure = function ($name) {
-			return ucfirst($name);
-		};
-		$manager->registerDisplayNameResolver('planet', $planetClosure);
-		$manager->registerDisplayNameResolver('planet', $planetClosure);
-	}
-
-
-	public function testRegisterResolverInvalidType(): void {
-		$this->expectException(\InvalidArgumentException::class);
-
-		$manager = $this->getManager();
-
-		$planetClosure = function ($name) {
-			return ucfirst($name);
-		};
-		$manager->registerDisplayNameResolver(1337, $planetClosure);
-	}
-
-
-	public function testResolveDisplayNameUnregisteredType(): void {
-		$this->expectException(\OutOfBoundsException::class);
-
-		$manager = $this->getManager();
-
-		$planetClosure = function ($name) {
-			return ucfirst($name);
-		};
-
-		$manager->registerDisplayNameResolver('planet', $planetClosure);
-		$manager->resolveDisplayName('galaxy', 'sombrero');
-	}
-
-	public function testResolveDisplayNameDirtyResolver(): void {
-		$manager = $this->getManager();
-
-		$planetClosure = function () {
-			return null;
-		};
-
-		$manager->registerDisplayNameResolver('planet', $planetClosure);
-		$this->assertTrue(is_string($manager->resolveDisplayName('planet', 'neptune')));
-	}
-
-	private function skipIfNotSupport4ByteUTF() {
-		if (!$this->getManager()->supportReactions()) {
-			$this->markTestSkipped('MySQL doesn\'t support 4 byte UTF-8');
-		}
-	}
-
-	/**
-	 * @dataProvider providerTestReactionAddAndDelete
-	 *
-	 * @param IComment[] $comments
-	 * @param array $reactionsExpected
-	 * @return void
-	 */
-	public function testReactionAddAndDelete(array $comments, array $reactionsExpected): void {
-		$this->skipIfNotSupport4ByteUTF();
-		$manager = $this->getManager();
-
-		$processedComments = $this->proccessComments($comments);
-		$comment = end($processedComments);
-		if ($comment->getParentId()) {
-			$parent = $manager->get($comment->getParentId());
-			$this->assertEqualsCanonicalizing($reactionsExpected, $parent->getReactions());
-		}
-	}
-
-	public function providerTestReactionAddAndDelete(): array {
-		return[
-			[
-				[
-					['message', 'alice', 'comment', null],
-				], [],
-			],
-			[
-				[
-					['message', 'alice', 'comment', null],
-					['