Contents

module Myreplicator
  class VerticaTypes
  
    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

    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"
      }
    end

    def self.convert_key key
      map = {
        "UNI" => "UNIQUE",
      " MUL" => "", 
        "PRI" => "PRIMARY KEY"
      }

      if map[key].blank?
        return ""
      else
        return map[key]
      end
    end

  end
end

Version data entries

12 entries across 12 versions & 1 rubygems

Version	Path
myreplicator-1.1.37	lib/loader/vertica/types.rb
myreplicator-1.1.36	lib/loader/vertica/types.rb
myreplicator-1.1.35	lib/loader/vertica/types.rb
myreplicator-1.1.34	lib/loader/vertica/types.rb
myreplicator-1.1.33	lib/loader/vertica/types.rb
myreplicator-1.1.32	lib/loader/vertica/types.rb
myreplicator-1.1.31	lib/loader/vertica/types.rb
myreplicator-1.1.30	lib/loader/vertica/types.rb
myreplicator-1.1.29	lib/loader/vertica/types.rb
myreplicator-1.1.28	lib/loader/vertica/types.rb
myreplicator-1.1.27	lib/loader/vertica/types.rb
myreplicator-1.1.26	lib/loader/vertica/types.rb