* @copyright 2020 Akeneo SAS (http://www.akeneo.com) * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) */ class UpdateUserPermissionsIntegration extends TestCase { public function test_it_updates_a_role_and_a_group() { $connection = $this->createConnection('pimgento'); $userId = $this->fetchConnectionUserId($connection->username()); $this->assertConnectionRole($userId, (int)$connection->userRoleId()); Assert::assertNull($connection->userGroupId()); $newRoleId = $this->fetchNewRoleId((int) $connection->userRoleId()); $newGroupId = $this->fetchNewGroupId((int) $connection->userGroupId()); $this->getUpdateUserPermissionsService()->execute(new UserId($userId), $newRoleId, $newGroupId); $this->assertConnectionRole($userId, $newRoleId); $this->assertConnectionGroup($userId, $newGroupId); } private function fetchConnectionUserId(string $username): int { $sqlQuery = <<getDatabaseConnection()->fetchOne($sqlQuery, ['username' => $username]); } private function assertConnectionRole(int $userId, int $userRoleId): void { $sqlQuery = <<getDatabaseConnection() ->fetchOne($sqlQuery, ['user_id' => $userId, 'role_id' => $userRoleId]); Assert::assertEquals(1, $rolesCount); } private function assertConnectionGroup(int $userId, int $userGroupId): void { $sqlQuery = <<getDatabaseConnection() ->fetchOne($sqlQuery, ['user_id' => $userId, 'group_id' => $userGroupId]); Assert::assertEquals(1, $groupsCount); } protected function getConfiguration(): Configuration { return $this->catalog->useMinimalCatalog(); } private function getUpdateUserPermissionsService(): UpdateUserPermissions { return $this->get(UpdateUserPermissions::class); } private function createConnection(string $code): ConnectionWithCredentials { $command = new CreateConnectionCommand($code, $code, FlowType::OTHER, false); return $this ->get(CreateConnectionHandler::class) ->handle($command); } private function getDatabaseConnection(): Connection { return $this->get('database_connection'); } private function fetchNewRoleId(int $currentRoleId): int { return (int) $this ->getDatabaseConnection() ->fetchOne('SELECT id FROM oro_access_role where id != :role_id', ['role_id' => $currentRoleId]); } private function fetchNewGroupId(int $currentGroupId): int { return (int) $this ->getDatabaseConnection() ->fetchOne('SELECT id FROM oro_access_group where id != :group_id', ['group_id' => $currentGroupId]); } }