English 中文(简体)
我如何利用我模式中针对一系列项目的指定范围?
原标题:How can I use a named scope in my model against an array of items?

我知道,我可以问一下,根据一阵列编制的最新书籍。

www.un.org/Depts/DGACM/index_french.htm{:conditions=>{:created_at >= since_d><>>/code

但是,如果我有一系列项目,例如,如果我想知道,是否有与日期相匹配的记录[日期1、日期2、日期3等],那么我怎么能做同样的询问。

我认为,必须采用一种收集/选择/选择/地图的方法,但我并不相信,从阅读这些方法来看,这种方法会失败。

最佳回答

如果你通过一个阵列作为价值,那么积极记录就足以比较列入阵列。 例如,

Book.where(:author_id => [1, 7, 42])

produces a SQL query with a WHERE clause similar to:

WHERE "author_id" IN (1, 7, 42)

可在<条码>范围内中加以利用。 您将规定正常条件:

class Book < ....
  # Rails 3
  scope :by_author, lambda { |author_id| where(:author_id => author_id) }

  # Rails 2
  named_scope :by_author, lambda { |author_id
    { :conditions => {:author_id => author_id} }
  }
end

之后,您可以通过一个单独的身份证或一系列的身份证进入by_author <>/code>,然后才能工作:

Book.by_author([1,7,42])
问题回答

在铁路4号,我可以通过使用类似范围来检查在阵列中添加插座:

scope :news, -> { where(:categories =>  {news} ) }

Or with an argument:

scope :by_category, ->(category) { where(:categories => "{#{category}}") }




相关问题
rails collection_select vs. select

collection_select and select Rails helpers: Which one should I use? I can t see a difference in both ways. Both helpers take a collection and generates options tags inside a select tag. Is there a ...

SSL slowness in EC2

We ve deployed our rails app to EC2. In our setup, we have two proxies on small instances behind round-robin DNS. These run nginx load balancers for a dynamically growing and shrinking farm of web ...

Auth-code with A-Za-z0-9 to use in an URL parameter

As part of a web application I need an auth-code to pass as a URL parameter. I am currently using (in Rails) : Digest::SHA1.hexdigest((object_id + rand(255)).to_s) Which provides long strings like : ...

RubyCAS-Client question: Rails

I ve installed RubyCAS-Client version 2.1.0 as a plugin within a rails app. It s working, but I d like to remove the ?ticket= in the url. Is this possible?

activerecord has_many :through find with one sql call

I have a these 3 models: class User < ActiveRecord::Base has_many :permissions, :dependent => :destroy has_many :roles, :through => :permissions end class Permission < ActiveRecord::...

Ordering a hash to xml: Rails

I m building an xml document from a hash. The xml attributes need to be in order. How can this be accomplished? hash.to_xml

Text Editor for Ruby-on-Rails

guys which text editor is good for Rubyonrails? i m using Windows and i was using E-Texteditor but its not free n its expired now can anyone plese tell me any free texteditor? n which one is best an ...

How to get SQL queries for each user where env is production

I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...