aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/cases/database_statements_test.rb
blob: 66035865be09fe81b6b7e5ba391323ac56190a55 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
require "cases/helper"

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

  unless current_adapter?(:OracleAdapter)
    def test_exec_insert
      result = @connection.exec_insert("INSERT INTO accounts (firm_id,credit_limit) VALUES (42,5000)", nil, [])
      assert_not_nil @connection.send(:last_inserted_id, result)
    end
  end

  def test_insert_should_return_the_inserted_id
    assert_not_nil return_the_inserted_id(method: :insert)
  end

  def test_create_should_return_the_inserted_id
    assert_not_nil return_the_inserted_id(method: :create)
  end

  private

    def return_the_inserted_id(method:)
      # 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)
        @connection.send(method, "INSERT INTO accounts (id, firm_id,credit_limit) VALUES (accounts_seq.nextval,42,5000)", nil, :id, id_value, sequence_name)
      else
        @connection.send(method, "INSERT INTO accounts (firm_id,credit_limit) VALUES (42,5000)")
      end
    end
end