Class: Convergence::DefaultParameter::MysqlDefaultParameter

Inherits:
Object
  • Object
show all
Defined in:
lib/convergence/default_parameter/mysql_default_parameter.rb

Constant Summary collapse

DEFAULT_TABLE_PARAMETERS = 
{
  engine: 'InnoDB',
  row_format: 'Compact',
  default_charset: 'utf8'
}
DEFAULT_COLLATE_NAME = 
{
  'big5' => 'big5_chinese_ci',
  'dec8' => 'dec8_swedish_ci',
  'cp850' => 'cp850_general_ci',
  'hp8' => ' hp8_english_ci',
  'koi8r' => ' koi8r_general_ci',
  'latin1' => 'latin1_swedish_ci',
  'latin2' => 'latin2_general_ci',
  'swe7' => 'swe7_swedish_ci',
  'ascii' => 'ascii_general_ci',
  'ujis' => 'ujis_japanese_ci',
  'sjis' => 'sjis_japanese_ci',
  'hebrew' => 'hebrew_general_ci',
  'tis620' => 'tis620_thai_ci',
  'euckr' => 'euckr_korean_ci',
  'koi8u' => 'koi8u_general_ci',
  'gb2312' => 'gb2312_chinese_ci',
  'greek' => ' greek_general_ci',
  'cp1250' => 'cp1250_general_ci',
  'gbk' => 'gbk_chinese_ci',
  'latin5' => 'latin5_turkish_ci',
  'armscii8' => 'armscii8_general_ci',
  'utf8' => 'utf8_general_ci',
  'ucs2' => 'ucs2_general_ci',
  'cp866' => 'cp866_general_ci',
  'keybcs2' => 'keybcs2_general_ci',
  'macce' => 'macce_general_ci',
  'macroman' => 'macroman_general_ci',
  'cp852' => 'cp852_general_ci',
  'latin7' => 'latin7_general_ci',
  'utf8mb4' => 'utf8mb4_general_ci',
  'cp1251' => 'cp1251_general_ci',
  'utf16' => 'utf16_general_ci',
  'utf16le' => 'utf16le_general_ci',
  'cp1256' => 'cp1256_general_ci',
  'cp1257' => 'cp1257_general_ci',
  'utf32' =>  'utf32_general_ci',
  'binary' => 'binary',
  'geostd8' => 'eostd8_general_ci',
  'cp932' => 'cp932_japanese_ci',
  'eucjpms' => 'ucjpms_japanese_ci'
}
DEFAULT_COLUMN_PARAMETERS = 
{
  null: false
}
TEXT_TYPE = 
[:varchar, :char, :tiny_text, :text, :mediumtext, :longtext]
DEFAULT_COLUMN_TYPE_PARAMETERS = 
{
  tinyint: {
    limit: 4
  },
  smallint: {
    limit: 6
  },
  mediumint: {
    limit: 9
  },
  int: {
    limit: 11
  },
  bigint: {
    limit: 20
  },
  varchar: {
    limit: 255
  }
}
DEFAULT_INDEX_PARAMETERS = 
{ type: 'BTREE', unique: false }

Instance Method Summary collapse

Constructor Details

#initialize ⇒ MysqlDefaultParameter

Returns a new instance of MysqlDefaultParameter.



77
78
 
# File 'lib/convergence/default_parameter/mysql_default_parameter.rb', line 77

def initialize
end

Instance Method Details

#append_default_parameter(table) ⇒ Object 



87
88
89
90
91
92
 
# File 'lib/convergence/default_parameter/mysql_default_parameter.rb', line 87

def append_default_parameter(table)
  append_column_default_parameter(table)
  append_table_default_parameter(table)
  append_index_default_parameter(table)
  table
end

#remove_default_parameter(table) ⇒ Object 



80
81
82
83
84
85
 
# File 'lib/convergence/default_parameter/mysql_default_parameter.rb', line 80

def remove_default_parameter(table)
  remove_column_default_parameter(table)
  remove_table_default_parameter(table)
  remove_index_default_parameter(table)
  table
end