require "isolation/abstract_unit" module ApplicationTests module RakeTests class RakeMigrationsTest < ActiveSupport::TestCase def setup build_app boot_rails FileUtils.rm_rf("#{app_path}/config/environments") end def teardown teardown_app end test 'running migrations with given scope' do Dir.chdir(app_path) do `rails generate model user username:string password:string` app_file "db/migrate/01_a_migration.bukkits.rb", <<-MIGRATION class AMigration < ActiveRecord::Migration end MIGRATION output = `rake db:migrate SCOPE=bukkits` assert_no_match(/create_table\(:users\)/, output) assert_no_match(/CreateUsers/, output) assert_no_match(/add_column\(:users, :email, :string\)/, output) assert_match(/AMigration: migrated/, output) output = `rake db:migrate SCOPE=bukkits VERSION=0` assert_no_match(/drop_table\(:users\)/, output) assert_no_match(/CreateUsers/, output) assert_no_match(/remove_column\(:users, :email\)/, output) assert_match(/AMigration: reverted/, output) end end test 'model and migration generator with change syntax' do Dir.chdir(app_path) do `rails generate model user username:string password:string; rails generate migration add_email_to_users email:string` output = `rake db:migrate` assert_match(/create_table\(:users\)/, output) assert_match(/CreateUsers: migrated/, output) assert_match(/add_column\(:users, :email, :string\)/, output) assert_match(/AddEmailToUsers: migrated/, output) output = `rake db:rollback STEP=2` assert_match(/drop_table\(:users\)/, output) assert_match(/CreateUsers: reverted/, output) assert_match(/remove_column\(:users, :email, :string\)/, output) assert_match(/AddEmailToUsers: reverted/, output) end end test 'migration status when schema migrations table is not present' do output = Dir.chdir(app_path){ `rake db:migrate:status 2>&1` } assert_equal "Schema migrations table does not exist yet.\n", output end test 'test migration status' do Dir.chdir(app_path) do `rails generate model user username:string password:string; rails generate migration add_email_to_users email:string; rake db:migrate` output = `rake db:migrate:status` assert_match(/up\s+\d{14}\s+Create users/, output) assert_match(/up\s+\d{14}\s+Add email to users/, output) `rake db:rollback STEP=1` output = `rake db:migrate:status` assert_match(/up\s+\d{14}\s+Create users/, output) assert_match(/down\s+\d{14}\s+Add email to users/, output) end end test 'migration status without timestamps' do add_to_config('config.active_record.timestamped_migrations = false') Dir.chdir(app_path) do `rails generate model user username:string password:string; rails generate migration add_email_to_users email:string; rake db:migrate` output = `rake db:migrate:status` assert_match(/up\s+\d{3,}\s+Create users/, output) assert_match(/up\s+\d{3,}\s+Add email to users/, output) `rake db:rollback STEP=1` output = `rake db:migrate:status` assert_match(/up\s+\d{3,}\s+Create users/, output) assert_match(/down\s+\d{3,}\s+Add email to users/, output) end end test 'test migration status after rollback and redo' do Dir.chdir(app_path) do `rails generate model user username:string password:string; rails generate migration add_email_to_users email:string; rake db:migrate` output = `rake db:migrate:status` assert_match(/up\s+\d{14}\s+Create users/, output) assert_match(/up\s+\d{14}\s+Add email to users/, output) `rake db:rollback STEP=2` output = `rake db:migrate:status` assert_match(/down\s+\d{14}\s+Create users/, output) assert_match(/down\s+\d{14}\s+Add email to users/, output) `rake db:migrate:redo` output = `rake db:migrate:status` assert_match(/up\s+\d{14}\s+Create users/, output) assert_match(/up\s+\d{14}\s+Add email to users/, output) end end test 'migration status after rollback and redo without timestamps' do add_to_config('config.active_record.timestamped_migrations = false') Dir.chdir(app_path) do `rails generate model user username:string password:string; rails generate migration add_email_to_users email:string; rake db:migrate` output = `rake db:migrate:status` assert_match(/up\s+\d{3,}\s+Create users/, output) assert_match(/up\s+\d{3,}\s+Add email to users/, output) `rake db:rollback STEP=2` output = `rake db:migrate:status` assert_match(/down\s+\d{3,}\s+Create users/, output) assert_match(/down\s+\d{3,}\s+Add email to users/, output) `rake db:migrate:redo` output = `rake db:migrate:status` assert_match(/up\s+\d{3,}\s+Create users/, output) assert_match(/up\s+\d{3,}\s+Add email to users/, output) end end test 'schema generation when dump_schema_after_migration is set' do add_to_config('config.active_record.dump_schema_after_migration = false') Dir.chdir(app_path) do `rails generate model book title:string; bundle exec rake db:migrate` assert !File.exist?("db/schema.rb") end add_to_config('config.active_record.dump_schema_after_migration = true') Dir.chdir(app_path) do `rails generate model author name:string; bundle exec rake db:migrate` structure_dump = File.read("db/schema.rb") assert_match(/create_table "authors"/, structure_dump) end end test 'default schema generation after migration' do Dir.chdir(app_path) do `rails generate model book title:string; bundle exec rake db:migrate` structure_dump = File.read("db/schema.rb") assert_match(/create_table "books"/, structure_dump) end end test 'test migration status migrated file is deleted' do Dir.chdir(app_path) do `rails generate model user username:string password:string; rails generate migration add_email_to_users email:string; rake db:migrate rm db/migrate/*email*.rb` output = `rake db:migrate:status` File.write('test.txt', output) assert_match(/up\s+\d{14}\s+Create users/, output) assert_match(/up\s+\d{14}\s+\** NO FILE \**/, output) end end end end end