Sha256: a0339d21462a8d3e0e17319d93ee38999c1d833585122a98067f982b8064edb3

Contents?: true

Size: 515 Bytes

Versions: 5

Compression:

Stored size: 515 Bytes

Contents

module Chicago
  module ETL
    class MysqlLoadFileValueTransformer
      # Transforms a value to be suitable for use in file in a LOAD
      # DATA INFILE mysql statement.
      def transform(value)
        case value
        when nil
          "\\N"
        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
    end
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version Path
chicago-etl-0.0.13 lib/chicago/etl/mysql_load_file_value_transformer.rb
chicago-etl-0.0.12 lib/chicago/etl/mysql_load_file_value_transformer.rb
chicago-etl-0.0.11 lib/chicago/etl/mysql_load_file_value_transformer.rb
chicago-etl-0.0.10 lib/chicago/etl/mysql_load_file_value_transformer.rb
chicago-etl-0.0.9 lib/chicago/etl/mysql_load_file_value_transformer.rb