DataMapper ORM v1.8.1

[eluser]WanWizard[/eluser]
@Spelljack,

Thanks, I saw the pull request. I'll try to find some time later this week to have a look and run some tests...

[eluser]Nicolas L.A.[/eluser]
Hi WanWizard,
I'm brand new on CI and I wanted to be able to easily manipulate the models relationship as I use to do with cakePHP and your solution seems perfect. Reminds me a lot of models in cake.

I still have a question related to Many-To-Many relation. Let's say table A has many A_B and B has many A_B. How could I retrieve and declare a field in A_B table?


Cheers,

[eluser]WanWizard[/eluser]
What do you mean by A_B?

In Datamapper, if you have a many-to-many relation between A and B, you'll have a model A and a model B, with a table As, Bs, and a table As_Bs which contains the id's of both A and B and allow the many-to-many to exist.

If you have data that is relevant to the relationship between A and B, and therefore has to be stored in the relationship table As_Bs, you'll use the join_fields() methods of Datamapper.

[eluser]Nicolas L.A.[/eluser]
[quote author="WanWizard" date="1309453191"]What do you mean by A_B?

In Datamapper, if you have a many-to-many relation between A and B, you'll have a model A and a model B, with a table As, Bs, and a table As_Bs which contains the id's of both A and B and allow the many-to-many to exist.

If you have data that is relevant to the relationship between A and B, and therefore has to be stored in the relationship table As_Bs, you'll use the join_fields() methods of Datamapper.[/quote]
I meant As_Bs obviously as you understood it.

I'm obviously not talking about the *_id fields but rather about an extra field in the As_Bs table which is not link to any other table. Like :

Code:

.-------------.
| As_Bs table |
.-------------.
| a_id        |
| b_id        |
| c           |
.-------------.

Would this method join_fields() work for this?


Thanks

[eluser]WanWizard[/eluser]
Yes, that is exactly what I mean. See http://datamapper.wanwizard.eu/pages/joinfields.html.

[eluser]Nicolas L.A.[/eluser]
[quote author="WanWizard" date="1309460126"]Yes, that is exactly what I mean. See http://datamapper.wanwizard.eu/pages/joinfields.html.[/quote]
Thank you.

Despite reading your user guide I didn't find this page. I was expecting the information in the "General Topics > Setting up Relationships" page rather than the current separate one under "Relationships > Working with Join Fields".

[eluser]Spelljack[/eluser]
@WanWizard

I am in a terrible situation. I need to generate this Query with DataMapper. Could you help me? It's very complicated and I couldn't find a way.

I changed the tables below like this: 'aroes', 'aro_groups', 'aroes_aro_groups'

So as you see aroes and aro_groups has many-to-many relationship.

Code:

SELECT
    DISTINCT g2.id
FROM
    aro o, groups_aro_map gm, aro_groups g1, aro_groups g2
WHERE
        (o.section_value = 'crew' AND o.value = 'chewie')
    AND    gm.aro_id=o.id
    AND    g1.id=gm.group_id
    AND    (g2.lft <= g1.lft AND g2.rgt >= g1.rgt)

[eluser]WanWizard[/eluser]
That looks very much like some sort of nestedset implementation (get all parents of).

Is this existing code/data, or are you building something new? If so, you might want to look at the nestedsets extension, which does all this for you (and more).

[eluser]Spelljack[/eluser]
I am trying to re-code phpGACL for CodeIgniter. This query gets the group id and its parent all the way up to root.

[eluser]Nicolas L.A.[/eluser]
Is there a way to have the Nested Set plugin to return a structured array?
I tried to use the dump_tree() function without success as it returns all the nodes on the same level.
I am looking for something which would return something like the following:

Code:

array(
  'Array 1' => array(
    [properties],
    'Children' => array(
      [Array 1.1],
      [Array 1.2]
    )
  ),
  'Array 2' => array(
    [properties],
    'Children' => array(
      [Array 2.1]
    )
  )
);

Is that possible directly with your DM or do I have to code a recursive function to do so?


Thanks.