Class: Arel::Visitors::IBM_DB

Inherits:
Object
  • Object
show all
Defined in:
lib/arel_extensions/visitors/ibm_db.rb

Instance Method Summary collapse

Instance Method Details

#visit_ArelExtensions_Nodes_Ceil(o, collector) ⇒ Object 



5
6
7
8
9
10
 
# File 'lib/arel_extensions/visitors/ibm_db.rb', line 5

def visit_ArelExtensions_Nodes_Ceil o, collector
  collector << "CEILING("
  collector = visit o.expr, collector
  collector << ")"
  collector
end

#visit_ArelExtensions_Nodes_DateDiff(o, collector) ⇒ Object 



23
24
25
26
27
28
29
30
31
32
33
34
 
# File 'lib/arel_extensions/visitors/ibm_db.rb', line 23

def visit_ArelExtensions_Nodes_DateDiff o, collector
  collector << "DAY("
  collector = visit o.left, collector
  collector << ","
  if o.right.is_a?(Arel::Attributes::Attribute)
    collector = visit o.right, collector
  else
    collector << "'#{o.right}'"
  end
  collector << ")"
  collector
end

#visit_ArelExtensions_Nodes_Duration(o, collector) ⇒ Object 



37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
 
# File 'lib/arel_extensions/visitors/ibm_db.rb', line 37

def visit_ArelExtensions_Nodes_Duration o, collector
  #visit left for period
  if o.left == "d"
    collector << "DAY("
  elsif o.left == "m"
    collector << "MONTH("
  elsif o.left == "w"
    collector << "WEEK"
  elsif o.left == "y"
    collector << "YEAR("
  end
  #visit right
  if o.right.is_a?(Arel::Attributes::Attribute)
    collector = visit o.right, collector
  else
    collector << "'#{o.right}'"
  end
  collector << ")"
  collector
end

#visit_ArelExtensions_Nodes_IsNull(o, collector) ⇒ Object 



59
60
61
62
63
64
65
66
67
68
69
70
 
# File 'lib/arel_extensions/visitors/ibm_db.rb', line 59

def visit_ArelExtensions_Nodes_IsNull o, collector
  collector << "COALESCE("
  collector = visit o.left, collector
  collector << ","
  if(o.right.is_a?(Arel::Attributes::Attribute))
    collector = visit o.right, collector
  else
    collector << "'#{o.right}'"
  end
  collector << ")"
  collector
end

#visit_ArelExtensions_Nodes_Trim(o, collector) ⇒ Object 



12
13
14
15
16
17
18
19
20
 
# File 'lib/arel_extensions/visitors/ibm_db.rb', line 12

def visit_ArelExtensions_Nodes_Trim o, collector
  collector << "LTRIM(RTRIM("
  o.expressions.each_with_index { |arg, i|
    collector << Arel::Visitors::IBM_DB::COMMA unless i == 0
    collector = visit arg, collector
  }
  collector << "))"
  collector
end