使用chained where时ActiveRecord未过滤

Question

  # Get only non-empty reviews
  query = Review.where("content <> ''")

  # filter on status (unreviewed, reviewed, flagged, etc), if provided
  if (status)
    query.where("status = ?", status)
  end

  # Order rows
  query.order("created_on ASC")

  # iterate, this should fire the query
  reviews = query.each_with_object([]) do |review, a|

我的问题是我的查询没有过滤'status‘。我再次检查了我的代码是否在if语句中。我甚至走到了这样的程度：

  # Get only non-empty reviews
  query = Review.where("content <> ''")

  # filter on status (unreviewed, reviewed, flagged, etc), if provided
  query.where("status = ?", status)

我确信我做错了什么，但我不知道

Answer 1

就是找到了。每次都需要分配查询

  # Get only non-empty reviews
  query = Review.where("content <> ''")

  # filter on status (unreviewed, reviewed, flagged, etc), if provided
  query.where("status = ?", status)