class DatabaseStatementsTest

Public Instance Methods

setup() click to toggle source
# File activerecord/test/cases/database_statements_test.rb, line 6
def setup
  @connection = ActiveRecord::Base.connection
end
test_create_should_return_the_inserted_id() click to toggle source
# File activerecord/test/cases/database_statements_test.rb, line 21
def test_create_should_return_the_inserted_id
  assert_not_nil return_the_inserted_id(method: :create)
end
test_exec_insert() click to toggle source
# File activerecord/test/cases/database_statements_test.rb, line 11
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
test_insert_should_return_the_inserted_id() click to toggle source
# File activerecord/test/cases/database_statements_test.rb, line 17
def test_insert_should_return_the_inserted_id
  assert_not_nil return_the_inserted_id(method: :insert)
end

Private Instance Methods

return_the_inserted_id(method:) click to toggle source
# File activerecord/test/cases/database_statements_test.rb, line 27
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