Module: BlindDate::ActiveRecord::ConnectionAdapters::SQLiteAdapter::ClassMethods

Defined in:
lib/blind_date/active_record/connection_adapters/sqlite_adapter.rb

Instance Method Summary collapse

Instance Method Details

#date_add_sql(style, sql, interval, unit, operator) ⇒ Object 



6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
# File 'lib/blind_date/active_record/connection_adapters/sqlite_adapter.rb', line 6

def date_add_sql( style, sql, interval, unit, operator )
  date_function = case style
    when :date then 'DATE'
    when :datetime then 'DATETIME'
    when :time then 'TIME'
  end
  case interval
    when Numeric
      "#{date_function}( #{sql}, '#{operator}#{interval} #{unit}' )"
    when String
      "#{date_function}( #{sql}, '#{operator}' || #{interval} || ' #{unit}' )"
    else
      raise ArgumentError
  end
end