Contents

require 'jdbc_common'
require 'db/mssql'

class MSSQLIdentityInsertTest < Test::Unit::TestCase
  include MigrationSetup
  
  def test_enable_identity_insert_when_necessary
    Entry.connection.execute("INSERT INTO entries([id], [title]) VALUES (333, 'Title')")
    Entry.connection.execute("INSERT INTO entries([title], [id]) VALUES ('Title', 344)")
    Entry.connection.execute("INSERT INTO entries(id, title) VALUES (666, 'Title')")
    Entry.connection.execute("INSERT INTO entries(id, title) (SELECT id+123, title FROM entries)")
  end

  def test_dont_enable_identity_insert_when_unnecessary
    Entry.connection.execute("INSERT INTO entries([title]) VALUES ('[id]')")
  end

end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
activerecord-jdbc-adapter-1.2.9.1	test/mssql_identity_insert_test.rb
activerecord-jdbc-adapter-1.3.0.beta2	test/db/mssql/identity_insert_test.rb
activerecord-jdbc-adapter-1.3.0.beta1	test/db/mssql/identity_insert_test.rb
activerecord-jdbc-adapter-1.2.9	test/mssql_identity_insert_test.rb