AR DRY scoping of the nested models

dry_scope.rb

class Collection < ActiveRecord::Base
  has_many :products
  scope :live,  where("collections.end_date IS NOT NULL AND collections.end_date >= ?", Time.now.to_date)
end

class Product < ActiveRecord::Base
  belongs_to :collection
  
  # how to DRY this .where ?
  scope :launched, joins(:collection).where("collections.end_date IS NOT NULL AND collections.end_date >= ?", Time.now.to_date)
end

# usage:
Product.launched
# Product scope which belongs_to Collection.live

Hmm... mislim da bi ovo moglo biti dobro:

class Product < ActiveRecord::Base
  belongs_to :collection

  scope :launched, joins(:collection).where(collections: {id: Collection.live.pluck(:id)})
end

Btw, znaš da trebaš koristiti lambde za scopeove? Pogotovo jer koristiš Time.now, on će ti se evaluateati samo jednom kad ti se klasa loada.

Našao! :)

scope :launched, joins(:collection).merge(Collection.live)

Btw, zakon post: http://blog.mitchcrowe.com/blog/2012/04/14/10-most-underused-activerecord-relation-methods/

eh, činilo mi se da mora bit tako nešto ... thx, častim kavom u subotu :)

da, znam za lambda, ali, naravno da smetnem s uma kad najviše treba ... :-)