ruby – 在Sequel中检索嵌套记录

DB = Sequel.sqlite('database.sqlite')

DB.create_table? :artists do
    primary_key     :id
    String          :name
end

DB.create_table? :albums do
    primary_key     :id
    String          :title
    foreign_key     :artist_id,:artists,:key => :id
end

artists = DB[:artists]
albums = DB[:albums]

id1 = artists.insert(:name => 'Mike')
id2 = artists.insert(:name => 'John')

albums.insert(:title => 'Only You',:artist_id => id1 )
albums.insert(:title => 'Only Us',:artist_id => id1 )
albums.insert(:title => 'Only Me',:artist_id => id2 )

我想要的输出 –

[
  {
    :id => 1,:name => 'Mike'
    :albums => [
      {
        :id => 1,:title => 'Only You'
      },{
        :id => 2,:title => 'Only Us'
      }
    ]
  },{
    :id => 2,:name => 'John'
    :albums => [
      {
        :id => 3,:title => 'Only Me'
      }
    ]
  }
]

我试过’急切’加载 –

class Artist < Sequel::Model(:artists)
  one_to_many  :db[:albums],:key => :artist_id
end

class Album < Sequel::Model(:albums)
  many_to_one  :artist,:key => :artist_id
end


Artist.eager(:albums).all{ |a| p a }

但那没用.

谁能指出我正确的方向？