3 class ActiveSchemaTest
< ActiveRecord
::TestCase
5 ActiveRecord
::ConnectionAdapters::MysqlAdapter.class_eval
do
6 alias_method
:execute_without_stub, :execute
7 def execute(sql
, name
= nil) return sql
end
12 ActiveRecord
::ConnectionAdapters::MysqlAdapter.class_eval
do
13 remove_method
:execute
14 alias_method
:execute, :execute_without_stub
19 assert_equal
"DROP TABLE `people`", drop_table(:people)
22 if current_adapter
?(:MysqlAdapter)
23 def test_create_mysql_database_with_encoding
24 assert_equal
"CREATE DATABASE `matt` DEFAULT CHARACTER SET `utf8`", create_database(:matt)
25 assert_equal
"CREATE DATABASE `aimonetti` DEFAULT CHARACTER SET `latin1`", create_database(:aimonetti, {:charset => 'latin1'})
26 assert_equal
"CREATE DATABASE `matt_aimonetti` DEFAULT CHARACTER SET `big5` COLLATE `big5_chinese_ci`", create_database(:matt_aimonetti, {:charset => :big5, :collation => :big5_chinese_ci})
29 def test_recreate_mysql_database_with_encoding
30 create_database(:luca, {:charset => 'latin1'})
31 assert_equal
"CREATE DATABASE `luca` DEFAULT CHARACTER SET `latin1`", recreate_database(:luca, {:charset => 'latin1'})
36 assert_equal
"ALTER TABLE `people` ADD `last_name` varchar(255)", add_column(:people, :last_name, :string)
39 def test_add_column_with_limit
40 assert_equal
"ALTER TABLE `people` ADD `key` varchar(32)", add_column(:people, :key, :string, :limit => 32)
43 def test_drop_table_with_specific_database
44 assert_equal
"DROP TABLE `otherdb`.`people`", drop_table('otherdb.people')
47 def test_add_timestamps
50 ActiveRecord
::Base.connection
.create_table
:delete_me do |t
|
52 ActiveRecord
::Base.connection
.add_timestamps
:delete_me
53 assert column_present
?('delete_me', 'updated_at', 'datetime')
54 assert column_present
?('delete_me', 'created_at', 'datetime')
56 ActiveRecord
::Base.connection
.drop_table
:delete_me rescue nil
61 def test_remove_timestamps
64 ActiveRecord
::Base.connection
.create_table
:delete_me do |t
|
67 ActiveRecord
::Base.connection
.remove_timestamps
:delete_me
68 assert
!column_present
?('delete_me', 'updated_at', 'datetime')
69 assert
!column_present
?('delete_me', 'created_at', 'datetime')
71 ActiveRecord
::Base.connection
.drop_table
:delete_me rescue nil
78 #we need to actually modify some data, so we make execute point to the original method
79 ActiveRecord
::ConnectionAdapters::MysqlAdapter.class_eval
do
80 alias_method
:execute_with_stub, :execute
81 alias_method
:execute, :execute_without_stub
85 #before finishing, we restore the alias to the mock-up method
86 ActiveRecord
::ConnectionAdapters::MysqlAdapter.class_eval
do
87 alias_method
:execute, :execute_with_stub
92 def method_missing(method_symbol
, *arguments
)
93 ActiveRecord
::Base.connection
.send(method_symbol
, *arguments
)
96 def column_present
?(table_name
, column_name
, type
)
97 results
= ActiveRecord
::Base.connection
.select_all("SHOW FIELDS FROM #{table_name} LIKE '#{column_name}'")
98 results
.first
&& results
.first
['Type'] == type