Sha256: 6f6347aedbcc3c837a9955c930832348f788a11f77264645086818e3b60e7f34
Contents?: true
Size: 1.55 KB
Versions: 11
Compression:
Stored size: 1.55 KB
Contents
require 'cases/sqlserver_helper'
require 'models/person'
class MigrationTestSqlserver < ActiveRecord::TestCase
context 'For transactions' do
setup do
@connection = ActiveRecord::Base.connection
@trans_test_table1 = 'sqlserver_trans_table1'
@trans_test_table2 = 'sqlserver_trans_table2'
@trans_tables = [@trans_test_table1,@trans_test_table2]
end
teardown do
@trans_tables.each do |table_name|
ActiveRecord::Migration.drop_table(table_name) if @connection.tables.include?(table_name)
end
end
should 'not create a tables if error in migrations' do
begin
ActiveRecord::Migrator.up(SQLSERVER_MIGRATIONS_ROOT+'/transaction_table')
rescue Exception => e
assert_match %r|this and all later migrations canceled|, e.message
end
assert_does_not_contain @trans_test_table1, @connection.tables
assert_does_not_contain @trans_test_table2, @connection.tables
end
end
end
class MigrationTest < ActiveRecord::TestCase
COERCED_TESTS = [:test_add_column_not_null_without_default]
include SqlserverCoercedTest
def test_coerced_test_add_column_not_null_without_default
Person.connection.create_table :testings do |t|
t.column :foo, :string
t.column :bar, :string, :null => false
end
assert_raises(ActiveRecord::StatementInvalid) do
Person.connection.execute "INSERT INTO [testings] ([foo], [bar]) VALUES ('hello', NULL)"
end
ensure
Person.connection.drop_table :testings rescue nil
end
end
Version data entries
11 entries across 11 versions & 3 rubygems