Class: Myreplicator::VerticaTypes
- Inherits:
-
Object
- Object
- Myreplicator::VerticaTypes
- Defined in:
- lib/loader/vertica/types.rb
Class Method Summary collapse
Class Method Details
.convert(type, col_type) ⇒ Object
4 5 6 7 8 9 10 |
# 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) ⇒ Object
31 32 33 34 35 36 37 38 39 40 41 42 43 |
# 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 ⇒ Object
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
# 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 |