我有一个关于使用named_scopes的问题:
假设我有以下模型(我知道我提供的一些named_scope可以通过active record直接实现,但它们只是为了示例):
def person
named_scope :older_then, lambda {|min_age| {:conditions => ["age > ?",min_age]} }
named_scope :by_first_name, lambda {|name| {:conditions => {:first_name => name}}}
def self.some_function(age_param, name_param)
chain = Person
chain = chain.older_then(age_param) unless age_param.blank?
chain = chain.by_first_name(name_param) unless name_param.blank?
chain.all
end
end现在假设我想要调用:
people = Person.some_function(20, "john")在构建named_scopes链时,Rails将对数据库进行两次调用:
select * from persons where age>20
select * from persons where age>20 and name='john'显然,我只想要第二个查询的结果,并不打算在构建named_scopes链时执行第一个查询。你知道我在这里做错了什么吗/按条件组合多个named_scope的正确方法是什么?
顺便说一句,我用的是Ruby 1.8.7,这是旧的,我知道...:(
发布于 2013-04-05 00:26:19
更改此设置:
def self.some_function(age_param, name_param)
chain = Person至:
def self.some_function(age_param, name_param)
chain = self这将保持原始链的完整,而不是开始一个新的链。
https://stackoverflow.com/questions/15806820
复制相似问题