aboutsummaryrefslogblamecommitdiffstats
path: root/activerecord/test/cases/ar_schema_test.rb
blob: e3eccad71fbcf5a38d5dc445f0e4e232e623f8f4 (plain) (tree)
1
2
3
4
5
6
7
8
9
                      
 
                                                     
 
                                                       
                                        
 

                                                         
                                             
                                                 
                                              

       
               
                                               

                                                              
                                                       
                                                         
                                                         
                                                         

       
                            

                                                                              
                                                                       









                                                                              
                          
                                                

                                   
                                                                             





                                                                             

                                                                                        
       
 

                                                           
                                                                  

                                                                    
                                                








                                                                             
                                                                   


                                                           
                                                           
                                   
                                                  





                                         

                            
                                                           



                                                                             






                                                                                                               
 














                                                                                                     



                                                                      

           
 

                                                                                           

       


                                                                      
 

                                           

           
 

                                                                                           

       



                                                                        
         
 

                                                                                           
       
     
   
require "cases/helper"

if ActiveRecord::Base.connection.supports_migrations?

  class ActiveRecordSchemaTest < ActiveRecord::TestCase
    self.use_transactional_tests = false

    setup do
      @original_verbose = ActiveRecord::Migration.verbose
      ActiveRecord::Migration.verbose = false
      @connection = ActiveRecord::Base.connection
      ActiveRecord::SchemaMigration.drop_table
    end

    teardown do
      @connection.drop_table :fruits rescue nil
      @connection.drop_table :nep_fruits rescue nil
      @connection.drop_table :nep_schema_migrations rescue nil
      @connection.drop_table :has_timestamps rescue nil
      @connection.drop_table :multiple_indexes rescue nil
      ActiveRecord::SchemaMigration.delete_all rescue nil
      ActiveRecord::Migration.verbose = @original_verbose
    end

    def test_has_primary_key
      old_primary_key_prefix_type = ActiveRecord::Base.primary_key_prefix_type
      ActiveRecord::Base.primary_key_prefix_type = :table_name_with_underscore
      assert_equal "version", ActiveRecord::SchemaMigration.primary_key

      ActiveRecord::SchemaMigration.create_table
      assert_difference "ActiveRecord::SchemaMigration.count", 1 do
        ActiveRecord::SchemaMigration.create version: 12
      end
    ensure
      ActiveRecord::SchemaMigration.drop_table
      ActiveRecord::Base.primary_key_prefix_type = old_primary_key_prefix_type
    end

    def test_schema_define
      ActiveRecord::Schema.define(version: 7) do
        create_table :fruits do |t|
          t.column :color, :string
          t.column :fruit_size, :string  # NOTE: "size" is reserved in Oracle
          t.column :texture, :string
          t.column :flavor, :string
        end
      end

      assert_nothing_raised { @connection.select_all "SELECT * FROM fruits" }
      assert_nothing_raised { @connection.select_all "SELECT * FROM schema_migrations" }
      assert_equal 7, ActiveRecord::Migrator::current_version
    end

    def test_schema_define_w_table_name_prefix
      table_name = ActiveRecord::SchemaMigration.table_name
      old_table_name_prefix = ActiveRecord::Base.table_name_prefix
      ActiveRecord::Base.table_name_prefix  = "nep_"
      ActiveRecord::SchemaMigration.table_name = "nep_#{table_name}"
      ActiveRecord::Schema.define(version: 7) do
        create_table :fruits do |t|
          t.column :color, :string
          t.column :fruit_size, :string  # NOTE: "size" is reserved in Oracle
          t.column :texture, :string
          t.column :flavor, :string
        end
      end
      assert_equal 7, ActiveRecord::Migrator::current_version
    ensure
      ActiveRecord::Base.table_name_prefix  = old_table_name_prefix
      ActiveRecord::SchemaMigration.table_name = table_name
    end

    def test_schema_raises_an_error_for_invalid_column_type
      assert_raise NoMethodError do
        ActiveRecord::Schema.define(version: 8) do
          create_table :vegetables do |t|
            t.unknown :color
          end
        end
      end
    end

    def test_schema_subclass
      Class.new(ActiveRecord::Schema).define(version: 9) do
        create_table :fruits
      end
      assert_nothing_raised { @connection.select_all "SELECT * FROM fruits" }
    end

    def test_normalize_version
      assert_equal "118", ActiveRecord::SchemaMigration.normalize_migration_number("0000118")
      assert_equal "002", ActiveRecord::SchemaMigration.normalize_migration_number("2")
      assert_equal "017", ActiveRecord::SchemaMigration.normalize_migration_number("0017")
      assert_equal "20131219224947", ActiveRecord::SchemaMigration.normalize_migration_number("20131219224947")
    end

    def test_schema_load_with_multiple_indexes_for_column_of_different_names
      ActiveRecord::Schema.define do
        create_table :multiple_indexes do |t|
          t.string "foo"
          t.index ["foo"], name: "multiple_indexes_foo_1"
          t.index ["foo"], name: "multiple_indexes_foo_2"
        end
      end

      indexes = @connection.indexes("multiple_indexes")

      assert_equal 2, indexes.length
      assert_equal ["multiple_indexes_foo_1", "multiple_indexes_foo_2"], indexes.collect(&:name).sort
    end

    def test_timestamps_without_null_set_null_to_false_on_create_table
      ActiveRecord::Schema.define do
        create_table :has_timestamps do |t|
          t.timestamps
        end
      end

      assert !@connection.columns(:has_timestamps).find { |c| c.name == "created_at" }.null
      assert !@connection.columns(:has_timestamps).find { |c| c.name == "updated_at" }.null
    end

    def test_timestamps_without_null_set_null_to_false_on_change_table
      ActiveRecord::Schema.define do
        create_table :has_timestamps

        change_table :has_timestamps do |t|
          t.timestamps default: Time.now
        end
      end

      assert !@connection.columns(:has_timestamps).find { |c| c.name == "created_at" }.null
      assert !@connection.columns(:has_timestamps).find { |c| c.name == "updated_at" }.null
    end

    def test_timestamps_without_null_set_null_to_false_on_add_timestamps
      ActiveRecord::Schema.define do
        create_table :has_timestamps
        add_timestamps :has_timestamps, default: Time.now
      end

      assert !@connection.columns(:has_timestamps).find { |c| c.name == "created_at" }.null
      assert !@connection.columns(:has_timestamps).find { |c| c.name == "updated_at" }.null
    end
  end
end