#354 Squeel

May 30, 2012 | 9 minutes | Active Record, Plugins, Search

Squeel provides a comprehensive DSL for writing SQL queries in Ruby. It is built upon Arel giving you access to many of its powerful features.

Click to Play Video ▶

Download:
source codeProject Files in Zip (75.5 KB)
mp4Full Size H.264 Video (34.1 MB)
m4vSmaller H.264 Video (14.2 MB)
webmFull Size VP8 Video (13.6 MB)
ogvFull Size Theora Video (36.6 MB)

Browse Source Code

Resources

Squeel

          terminal
        
rails g squeel:initializer
rails c

          rails console
        
Product.where{released_at < 3.months.ago}
Product.where{released_at.lt 3.months.ago}
Product.where{released_at.lt(3.months.ago) & price.gt(20)}
Product.where{released_at.lt(3.months.ago) | price.gt(20)}

          models/product.rb
        
def self.search(query)
  where do
    (released_at <= Time.zone.now) &
    ((discontinued_at == nil) | (discontinued_at > Time.zone.now)) &
    (stock >= my{low_stock}) & (name =~ "%#{query}%")
  end
end

def self.low_stock
  2
end