Hi,
I have a table with associations to itself in a parent child hierarchy
using parent_id as the foreign key. I can use both the *tree* and the
*rcte_tree* Sequel plugins there.
I need to get all the children in a nested format, so I've written a method
like this -
class User < Sequel::Model(:users)
plugin :rcte_tree
def get_all_children
below = []
if self.children.count.zero?
below = nil
else
self.children.each do |child|
ret = child.get_all_children
below.push ret
end
end
self.values.merge({children: below})
end
end
And I'm able to get the response as expected -
---
:id: 1
:name: AAA
:parent_id: nil
:children:
- :id: 2
:name: AA1
:parent_id: 1
:children:
- :id: 3
:name: AA2
:parent_id: 2
:children: nil
I was wondering if there is a better way to do this.
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/6ebb5cf5-be7f-44f8-b3e6-3361773ee5d3n%40googlegroups.com.
