RailsWhere可以让代码变得更简洁。
?
看一下插件的自述文件。
=== Returning SQL sql = Where.new('x=?',5).and( Where.new('x=?',6).or('x=?',7)).to_s # returns (x=5) and ( (x=6) or (x=7) ) === Building a complicated where clause made easy def get_search_query_string where = Where.new where.and('users.first_name like ?', params[:search_first_name] + '%') unless params[:search_first_name].blank? where.and('users.last_name like ?', params[:search_last_name] + '%') unless params[:search_last_name].blank? status_where = Where.new for status in params[search_statuses].split(',') status_where.or 'status=?', status end where.and status_where unless status_where.blank? where.to_s end User.find(:all, :conditions => get_search_query_string) === Inline User.find(:all, :conditions => Where.new('first_name like ?', 'Tim').and('last_name like ?', 'Harper'))
# RAILS_ROOT/vendor/railswhere/lib/where.rb # 2.2.2 @criteria = ActiveRecord::Base.send(:sanitize_sql_array, criteria) # 2.3.4 @criteria = ActiveRecord::Base.send(:sanitize_sql_array, criteria, nil)?