Hi
I would like to know if there is a good way with minimal code to do a query
and transform to an array.
if I take the example Artist to Album. 1 Artist to many Albums . When I do
the query
artist = Artist.graph(:Albums, {:artist_id => :id}, :join_type =>
:inner).where(:album__sold = 21)
and when I do
puts artist.to_json
I would like the results to be:
[
...,
{ "id" : 1,
"name" : "artist name",
"age" : 20,
"Albums":[ {:id = 1, "name":"album_name", "sold":21}, {:id = 4,
"name":"album_name", "sold":21} ]
},
.....
]
At the moment I have to code and make sure I generate a json using the
columns in each model
e.g..
this is an example loop
result.each do |row|
:id = row[:id]
Artist.columns.each do |cl_name|
my_artist[:id][:cl_name] = row[:cl_name]
end
Album.columns.each do |cl_name|
my_album[:cl_name] = row[:cl_name]
end
my_artist[:id][:albums] << my_album # not totally correct but something
like that.
etc.......
I was hoping to just do artist.to_json or something similar.
Thanks,
--
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 post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/groups/opt_out.
