Styjun

I am trying to optimise retrieving data from the database instead of letting Doctrine handle hydration, to minimize the data retrieval.

I have an object User that contains a lot of connected entities:

class User 
ArrayCollection
 *
 * @ORMOneToMany(targetEntity="WorkersDepartments", mappedBy="worker")
 */
 protected $departments;

// ... more code

The WorkerDepartments entity has a composite key: workerId and departmentId, but these parameters are not added to the class:

class WorkerDepartments 

/**
 * @var Worker
 * @ORMId
 * @ORMManyToOne(targetEntity="SomeClassWorker", inversedBy="departments")
 */
 private $worker;

 /**
 * @var Department
 * @ORMId
 * @ORMManyToOne(targetEntity="Department", inversedBy="workers")
 */
 private $department;

 /**
 * @var integer
 * @ORMColumn(type="integer")
 */
 private $status;

When I try to use the ResultSetMappingBuilder and createNativeQuery method from Doctrine to only query whats required, I cannot map the joined WorkersDepartments object into the User object.

After some reading, this appears to be caused by not mapping the id field into the object.

This created a User object with an empty departments parameter:

$rsm = new ResultSetMappingBuilder($entityManager);
$rsm->addEntityResult(User::class, 'c')
 ->addFieldResult('c', 'user_id', 'id');

 $rsm->addJoinedEntityResult(WorkersDepartments::class, 'wd', 'c', 'departments')
 ->addFieldResult('wd', 'status', 'status');

This works (after adding the params to the WorkersDepartment object):

$rsm = new ResultSetMappingBuilder($entityManager);
$rsm->addEntityResult(User::class, 'c')
 ->addFieldResult('c', 'user_id', 'id');

 $rsm->addJoinedEntityResult(WorkersDepartments::class, 'wd', 'c', 'departments')
 ->addFieldResult('wd', 'wd_worker_id', 'workerId');
 ->addFieldResult('wd', 'wd_department_id', 'departmentId');
 ->addFieldResult('wd', 'status', 'status');

So the solution here would be adding the parameters to the class, but I would rather not do that, as this is causing duplicate data in the objects and the params won't ever be used.

Do you know a way to map the WorkersDeparments object without having to add the composite key parameters to the class?