. */ namespace SP\Tests\Repositories; use DI\DependencyException; use DI\NotFoundException; use SP\Core\Context\ContextException; use SP\Core\Exceptions\ConstraintException; use SP\Core\Exceptions\QueryException; use SP\Core\Exceptions\SPException; use SP\DataModel\ItemSearchData; use SP\DataModel\ProfileData; use SP\DataModel\UserProfileData; use SP\Repositories\DuplicatedItemException; use SP\Repositories\UserProfile\UserProfileRepository; use SP\Tests\DatabaseTestCase; use stdClass; use function SP\Tests\setupContext; /** * Class UserProfileRepositoryTest * * Tests de integración para comprobar las consultas a la BBDD relativas a los perfiles de usuarios * * @package SP\Tests */ class UserProfileRepositoryTest extends DatabaseTestCase { /** * @var UserProfileRepository */ private static $repository; /** * @throws DependencyException * @throws NotFoundException * @throws ContextException */ public static function setUpBeforeClass(): void { $dic = setupContext(); self::$loadFixtures = true; // Inicializar el repositorio self::$repository = $dic->get(UserProfileRepository::class); } /** * Comprobar la obtención de perfiles * * @throws ConstraintException * @throws QueryException */ public function testGetAll() { $result = self::$repository->getAll(); $this->assertEquals(3, $result->getNumRows()); /** @var UserProfileData[] $data */ $data = $result->getDataAsArray(); $this->assertCount(3, $data); $this->assertInstanceOf(UserProfileData::class, $data[0]); $this->assertEquals('Admin', $data[0]->getName()); $this->assertInstanceOf(UserProfileData::class, $data[1]); $this->assertEquals('Demo', $data[1]->getName()); } /** * Comprobar la búsqueda de perfiles * * @throws ConstraintException * @throws QueryException */ public function testSearch() { $itemSearchData = new ItemSearchData(); $itemSearchData->setLimitCount(10); $itemSearchData->setSeachString('Demo'); $result = self::$repository->search($itemSearchData); $data = $result->getDataAsArray(); $this->assertEquals(1, $result->getNumRows()); $this->assertCount(1, $data); $this->assertInstanceOf(stdClass::class, $data[0]); $this->assertEquals(2, $data[0]->id); $this->assertEquals('Demo', $data[0]->name); // Nueva búsqueda de perfil no existente $itemSearchData->setSeachString('prueba'); $result = self::$repository->search($itemSearchData); $this->assertEquals(0, $result->getNumRows()); $this->assertCount(0, $result->getDataAsArray()); } /** * Comprobar la actualización de perfiles * * @throws ConstraintException * @throws DuplicatedItemException * @throws QueryException */ public function testUpdate() { $data = new UserProfileData(); $data->setId(2); $data->setName('Test Profile Demo'); $this->assertEquals(1, self::$repository->update($data)); $this->expectException(DuplicatedItemException::class); $data->setName('Admin'); self::$repository->update($data); } /** * Comprobar la eliminación de perfiles * * @throws ConstraintException * @throws QueryException */ public function testDelete() { $result = self::$repository->delete(3); $this->assertEquals(1, $result); $this->assertEquals(2, self::getRowCount('UserProfile')); $this->expectException(ConstraintException::class); self::$repository->delete(1); } /** * Comprobar si el perfil está en uso * * @throws ConstraintException * @throws QueryException */ public function testCheckInUse() { $this->assertTrue(self::$repository->checkInUse(1)); $this->assertTrue(self::$repository->checkInUse(2)); $this->assertFalse(self::$repository->checkInUse(3)); } /** * Comprobar la creación de perfiles * * @throws ConstraintException * @throws DuplicatedItemException * @throws QueryException */ public function testCreate() { $profileData = new ProfileData(); $profileData->setAccAdd(true); $profileData->setAccDelete(true); $profileData->setConfigBackup(true); $data = new UserProfileData(); $data->setId(4); $data->setName('Prueba'); $data->setProfile($profileData); $result = self::$repository->create($data); $this->assertEquals($data->getId(), $result); $this->assertEquals(4, self::getRowCount('UserProfile')); /** @var UserProfileData $resultData */ $resultData = self::$repository->getById($result)->getData(); $this->assertEquals($data->getId(), $resultData->getId()); $this->assertEquals($data->getName(), $resultData->getName()); $this->assertEquals(serialize($data->getProfile()), $resultData->getProfile()); } /** * @throws SPException */ public function testCreateDuplicated() { $data = new UserProfileData(); $data->setName('Admin'); $data->setProfile(new ProfileData()); $this->expectException(DuplicatedItemException::class); self::$repository->create($data); } /** * Comprobar la obtención de perfiles por Id * * @throws ConstraintException * @throws QueryException */ public function testGetById() { $result = self::$repository->getById(2); $this->assertEquals(1, $result->getNumRows()); /** @var UserProfileData $data */ $data = $result->getData(); $this->assertInstanceOf(UserProfileData::class, $data); $this->assertEquals('Demo', $data->getName()); $this->assertNotEmpty($data->getProfile()); $this->assertEquals(0, self::$repository->getById(4)->getNumRows()); } /** * Comprobar la obtención de los usuarios asociados a un perfil * * @throws ConstraintException * @throws QueryException */ public function testGetUsersForProfile() { $this->assertEquals(1, self::$repository->getUsersForProfile(2)->getNumRows()); $this->assertEquals(0, self::$repository->getUsersForProfile(3)->getNumRows()); } /** * Comprobar la obtención de perfiles en lote * * @throws ConstraintException * @throws QueryException */ public function testGetByIdBatch() { $profiles = self::$repository->getByIdBatch([1, 2, 5]); $this->assertCount(2, $profiles); $this->assertInstanceOf(UserProfileData::class, $profiles[0]); $this->assertEquals(1, $profiles[0]->getId()); $this->assertEquals('Admin', $profiles[0]->getName()); $this->assertInstanceOf(UserProfileData::class, $profiles[1]); } /** * Comprobar la eliminación de perfiles en lote * * @throws ConstraintException * @throws QueryException */ public function testDeleteByIdBatch() { // Se lanza excepción en caso de restricción relacional $this->expectException(ConstraintException::class); $result = self::$repository->deleteByIdBatch([1, 2, 3, 4]); $this->assertEquals(1, $result); } }