#15 Fun with Find Conditions

iteye_19623

于 2008-12-03 09:50:34 发布

阅读量125

点赞数

CC 4.0 BY-SA版权

分类专栏： Railscasts

本文链接：https://blog.youkuaiyun.com/iteye_19623/article/details/81650987

Railscasts 专栏收录该内容

108 篇文章

订阅专栏

本文介绍在Rails中如何使用复杂的查询条件进行数据库检索，包括数组、范围及空值等特殊类型的条件设置方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

You can pass more than simple strings to find conditions. Arrays, ranges, and nil values can be passed as well. In this episode you will see the tricks involved with passing these odd objects to find conditions. (Update: audio fixed).

Task.find(:all, :conditions => ["complete=? and priority=?", false, 3])
Task.find(:all, :conditions => ["complete=? and priority IS ?", false, nil])
Task.find(:all, :conditions => ["complete=? and priority IN (?)", false, [1,3]])
Task.find(:all, :conditions => ["complete=? and priority IN (?)", false, 1..3])

Task.find(:all, :conditions => { :complete => false, :priority => 1 })
Task.find(:all, :conditions => { :complete => false, :priority => nil })
Task.find(:all, :conditions => { :complete => false, :priority => [1,3] })
Task.find(:all, :conditions => { :complete => false, :priority => 1..3 })

Task.find_all_by_priority(1..3)