Module: NumericScopes::ClassMethods

Defined in:
lib/numeric_scopes.rb

Instance Method Summary collapse

Instance Method Details

#create_numeric_scopes ⇒ Object 



10
11
12
13
14
15
16
 
# File 'lib/numeric_scopes.rb', line 10

def create_numeric_scopes
  for column in columns
    if TYPES.any? { |type| column.sql_type.include?(type) }
      create_numeric_scopes_for_column(column.name)
    end
  end
end

#create_numeric_scopes_for_column(name) ⇒ Object 



18
19
20
21
22
23
24
25
26
27
28
 
# File 'lib/numeric_scopes.rb', line 18

def create_numeric_scopes_for_column(name)
  full_name = "#{quoted_table_name}.#{name}"
  scope :"#{name}_to", lambda { |value| where("#{full_name} <= ?", value) }
  scope :"#{name}_from", lambda { |value| where("#{full_name} >= ?", value) }
  scope :"#{name}_above", lambda { |value| where("#{full_name} > ?", value) }
  scope :"#{name}_below", lambda { |value| where("#{full_name} < ?", value) }
  scope :"#{name}_between", lambda { |from, to| where("#{full_name} BETWEEN ? AND ?", from, to) }
  scope :"#{name}_not_between", lambda { |from, to| where("#{full_name} BETWEEN ? AND ?", from, to) }
  scope :"#{name}_within", lambda { |from, to| where("#{full_name} > ? AND #{full_name} < ?", from, to) }
  scope :"#{name}_not_within", lambda { |from, to| where("#{full_name} <= ? OR #{full_name} >= ?", from, to) }
end