Class: Rgviz::MySqlAdapter

Inherits:
Object
  • Object
show all
Defined in:
lib/rgviz_rails/adapters/mysql_adapter.rb

Instance Method Summary collapse

Instance Method Details

#accept_scalar_function_column(node, visitor) ⇒ Object 



3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
 
# File 'lib/rgviz_rails/adapters/mysql_adapter.rb', line 3

def accept_scalar_function_column(node, visitor)
  case node.function
  when ScalarFunctionColumn::Year
    visitor << "year("
    node.arguments[0].accept visitor
    visitor << ")"
  when ScalarFunctionColumn::Month
    visitor << "month("
    node.arguments[0].accept visitor
    visitor << ")"
  when ScalarFunctionColumn::Day
    visitor << "day("
    node.arguments[0].accept visitor
    visitor << ")"
  when ScalarFunctionColumn::Hour
    visitor << "hour("
    node.arguments[0].accept visitor
    visitor << ")"
  when ScalarFunctionColumn::Minute
    visitor << "minute("
    node.arguments[0].accept visitor
    visitor << ")"
  when ScalarFunctionColumn::Second
    visitor << "second("
    node.arguments[0].accept visitor
    visitor << ")"
  when ScalarFunctionColumn::Millisecond
    raise NotSupported.new("The millisecond function is not supported")
  when ScalarFunctionColumn::Quarter
    visitor << "quarter("
    node.arguments[0].accept visitor
    visitor << ")"
  when ScalarFunctionColumn::DayOfWeek
    visitor << "dayofweek("
    node.arguments[0].accept visitor
    visitor << ")"
  when ScalarFunctionColumn::Now
    visitor << "now()"
  when ScalarFunctionColumn::DateDiff
    visitor << "datediff("
    node.arguments[0].accept visitor
    visitor << ","
    node.arguments[1].accept visitor
    visitor << ")"
  when ScalarFunctionColumn::ToDate
    visitor << "date_format("
    node.arguments[0].accept visitor
    visitor << ", '%Y-%m-%d')"
  when ScalarFunctionColumn::Upper
    visitor << "upper("
    node.arguments[0].accept visitor
    visitor << ")"
  when ScalarFunctionColumn::Lower
    visitor << "lower("
    node.arguments[0].accept visitor
    visitor << ")"
  when ScalarFunctionColumn::Concat
    visitor << "concat("
    node.arguments.each_with_index do |arg, i|
      visitor << ", " if i > 0
      arg.accept visitor
    end
    visitor << ")"
  end
end

#visit_date_column(node, visitor) ⇒ Object 



69
70
71
 
# File 'lib/rgviz_rails/adapters/mysql_adapter.rb', line 69

def visit_date_column(node, visitor)
  visitor << "date #{visitor.escaped_string(node.value.strftime("%Y-%m-%d"))}"
end

#visit_date_time_column(node, visitor) ⇒ Object 



73
74
75
 
# File 'lib/rgviz_rails/adapters/mysql_adapter.rb', line 73

def visit_date_time_column(node, visitor)
  visitor << "timestamp #{visitor.escaped_string(node.value.strftime("%Y-%m-%d %H:%M:%S"))}"
end

#visit_time_of_day_column(node, visitor) ⇒ Object 



77
78
79
 
# File 'lib/rgviz_rails/adapters/mysql_adapter.rb', line 77

def visit_time_of_day_column(node, visitor)
  visitor << "time #{visitor.escaped_string(node.value.strftime("%H:%M:%S"))}"
end