Module: DB::Model::Statement::Predicate

Defined in:

lib/db/model/statement/predicate.rb

Defined Under Namespace

Classes: Between, Binary, Composite, Empty, Null

Constant Summary

EMPTY =

Empty.new

Class Method Summary

• .coerce(key, value) ⇒ Object
• .where(*arguments, **options, &block) ⇒ Object

Class Method Details

.coerce(key, value) ⇒ Object

# File 'lib/db/model/statement/predicate.rb', line 160

def self.coerce(key, value)
  case value
  when Array
    Binary.new(key, "IN", Tuple.new(value))
  when Range
    if value.min.nil?
      if value.exclude_end?
        Binary.new(key, "<", Literal.new(value.max))
      else
        Binary.new(key, "<=", Literal.new(value.max))
      end
    elsif value.max.nil?
      if value.exclude_end?
        Binary.new(key, ">", Literal.new(value.max))
      else
        Binary.new(key, ">=", Literal.new(value.max))
      end
    else
      if value.exclude_end?
        Composite.new([
          Binary.new(key, ">", Literal.new(value.min)),
          Binary.new(key, "<", Literal.new(value.max))
        ])
      else
        Between.new(key, Literal.new(value.min), Literal.new(value.max))
      end
    end
  when nil
    Null.new(key)
  else
    Binary.new(key, "=", Literal.new(value))
  end
end

.where(*arguments, **options, &block) ⇒ Object

# File 'lib/db/model/statement/predicate.rb', line 194

def self.where(*arguments, **options, &block)
  Composite.for(
    options.map do |key, value|
      coerce(Identifier.coerce(key), value)
    end
  )
end