vendor/rails/activerecord/test/cases/defaults_test.rb

   1 require "cases/helper"
   2 require 'models/default'
   3 require 'models/entrant'
   4
   5 class DefaultTest < ActiveRecord::TestCase
   6   def test_nil_defaults_for_not_null_columns
   7     column_defaults =
   8       if current_adapter?(:MysqlAdapter) && (Mysql.client_version < 50051 || (50100..50122).include?(Mysql.client_version))
   9         { 'id' => nil, 'name' => '',  'course_id' => nil }
  10       else
  11         { 'id' => nil, 'name' => nil, 'course_id' => nil }
  12       end
  13
  14     column_defaults.each do |name, default|
  15       column = Entrant.columns_hash[name]
  16       assert !column.null, "#{name} column should be NOT NULL"
  17       assert_equal default, column.default, "#{name} column should be DEFAULT #{default.inspect}"
  18     end
  19   end
  20
  21   if current_adapter?(:PostgreSQLAdapter, :FirebirdAdapter, :OpenBaseAdapter, :OracleAdapter)
  22     def test_default_integers
  23       default = Default.new
  24       assert_instance_of Fixnum, default.positive_integer
  25       assert_equal 1, default.positive_integer
  26       assert_instance_of Fixnum, default.negative_integer
  27       assert_equal -1, default.negative_integer
  28       assert_instance_of BigDecimal, default.decimal_number
  29       assert_equal BigDecimal.new("2.78"), default.decimal_number
  30     end
  31   end
  32
  33   if current_adapter?(:PostgreSQLAdapter)
  34     def test_multiline_default_text
  35       # older postgres versions represent the default with escapes ("\\012" for a newline)
  36       assert ( "--- []\n\n" == Default.columns_hash['multiline_default'].default ||
  37                "--- []\\012\\012" == Default.columns_hash['multiline_default'].default)
  38     end
  39   end
  40 end
  41
  42 if current_adapter?(:MysqlAdapter)
  43   class DefaultsTestWithoutTransactionalFixtures < ActiveRecord::TestCase
  44     # ActiveRecord::Base#create! (and #save and other related methods) will
  45     # open a new transaction. When in transactional fixtures mode, this will
  46     # cause ActiveRecord to create a new savepoint. However, since MySQL doesn't
  47     # support DDL transactions, creating a table will result in any created
  48     # savepoints to be automatically released. This in turn causes the savepoint
  49     # release code in AbstractAdapter#transaction to fail.
  50     #
  51     # We don't want that to happen, so we disable transactional fixtures here.
  52     self.use_transactional_fixtures = false
  53
  54     # MySQL 5 and higher is quirky with not null text/blob columns.
  55     # With MySQL Text/blob columns cannot have defaults. If the column is not
  56     # null MySQL will report that the column has a null default
  57     # but it behaves as though the column had a default of ''
  58     def test_mysql_text_not_null_defaults
  59       klass = Class.new(ActiveRecord::Base)
  60       klass.table_name = 'test_mysql_text_not_null_defaults'
  61       klass.connection.create_table klass.table_name do |t|
  62         t.column :non_null_text, :text, :null => false
  63         t.column :non_null_blob, :blob, :null => false
  64         t.column :null_text, :text, :null => true
  65         t.column :null_blob, :blob, :null => true
  66       end
  67       assert_equal '', klass.columns_hash['non_null_blob'].default
  68       assert_equal '', klass.columns_hash['non_null_text'].default
  69
  70       assert_equal nil, klass.columns_hash['null_blob'].default
  71       assert_equal nil, klass.columns_hash['null_text'].default
  72
  73       assert_nothing_raised do
  74         instance = klass.create!
  75         assert_equal '', instance.non_null_text
  76         assert_equal '', instance.non_null_blob
  77         assert_nil instance.null_text
  78         assert_nil instance.null_blob
  79       end
  80     ensure
  81       klass.connection.drop_table(klass.table_name) rescue nil
  82     end
  83
  84     # MySQL uses an implicit default 0 rather than NULL unless in strict mode.
  85     # We use an implicit NULL so schema.rb is compatible with other databases.
  86     def test_mysql_integer_not_null_defaults
  87       klass = Class.new(ActiveRecord::Base)
  88       klass.table_name = 'test_integer_not_null_default_zero'
  89       klass.connection.create_table klass.table_name do |t|
  90         t.column :zero, :integer, :null => false, :default => 0
  91         t.column :omit, :integer, :null => false
  92       end
  93
  94       assert_equal 0, klass.columns_hash['zero'].default
  95       assert !klass.columns_hash['zero'].null
  96       # 0 in MySQL 4, nil in 5.
  97       assert [0, nil].include?(klass.columns_hash['omit'].default)
  98       assert !klass.columns_hash['omit'].null
  99
 100       assert_raise(ActiveRecord::StatementInvalid) { klass.create! }
 101
 102       assert_nothing_raised do
 103         instance = klass.create!(:omit => 1)
 104         assert_equal 0, instance.zero
 105         assert_equal 1, instance.omit
 106       end
 107     ensure
 108       klass.connection.drop_table(klass.table_name) rescue nil
 109     end
 110   end
 111 end