Hi all,
i am a new rubiest. Started exploring rails recently.
Here is my problem
i am trying to get objects from my custom database and render them as json objects.
This is how tried. In my controller.
def near begin @lat = params[:lat] @lon = params[:lon] @near_ids =
def get_id(dist_var)
@near_ids = Brand.find_by_sql("#Long query to find nearest stores around the given latlon ")
puts 'Total id :'+@near_ids.length.to_s
puts 'distance :'+dist_var.to_s
end
get_id(dist = 1)
while(@near_ids.length < 10)
dist +=5
get_id(dist)
end
@stores = []
@near_ids.each do |store|
@stores << Store.find_by_id(store["id"])
end
@user = @stores.paginate(:page => params[:page], :per_page => 10 )
rescue ActiveRecord::RecordNotFound
render json: 'Not found', status: 404
end
end
``
But i know it is not the right way to do it in rails.
how can i achieve this in rails way.? Mean using models how can i query my database to return the needed objects to my controller.?
i use jbuilder to render returned id’s as json.