Matt S Trout writes:
> George Hartzell wrote:
> > I think that I understand that I can do something like this:
> >
> > { join => {nodes => attrs}}
> >
> > to get at <node_attr>'s that belong_to <node>'s that belong_to an
> > <rn>. But at this point I no longer know how to get the rn and rncbt
> > join that I achieved in the example above with the simple:
> >
> > { join => 'rncbts' }
> >
> > Is there a way to do both?
> >
> > And even goofier, I'm working with pairs of nodes and contraining on
> > their node_attr's, so I think I need to do this:
> >
> > { join => {nodes => attrs,
> > nodes => attrs}}
> >
> > which I think should give me attrs and attrs_2 that belong to node and
> > node_2 that belong_to <rn>???
>
> join => [ 'rncbts', { nodes => 'attrs' }, { nodes => 'attrs' } ]
Holy Mackerel:
my $rs = $s->resultset('...')->search({
'node_count(me.id)' => 2,
'control_count(me.id)' => 1,
'attrs.name' => 'NodeType',
'attrs.value' => 'Protein',
'attrs_2.name' => 'Organism',
'attrs_2.value' => 'Homo sapiens',
'attrs_3.name' => 'NodeType',
'attrs_3.value' => 'Protein',
'attrs_4.name' => 'Organism',
'attrs_4.value' => 'Homo sapiens',
'rncbts.value' => 'Protein',
'rncbts.count' => 2,
},
{
join => [{nodes =>
['attrs', 'attrs']},
{nodes =>
['attrs', 'attrs']},
'rncbts',
]
},
);
which says that attrs and attrs_2 belong_to one node, and attrs_3 and
attrs_4 belong to the other.
wow. yeesh.
Yeah, I'm getting the 'two nodes of type Protein' constraint twice,
once from my rncbts table and once by contraining the node_attr, but
it's on the way to something even more powerful/ugly/goofy.
Thanks!
g.
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
