Class: Chicago::Flow::MysqlFileSerializer

Inherits:
Object
  • Object
show all
Defined in:
lib/chicago/flow/mysql_file_serializer.rb

Instance Method Summary collapse

Instance Method Details

#serialize(value) ⇒ Object

Transforms a value to be suitable for use in file in a LOAD DATA INFILE mysql statement.



8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
 
# File 'lib/chicago/flow/mysql_file_serializer.rb', line 8

def serialize(value)
  case value
  when nil
    "NULL"
  when true
    "1"
  when false
    "0"
  when Time, DateTime
    value.strftime("%Y-%m-%d %H:%M:%S")
  when Date
    value.strftime("%Y-%m-%d")
  else
    value
  end
end