Sha256: 196ffc0f2c91d5855a0e9196c05d6876598edf1aa86858b66f401a30697267eb

Contents?: true

Size: 959 Bytes

Versions: 12

Compression:

Stored size: 959 Bytes

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