To make it easier to test, I wrote a self containing script, with in
memory sqlite database.

require 'rubygems'
require 'sequel'

DB = Sequel.sqlite

DB.create_table! :trees do
  primary_key :id
  interger :parent_id, :table => :trees
  text :label
end

trees = DB[:trees]
toplevel_id = trees.insert(:label => "1")
second_level_a_id = trees.insert(:parent_id => toplevel_id, :label =>
"1:1")
second_level_b_id = trees.insert(:parent_id => toplevel_id, :label =>
"1:2")
third_level_a_id = trees.insert(:parent_id =>
second_level_a_id, :label => "1:1:1")

puts "**********  Table"
trees.print

class Tree < Sequel::Model
  many_to_one :parent
  one_to_many :children, :class => Tree, :key => :parent_id
end

puts "**********  Children of toplevel"
Tree[1].children.each do |child|
  p child.label
end
puts "**********  Children of toplevel through eager"
Tree.filter(:id => 1).eager(:children).all do |child|
  p child.label
end


It seems there is a problem with eager loading, or I didn't understand
the documentation.

Maz
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to