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!