class Myreplicator::VerticaTypes
Public Class Methods
convert(type, col_type)
click to toggle source
# File lib/loader/vertica/types.rb, line 4 def self.convert type, col_type if mysql_vertica_conversion[type].blank? return col_type.gsub("decimal","numeric") else return mysql_vertica_conversion[type] end end
convert_key(key)
click to toggle source
# File lib/loader/vertica/types.rb, line 31 def self.convert_key key map = { "UNI" => "UNIQUE", " MUL" => "", "PRI" => "PRIMARY KEY" } if map[key].blank? return "" else return map[key] end end
mysql_vertica_conversion()
click to toggle source
# File lib/loader/vertica/types.rb, line 12 def self.mysql_vertica_conversion map = { "int" => "int", "integer" => "int", "int8" => "int", "smallint" => "int", "bigint" => "int", "tinyint" => "int", "numeric" => "int", "text" => "VARCHAR(65000)", "mediumtext" => "VARCHAR(65000)", "bit" => "binary", "longtext" => "VARCHAR(65000)", "text" => "VARCHAR(65000)", "float" => "decimal", "double" => "double precision" } end