Sha256: 95383fb176e995c2cb46580520eca754166ec30dd88ff9d6dd0dddc3f9036b2f

Contents?: true

Size: 1.34 KB

Versions: 6

Compression:

Stored size: 1.34 KB

Contents

require "cases/helper"

class DatabaseStatementsTest < ActiveRecord::TestCase
  def setup
    @connection = ActiveRecord::Base.connection
  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

  def test_insert_update_delete_sql_is_deprecated
    assert_deprecated { @connection.insert_sql("INSERT INTO accounts (firm_id,credit_limit) VALUES (42,5000)") }
    assert_deprecated { @connection.update_sql("UPDATE accounts SET credit_limit = 6000 WHERE firm_id = 42") }
    assert_deprecated { @connection.delete_sql("DELETE FROM accounts WHERE firm_id = 42") }
  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

Version data entries

6 entries across 6 versions & 1 rubygems

Version Path
ibm_db-5.2.0-x86-mingw32 test/cases/database_statements_test.rb
ibm_db-5.1.0-x86-mingw32 test/cases/database_statements_test.rb
ibm_db-5.0.5-x86-mingw32 test/cases/database_statements_test.rb
ibm_db-5.0.4-x86-mingw32 test/cases/database_statements_test.rb
ibm_db-5.0.3-x86-mingw32 test/cases/database_statements_test.rb
ibm_db-5.0.2-x86-mingw32 test/cases/database_statements_test.rb