Class: Sequel::SQL::ComplexExpression
- Inherits:
-
Expression
- Object
- Expression
- Sequel::SQL::ComplexExpression
- Includes:
- AliasMethods, CastMethods, OrderMethods, SubscriptMethods
- Defined in:
- lib/sequel/lib/sequel/sql.rb,
lib/sequel/lib/sequel/sql.rb
Overview
Represents a complex SQL expression, with a given operator and one or more attributes (which may also be ComplexExpressions, forming a tree). This class is the backbone of the blockless filter support in Sequel.
This is an abstract class that is not that useful by itself. The subclasses BooleanExpression, NumericExpression, and StringExpression define the behavior of the DSL via operators.
Direct Known Subclasses
BooleanExpression, GenericComplexExpression, NumericExpression, StringExpression
Constant Summary collapse
- OPERTATOR_INVERSIONS =
A hash of the opposite for each operator symbol, used for inverting objects.
{:AND => :OR, :OR => :AND, :< => :>=, :> => :<=, :<= => :>, :>= => :<, :'=' => :'!=' , :'!=' => :'=', :LIKE => :'NOT LIKE', :'NOT LIKE' => :LIKE, :~ => :'!~', :'!~' => :~, :IN => :'NOT IN', :'NOT IN' => :IN, :IS => :'IS NOT', :'IS NOT' => :IS, :'~*' => :'!~*', :'!~*' => :'~*', :NOT => :NOOP, :NOOP => :NOT, :ILIKE => :'NOT ILIKE', :'NOT ILIKE'=>:ILIKE}
- MATHEMATICAL_OPERATORS =
Mathematical Operators used in NumericMethods
[:+, :-, :/, :*]
- BITWISE_OPERATORS =
Mathematical Operators used in NumericMethods
[:&, :|, :^, :<<, :>>]
- INEQUALITY_OPERATORS =
Inequality Operators used in InequalityMethods
[:<, :>, :<=, :>=]
- BOOLEAN_OPERATOR_METHODS =
Hash of ruby operator symbols to SQL operators, used in BooleanMethods
{:& => :AND, :| =>:OR}
- IS_OPERATORS =
Operators that use IS, used for special casing to override literal true/false values
[:IS, :'IS NOT']
- TWO_ARITY_OPERATORS =
Operator symbols that take exactly two arguments
[:'=', :'!=', :LIKE, :'NOT LIKE', \ :~, :'!~', :'~*', :'!~*', :IN, :'NOT IN', :ILIKE, :'NOT ILIKE'] + \ INEQUALITY_OPERATORS + BITWISE_OPERATORS + IS_OPERATORS
- N_ARITY_OPERATORS =
Operator symbols that take one or more arguments
[:AND, :OR, :'||'] + MATHEMATICAL_OPERATORS
- ONE_ARITY_OPERATORS =
Operator symbols that take one argument
[:NOT, :NOOP, :'B~']
Instance Attribute Summary collapse
-
#args ⇒ Object
readonly
An array of args for this object.
-
#op ⇒ Object
readonly
The operator symbol for this object.
Instance Method Summary collapse
-
#eql?(other) ⇒ Boolean
(also: #==)
Returns true if the receiver is the same expression as the the
other
expression. -
#initialize(op, *args) ⇒ ComplexExpression
constructor
Set the operator symbol and arguments for this object to the ones given.
Methods included from SubscriptMethods
Methods included from OrderMethods
Methods included from CastMethods
#cast, #cast_numeric, #cast_string
Methods included from AliasMethods
Methods inherited from Expression
Constructor Details
#initialize(op, *args) ⇒ ComplexExpression
Set the operator symbol and arguments for this object to the ones given. Convert all args that are hashes or arrays with all two pairs to BooleanExpressions. Raise an error if the operator doesn't allow boolean input and a boolean argument is given. Raise an error if the wrong number of arguments for a given operator is used.
95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 |
# File 'lib/sequel/lib/sequel/sql.rb', line 95 def initialize(op, *args) args.map!{|a| Sequel.condition_specifier?(a) ? SQL::BooleanExpression.from_value_pairs(a) : a} case op when *N_ARITY_OPERATORS raise(Error, "The #{op} operator requires at least 1 argument") unless args.length >= 1 when *TWO_ARITY_OPERATORS raise(Error, "The #{op} operator requires precisely 2 arguments") unless args.length == 2 when *ONE_ARITY_OPERATORS raise(Error, "The #{op} operator requires a single argument") unless args.length == 1 else raise(Error, "Invalid operator #{op}") end @op = op @args = args end |
Instance Attribute Details
#args ⇒ Object (readonly)
An array of args for this object
86 87 88 |
# File 'lib/sequel/lib/sequel/sql.rb', line 86 def args @args end |
#op ⇒ Object (readonly)
The operator symbol for this object
89 90 91 |
# File 'lib/sequel/lib/sequel/sql.rb', line 89 def op @op end |
Instance Method Details
#eql?(other) ⇒ Boolean Also known as: ==
Returns true if the receiver is the same expression as the the other
expression.
113 114 115 |
# File 'lib/sequel/lib/sequel/sql.rb', line 113 def eql?(other) other.is_a?(self.class) && @op.eql?(other.op) && @args.eql?(other.args) end |