Merging API data and ActiveRecord data for display in the view

Hi there,

I’m trying to merge JSON results from an API call in with ActiveRecord
results for a blended display in a view. I’d like to be able to merge
the two result sets based on ‘created_at’ which is is common in both
the ActiveRecord results and the JSON results from the API. Created_at
is the only common element between the two data sets.

Here’s what I have in my controller for retrieving the data:

@diary = current_user.diary(params[:page])
start_date = @diary.first.created_at.to_s(:date_query)
end_date = @diary.last.created_at.to_s(:date_query)
@tweets = JSON.parse(Net::HTTP.get(URI.parse(“http://
search.twitter.com/search.json?from=#{current_user.twitter_name}
&since=#{start_date}&until=#{end_date}”)))
@tweets = @tweets[‘results’]
@blend = @diary.entries.concat(@tweets) # tried something like this…
Not sure this is the best way to go

What’s the best way to merge these two results and sort them by
'created_at for display given that
they are so different? Should I do this in the controller or the
view? Any guidance or example would be greatly
appreciated.

Thanks!

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs