ruby-on-rails - 优化 ruby​​ on rails 查询

Question

我的应用在几个页面中有一张带有许多标记的 map 。

所以在我的 Controller 中，我将带有坐标的散列发送到 View 。

setups = current_user.setups
coordinates_hash = Hash.new { |hsh, key| hsh[key] = {} }
setups.each do |i|
  if i.address.lat != nil && i.address.long != nil
    lat = i.address.lat
    long = i.address.long
    coordinates_hash[i.setup_id].store 'lat', lat
    coordinates_hash[i.setup_id].store 'long', long
  end
end

所以在 View 中我收到了这个散列

var coordenadas = <%= raw(@coordinates_hash.to_json) %>;

如何优化这个流程？

Answer 1

关注@sergio 和 Guide Ruby on Rails您可以像这样更改代码

coordinates_hash = Hash.new { |hsh, key| hsh[key] = {} }

setups = current_user.setups.includes(:address)

setups.each do |i|
  if i.address.lat.present?  && i.address.long.present?
    coordinates_hash[i.setup_id].store 'lat', i.address.lat
    coordinates_hash[i.setup_id].store 'long',  i.address.long
  end
end

点击这里了解更多关于 ActiveRecord Eager Loading Associations Includes 的信息