connection = $this->get('database_connection'); $this->connectedAppLoader = $this->get('akeneo_connectivity.connection.fixtures.connected_app_loader'); } protected function getConfiguration() { return $this->catalog->useMinimalCatalog(); } public function testTheGroupAllIsRemovedFromApps(): void { $this->insertUser('john'); $this->insertConnection('magento', ConnectionType::DEFAULT_TYPE); $this->insertConnection('app_1t1n5nczm36ss00kws0cgckgw', ConnectionType::APP_TYPE); $this->assertUserHasGroups('john', ['All', 'Manager']); $this->assertUserHasGroups('magento', ['All', 'Manager']); $this->assertUserHasGroups('app_1t1n5nczm36ss00kws0cgckgw', ['All', 'Manager']); $this->reExecuteMigration(self::MIGRATION_LABEL); $this->assertUserHasGroups('john', ['All', 'Manager']); $this->assertUserHasGroups('magento', ['All', 'Manager']); $this->assertUserHasGroups('app_1t1n5nczm36ss00kws0cgckgw', ['Manager']); } private function assertUserHasGroups(string $username, array $expectedGroups): void { $query = <<connection->fetchFirstColumn($query, [ 'username' => $username, ]); sort($expectedGroups); sort($groups); Assert::assertSame($expectedGroups, $groups); } private function insertConnection(string $code, string $type): void { $oauthClientId = $this->insertOAuthClient(); $userId = $this->insertUser($code); $query = <<connection->executeQuery($query, [ 'client' => $oauthClientId, 'user' => $userId, 'code' => $code, 'type' => $type, ]); } private function insertUser(string $username): int { $query = <<connection->executeQuery($query, [ 'username' => $username, ]); $uid = (int) $this->connection->lastInsertId(); $this->addUserToGroups($uid, ['All', 'Manager']); return $uid; } private function addUserToGroups(int $uid, array $groups): void { $query = <<connection->executeQuery($query, [ 'user' => $uid, 'group' => $group, ]); } } private function insertOAuthClient(): int { $query = <<connection->executeQuery($query, [ 'random' => $this->random(), ]); return (int) $this->connection->lastInsertId(); } private function random(int $maxLength = 30): string { return \substr(\base_convert(\bin2hex(\random_bytes(16)), 16, 36), 0, $maxLength); } }