Class: FilterParam::Operators::Present

Inherits:
FieldFilterOperator show all
Defined in:
lib/filter_param/operators/present.rb

Class Method Summary collapse

Methods inherited from FieldFilterOperator

operand_data_type

Methods inherited from FilterParam::Operator

binaries, for, operator_tag, register, tag, type, unaries

Class Method Details

.negated_sql(field) ⇒ Object 



12
13
14
15
16
 
# File 'lib/filter_param/operators/present.rb', line 12

def self.negated_sql(field)
  return "#{field.actual_name} IS NULL" unless field.type == :string

  "(#{field.actual_name} IS NULL OR TRIM(#{field.actual_name}) = '')"
end

.sql(field) ⇒ Object 



6
7
8
9
10
 
# File 'lib/filter_param/operators/present.rb', line 6

def self.sql(field)
  return "#{field.actual_name} IS NOT NULL" unless field.type == :string

  "(#{field.actual_name} IS NOT NULL AND TRIM(#{field.actual_name}) != '')"
end