Sha256: bdbba8df1d819209f9c82c214f162a2a4a7c4c7600ee0eb1ab587185ca7dfd45

Contents?: true

Size: 685 Bytes

Versions: 4

Compression:

Stored size: 685 Bytes

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