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

34 entries across 34 versions & 8 rubygems

Version	Path
cmoran92-activerecord-jdbc-adapter-1.2.1.2	test/mssql_identity_insert_test.rb
activerecord-jdbc-adapter-1.2.8	test/mssql_identity_insert_test.rb
activerecord-jdbc-adapter-1.2.5	test/mssql_identity_insert_test.rb
tgbyte-activerecord-jdbc-adapter-1.2.2.5	test/mssql_identity_insert_test.rb
tgbyte-activerecord-jdbc-adapter-1.2.2.4	test/mssql_identity_insert_test.rb
tgbyte-activerecord-jdbc-adapter-1.2.2.3	test/mssql_identity_insert_test.rb
tgbyte-activerecord-jdbc-adapter-1.2.2.2	test/mssql_identity_insert_test.rb
activerecord-jdbc-adapter-1.2.2.1	test/mssql_identity_insert_test.rb
activerecord-jdbc-adapter-onsite-1.2.2	test/mssql_identity_insert_test.rb
cmoran92-activerecord-jdbc-adapter-1.2.1.1	test/mssql_identity_insert_test.rb
intentmedia-activerecord-jdbc-adapter-1.1.1.1	test/mssql_identity_insert_test.rb
activerecord-jdbc-adapter-1.2.2	test/mssql_identity_insert_test.rb
cmoran92-activerecord-jdbc-adapter-1.2.1	test/mssql_identity_insert_test.rb
activerecord-jdbc-adapter-1.2.1	test/mssql_identity_insert_test.rb
c3-activerecord-jdbc-adapter-1.1.3.1	test/mssql_identity_insert_test.rb
activerecord-jdbc-adapter-1.2.0	test/mssql_identity_insert_test.rb
c3-activerecord-jdbc-adapter-1.1.3	test/mssql_identity_insert_test.rb
jashmenn-activerecord-jdbc-adapter-1.2.0.0	test/mssql_identity_insert_test.rb
jashmenn-activerecord-jdbc-adapter-1.2.0	test/mssql_identity_insert_test.rb
activerecord-jdbc-adapter-1.1.3	test/mssql_identity_insert_test.rb