Class: Sequel::SQL::CaseExpression

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

Overview

Represents an SQL CASE expression, used for conditional branching in SQL.

Instance Attribute Summary collapse

Instance Method Summary collapse

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, comparison_attrs, #eql?, #hash, #inspect, #lit, #sql_literal

Constructor Details

#initialize(conditions, default, expression = (no_expression=true; nil)) ⇒ CaseExpression

Create an object with the given conditions and default value. An expression can be provided to test each condition against, instead of having all conditions represent their own boolean expression.

Raises:



644
645
646
647
 
# File 'lib/sequel/sql.rb', line 644

def initialize(conditions, default, expression=(no_expression=true; nil))
  raise(Sequel::Error, 'CaseExpression conditions must be a hash or array of all two pairs') unless Sequel.condition_specifier?(conditions)
  @conditions, @default, @expression, @no_expression = conditions.to_a, default, expression, no_expression
end

Instance Attribute Details

#conditions ⇒ Object (readonly)

An array of all two pairs with the first element specifying the condition and the second element specifying the result if the condition matches.



632
633
634
 
# File 'lib/sequel/sql.rb', line 632

def conditions
  @conditions
end

#default ⇒ Object (readonly)

The default value if no conditions match.



635
636
637
 
# File 'lib/sequel/sql.rb', line 635

def default
  @default
end

#expression ⇒ Object (readonly)

The expression to test the conditions against



638
639
640
 
# File 'lib/sequel/sql.rb', line 638

def expression
  @expression
end

Instance Method Details

#expression? ⇒ Boolean

Whether to use an expression for this CASE expression.

Returns:

  • (Boolean) 


650
651
652
 
# File 'lib/sequel/sql.rb', line 650

def expression?
  !@no_expression
end