Class: Sequel::SQL::DateAdd

Inherits:
GenericExpression show all
Defined in:
lib/sequel/extensions/date_arithmetic.rb

Overview

The DateAdd class represents the addition of an interval to a date/timestamp expression.

Defined Under Namespace

Modules: DatasetMethods

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from Postgres::HStoreOpMethods

#hstore

Methods included from Postgres::RangeOpMethods

#pg_range

Methods included from Postgres::ArrayOpMethods

#pg_array

Methods included from Postgres::JSONOpMethods

#pg_json, #pg_jsonb

Methods included from Postgres::PGRowOp::ExpressionMethods

#pg_row

Methods included from SubscriptMethods

#sql_subscript

Methods included from StringMethods

#ilike, #like

Methods included from OrderMethods

#asc, #desc

Methods included from NumericMethods

#+

Methods included from ComplexExpressionMethods

#extract, #sql_boolean, #sql_number, #sql_string

Methods included from CastMethods

#cast, #cast_numeric, #cast_string

Methods included from BooleanMethods

#~

Methods included from AliasMethods

#as

Methods inherited from Expression

#==, attr_reader, #eql?, #hash, inherited, #inspect, #lit, #sql_literal

Constructor Details

#initialize(expr, interval) ⇒ DateAdd

Supports two types of intervals:

Hash

Used directly, but values cannot be plain strings.

ActiveSupport::Duration

Converted to a hash using the interval’s parts.



169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
 
# File 'lib/sequel/extensions/date_arithmetic.rb', line 169

def initialize(expr, interval)
  @expr = expr
  @interval = if interval.is_a?(Hash)
    interval.each_value do |v|
       # Attempt to prevent SQL injection by users who pass untrusted strings
       # as interval values. 
       if v.is_a?(String) && !v.is_a?(LiteralString)
         raise Sequel::InvalidValue, "cannot provide String value as interval part: #{v.inspect}"
       end
    end
    interval
  else
    h = Hash.new(0)
    interval.parts.each{|unit, value| h[unit] += value}
    {}.merge(h)
  end
end

Instance Attribute Details

#expr ⇒ Object (readonly)

The expression that the interval is being added to.



160
161
162
 
# File 'lib/sequel/extensions/date_arithmetic.rb', line 160

def expr
  @expr
end

#interval ⇒ Object (readonly)

The interval added to the expression, as a hash with symbol keys.



164
165
166
 
# File 'lib/sequel/extensions/date_arithmetic.rb', line 164

def interval
  @interval
end