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