rails activerecord join查询 include 和 find_or_create find_or_initialize

最新推荐文章于 2021-01-26 04:42:18 发布

horace_lee

最新推荐文章于 2021-01-26 04:42:18 发布

阅读量160

点赞数

分类专栏： Ruby On Rails 文章标签： dynamic finder joins activerecord

本文链接：https://blog.csdn.net/horace_lee/article/details/84093515

版权

Ruby On Rails 专栏收录该内容

106 篇文章 0 订阅

订阅专栏

Student.joins(:schools).where(:schools => { :category => 'public' })
Student.joins(:schools).where('schools.category' => 'public' )


# No 'Summer' tag exists
Tag.find_or_create_by_name("Summer") # equal to Tag.create(:name => "Summer")

# Now the 'Summer' tag does exist
Tag.find_or_create_by_name("Summer") # equal to Tag.find_by_name("Summer")

# Now 'Bob' exist and is an 'admin'
User.find_or_create_by_name('Bob', :age => 40) { |u| u.admin = true }

小差别在于是否创建


winter = Tag.find_or_initialize_by_name("Winter")
winter.persisted? # false


productproperty = ProductProperty.find_or_create_by_product_id(product.id) { |u| u.property_id => property_id, u.value => d[descname] } )


conditions = { :product_id => product.id, 
               :property_id => property.id,
               :value => d[descname] }

pp = ProductProperty.find(:first, :conditions => conditions) || ProductProperty.create(conditions)


down vote


If you want to search by multiple attributes, you can use "and" to append them. For example:

productproperty = ProductProperty.find_or_create_by_product_id_and_property_id_and_value(:product_id => product.id, :property_id => property.id, :value => d[descname])

dynamic finder style