Module: Sequel::SQL::PatternMatchMethods
- Included in:
- ComplexExpression, GenericExpression, StringAgg
- Defined in:
- lib/sequel/sql.rb
Overview
This module includes methods for overriding the =~ method for SQL equality, inclusion, and pattern matching. It returns the same result that Sequel would return when using a hash with a single entry, where the receiver was the key and the argument was the value. Example:
Sequel[:a] =~ 1 # (a = 1)
Sequel[:a] =~ [1, 2] # (a IN [1, 2])
Sequel[:a] =~ nil # (a IS NULL)
This also adds the !~ method, for easily setting up not equals, exclusion, and inverse pattern matching. This is the same as as inverting the result of the =~ method
Sequel[:a] !~ 1 # (a != 1)
Sequel[:a] !~ [1, 2] # (a NOT IN [1, 2])
Sequel[:a] !~ nil # (a IS NOT NULL)
Instance Method Summary collapse
- #!~(other) ⇒ Object
-
#=~(other) ⇒ Object
Set up an equality, inclusion, or pattern match operation, based on the type of the argument.
Instance Method Details
#!~(other) ⇒ Object
835 836 837 |
# File 'lib/sequel/sql.rb', line 835 def !~(other) ~(self =~ other) end |
#=~(other) ⇒ Object
Set up an equality, inclusion, or pattern match operation, based on the type of the argument.
831 832 833 |
# File 'lib/sequel/sql.rb', line 831 def =~(other) BooleanExpression.send(:from_value_pair, self, other) end |