DataMapper - Counting related items

[eluser]phobeous[/eluser]
Hi again and thanks for your "fast as light" answer. You're right, servicio is a collection, but I want to run the count only on the related servicios of expediente with id=1.

include_related_count('servicio/adjunto') fails. This is the generated query:

SELECT `expedientes`.*, (SELECT COUNT(*) AS count FROM (`adjuntos`) LEFT OUTER JOIN `expedientes` `expedientes_subquery` ON `expedientes_subquery`.`id` = `adjuntos`.`servicio_id` WHERE `expedientes_subquery`.id = `expedientes`.`id`) AS servicio/adjunto_count FROM (`expedientes`) WHERE `expedientes`.`id` = 1

Because of the alias 'servicio/adjunto_count', but even fixing the alias and executing the query directly on MySQL, the result is wrong. Table 'servicios' is not queried and it tries to relate adjuntos directly with expediente.

I just suggest that it would be nice and cool if, given a proper relationship configuration, DataMapper library could 'translate' this notation:

Code:

$file = new Expediente(1);
$adjuntos_count = $file->servicio->adjunto->count();

into this query:

SELECT COUNT(*) AS `numrows`
FROM (`adjuntos`)
LEFT OUTER JOIN `servicios` servicios ON `servicios`.`id` = `adjuntos`.`servicio_id`
WHERE `servicios`.`expediente_id` = 1

Furthermore, you give this as an option in your first answer to this thread. The relationship scenario for my suggestion is the same as

Code:

$continent->country->person->count();

But, please Harro, take my comment just as a suggestion. DataMapper works perfectly and it's a great library for which me (and thousand of people around the world) will be always pleased to you.

Cheers.