Sha256: 5f9757419087dc8e014559c3c02dc3c9a48768ab99d7f5a45ef8c91b2b8f6472

Contents?: true

Size: 753 Bytes

Versions: 16

Compression:

Stored size: 753 Bytes

Contents

require "cases/helper"

class DatabaseStatementsTest < ActiveRecord::TestCase
  def setup
    @connection = ActiveRecord::Base.connection
  end

  def test_insert_should_return_the_inserted_id
    # Oracle adapter uses prefetched primary key values from sequence and passes them to connection adapter insert method
    if current_adapter?(:OracleAdapter)
      sequence_name = "accounts_seq"
      id_value = @connection.next_sequence_value(sequence_name)
      id = @connection.insert("INSERT INTO accounts (id, firm_id,credit_limit) VALUES (accounts_seq.nextval,42,5000)", nil, :id, id_value, sequence_name)
    else
      id = @connection.insert("INSERT INTO accounts (firm_id,credit_limit) VALUES (42,5000)")
    end
    assert_not_nil id
  end
end

Version data entries

16 entries across 14 versions & 3 rubygems

Version Path
ibm_db-3.0.4-x86-mingw32 test/cases/database_statements_test.rb
ibm_db-3.0.4 test/cases/database_statements_test.rb
ibm_db-3.0.3-x86-mingw32 test/cases/database_statements_test.rb
ibm_db-3.0.3 test/cases/database_statements_test.rb
ibm_db-3.0.2-x86-mingw32 test/cases/database_statements_test.rb
ibm_db-3.0.2 test/cases/database_statements_test.rb
activejob-lock-0.0.2 rails/activerecord/test/cases/database_statements_test.rb
ibm_db-3.0.1 test/cases/database_statements_test.rb
ibm_db-3.0.1-x86-mingw32 test/cases/database_statements_test.rb
activejob-lock-0.0.1 rails/activerecord/test/cases/database_statements_test.rb
activerecord-nuodb-adapter-2.0.3 test/cases/database_statements_test.rb
activerecord-nuodb-adapter-2.0 test/cases/database_statements_test.rb
activerecord-nuodb-adapter-1.1 test/database_statements_test.rb
activerecord-nuodb-adapter-1.1 test/cases/database_statements_test.rb
activerecord-nuodb-adapter-1.0.4 test/cases/database_statements_test.rb
activerecord-nuodb-adapter-1.0.4 test/database_statements_test.rb