我有两个模型,我想通过我的搜索表单搜索

<%= form_tag({:controller => 'search', :action => 'search'}, {:method => 'get', :remote => true })  do |select| %>
<%= label_tag :search, "Enter Keywords Here" %>
<%= text_field_tag :search, params[:search] %>

<%= label_tag :country, "Search by Country" %>
<%= collection_select(:country, :country_id, Country.all, :id, :name, :prompt => 'Please Select') %>

<%= label_tag :difficulty, "Search by Difficulty" %>
<%= select_tag :difficulty, options_for_select([['Beginner'],['Intermediate'],['Expert']]), {:prompt => 'Please Select'} %>

<%= label_tag :preperation_time, "Search by preperation time" %>
<%= select_tag :preperation_time, options_for_select([['15..30'],['30..60'],['60..120']]), {:prompt => 'Please Select'} %><br>

<%= submit_tag "Search", :class => "searchbutton" %>
<% end %>

我的理解是,如果我想搜索所有列,我的sql语句应该如下所示
SELECT column dish_name, difficulty, preparation_time FROM Recipe LEFT JOIN Country ON Recipe.dish_name = Country.name AND Recipe.difficulty = Country.name AND Recipe.preparation_time = Country.name

这可能是完全错误的想法,我想实现的是能够搜索一个参数或最多4个
我不知道如何把它转换成rails语法,目前我已经
q = "%#{params[:search]}%"
@countrysearch = Recipe.includes(:country).where("dish_name LIKE ? OR countries.name LIKE ? OR difficulty LIKE ? OR preperation_time LIKE?", q, q, q,q )

如果有人能指点我正确的方向,我将不胜感激

最佳答案

不朽的
如果您想更好地了解如何使用此方法调用,可以始终使用to_sql来打印生成的SQL查询。
您还可以在控制台和导轨除气的日志中进行检查。
左连接示例

@result = Recipe.joins("LEFT OUTER JOIN countries ON countries.id = recipes.country_id").select

但也有可能,最好是做你现在的工作
@result = Recipe.includes(:country)

打印查询
puts @result.to_sql

生成查询
countrysearch = Recipe.includes(:country).arel_table
countrysearch = countrysearch.or(countrysearch[:country].eq(params[:search][:country])) if params[:search].has_key?(:country)
#...
countrysearch = countrysearch.or(countrysearch[:difficulty].eq(params[:search][:difficulty])) if params[:search].has_key?(:difficulty)

工具书类
请检查以下参考资料中的备选方案:
rails/arel
215: Advanced Queries in Rails 3
希望这对你有帮助!!

10-05 20:32
查看更多