DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]Guido Mallee[/eluser]
I understood. Though, the way I do it in my example code is just as memory intensive as it would be if 'the easy way' would have been possible, isn't it?

Since the relation of my table BLOCKS to my table BLOCK_TEXTS actually is one-to-'one or zero' (one-to-many but never more than 1 result) I tried to use include_related. As you mentioned though, this didn't work since the relationship theoratically still is one-to-many. I couldn't find the ticket about using include_related with has_many (hate the search functionality on this forums, or is it just me?). Could you pass me the link, please? I think I'll give that a try since, like I said, the result will be only one row maximum, and therefore, one object maximum. No problem, right?

I finished porting one of my websites with CMS to DataMapper and I'm really enthusiastic about it! I think DataMapper is going to save me a lot of work in the future. Many thanks, WanWizard, for all your dedicated work on this great ORM, and of course, for your great support. One (hopefully) last question, though:

Remember I asked you about the joining field? I have a joining field 'position' in the joining table between the tables PAGES and BLOCKS. I managed to easily get all blocks from a page, ordered by position. To save a new block though, I had to get the max position of a block on a specific page first, which turned out to be quite hard. I ended up doing:

Code:

$page = new Page($page_id);
$page->block->include_join_fields()->get();
$position = 1;
foreach ($page->block as $b)
{
    if ($b->join_position > $position)
        $position = $b->join_position;
}
$position++;
            
$block->save($page);
$block->set_join_field($page, 'position', $position);

Where I'd much rather would like to do something like:

Code:

$page = new Page($page_id);
$page->block->select_max('position');
$page->block->include_join_fields()->get();
$position = $page->block->join_position + 1;
$block->save($page);
$block->set_join_field($page, 'position', $position)

This didn't work though. It's not a disaster to do it like in the first piece of code, although, getting the max position used to be one line of code for me before. Is there a way to refactor this code?

Thanks in advance and I'll try hard to leave you in peace after this one.