removeAllUserRoles(); $this->insertUserRole('first role'); $this->insertUserRole('second role'); $this->insertUserRole('third role'); $userRoles = $this->getQuery()(); Assert::assertCount(3, $userRoles); Assert::containsOnlyInstancesOf(UserRole::class); } private function removeAllUserRoles(): void { $deleteSql = <<get('database_connection')->executeQuery($deleteSql); } private function insertUserRole(string $roleCode): void { $insertSql = <<get('database_connection')->executeQuery( $insertSql, [ 'roleCode' => $roleCode, 'roleLabel' => $roleCode, 'roleType' => 'default', ], ); } protected function getConfiguration(): Configuration { return $this->catalog->useMinimalCatalog(); } private function getQuery(): SqlFindAllUserRoles { return $this->get(SqlFindAllUserRoles::class); } }