DataMapper ORM v1.8.0

[eluser]Arministrator[/eluser]
I guess you're right about donations. If i got it right, they should be related to donors, but have no relation to bloodtype? Makes sense.

So:

donators (I know it's miss-spelled, but I need to use 'donor' for something else)
bloodtypes
donations
bloodtypes_donators
donations_donators

So what would be the best way to query a donor with all his donations?

This is what I came up with, but there's still a lot of redundancies. E.g. email value is returned 24 times. (dump) Could this code be any better? I'm trying not just to get it working, but to understand it, and optimize the process as much as possible.

Code:

$donator = new Donator;
$donator->where('email', $this->input->post('email'))->include_related('bloodtype')->get();
$donator->donation->get_iterated();

Resulting query:

Code:

SELECT `donations`.* FROM (`donations`) LEFT OUTER JOIN `donations_donators` donations_donators ON `donations`.`id` = `donations_donators`.`donation_id` WHERE `donations_donators`.`donator_id` = 70

I hope I'm not becoming annoying, but I probably will have a couple of more questions. I'm not trying to get you guys to do my work, but I've never used object approach on a database, and want to get it right the first time.

A big thank you, wanwizard.