Module: Sequel::SQL::ComplexExpressionMethods

Included in:
Dataset, LiteralString, GenericExpression, Symbol
Defined in:
lib/sequel/sql.rb

Overview

Adds methods that allow you to treat an object as an instance of a specific ComplexExpression subclass. This is useful if another library overrides the methods defined by Sequel.

For example, if Symbol#/ is overridden to produce a string (for example, to make file system path creation easier), the following code will not do what you want:

:price/10 > 100

In that case, you need to do the following:

:price.sql_number/10 > 100

Instance Method Summary (collapse)

Instance Method Details

- (Object) extract(datetime_part)

Extract a datetime part (e.g. year, month) from self:

:date.extract(:year) # extract(year FROM "date")

Also has the benefit of returning the result as a NumericExpression instead of a generic ComplexExpression.



721
722
723
# File 'lib/sequel/sql.rb', line 721

def extract(datetime_part)
  NumericExpression.new(:extract, datetime_part, self)
end

- (Object) sql_boolean

Return a BooleanExpression representation of self.



726
727
728
# File 'lib/sequel/sql.rb', line 726

def sql_boolean
  BooleanExpression.new(:NOOP, self)
end

- (Object) sql_number

Return a NumericExpression representation of self.

~:a # NOT "a"
~:a.sql_number # ~"a"


734
735
736
# File 'lib/sequel/sql.rb', line 734

def sql_number
  NumericExpression.new(:NOOP, self)
end

- (Object) sql_string

Return a StringExpression representation of self.

:a + :b # "a" + "b"
:a.sql_string + :b # "a" || "b"


742
743
744
# File 'lib/sequel/sql.rb', line 742

def sql_string
  StringExpression.new(:NOOP, self)
end