Can I do a "named_scope" for this scenario?

Rails
1

Hi,
Is it possible to do a named_scope (or “has_many, :through…”) for this
scenario:

  • Class: Node
  • Class: Relationships
  • node_id
  • dependant_node_id

QUESTION: So how can I get a “has_many” or “named_scope” happening
within
the Node class such that it would:

(a) pass back ALL relationships, including both those relationships for
which the node instance is either referenced by (i) node_id, or (ii)
dependant_node_id. This might be called something like
“all_relationships”

(b) pass back ALL nodes at the other end of the relationships identified
by
(a), but not including in the returned array of nodes the instance node
in
question. This might be called something “all_direct_related_nodes”.

–
Greg
http://blog.gregnet.org/

2

PS. To further clarify my question note that:

class Node < ActiveRecord::Base
has_many :relationships_as_child, :class_name => ‘Relationship’,
:foreign_key => :dependant_node_id
has_many :relationships_as_parent, :class_name => ‘Relationship’,
:foreign_key => :node_id

def all_relations
Relationship.find(:all, :conditions => [“node_id = ? OR
dependant_node_id = ?”, self.id, self.id])
end

I can get the first two “has_many” working, but I can’t work out how to
effectively combine these two into one “has_many”. I can create a "
all_relations" method however that does provide the full flexibility of
a "
has_many" or a “named_scope” version (which I’m after) as I can’t then
do
further things like:

Node.find(1).all_relations.find(1) # fails

So in other words I want the output of the “all_relations” function, but
in
the form of a “has_many” or a “named_scope”.

Any help welcomed :slight_smile:

2009/4/13 Greg H. [email protected]

the Node class such that it would:

–
Greg
http://blog.gregnet.org/

–
Greg
http://blog.gregnet.org/

3

You could try:

named_scope :all_relations_for, lambda { |o| { :conditions =>
[“node_id = :o_id OR dependant_node_id = :o_id”, { :o_id =>
o.id }] } }

That will let you do:

Node.all_relations_for(Node.find(1)) etc.

Not quite as snazzy as what you’re looking for, but close…

–Matt J.

On Apr 13, 6:26 pm, Greg H. [email protected]

4

thanks, but this doesn’t bring back Relationships, it brings back
Nodes…does a named_scope always bring back instances of the class it’s
specified in it does it?

I really want a “named_scope”, or “has_many” version of the method
“all_relations” in my original email below…any more ideas anyone?

thanks

2009/4/15 Matt J. [email protected]

has_many :relationships_as_child, :class_name => ‘Relationship’,
I can get the first two “has_many” working, but I can’t work out how to
the form of a “has_many” or a “named_scope”.

Any help welcomed :slight_smile:

2009/4/13 Greg H. [email protected]

–
Greg
http://blog.gregnet.org/

5

I think my solution was aiming more for the all_direct_related_models
part; sorry for the confusion.

You should be able to do the other half with a named scope on
Relationship, basically with the same scope:

class Relationship < …
named_scope :all_relations_for, lambda { |o| { :conditions =>
[“node_id = :o_id OR dependant_node_id = :o_id”, { :o_id =>
o.id }] } }
end

Then drop a method into your Node model:

class Node < …
def all_relations
Relationship.all_relations_for(self)
end
end

–Matt J.

On Apr 20, 10:14 pm, Greg H. [email protected]