path: root/activerecord/test/cases/numeric_data_test.rb

# frozen_string_literal: true

require "cases/helper"
require "models/numeric_data"

class NumericDataTest < ActiveRecord::TestCase
  def test_big_decimal_conditions
    m = NumericData.new(
      bank_balance: 1586.43,
      big_bank_balance: BigDecimal("1000234000567.95"),
      world_population: 6000000000,
      my_house_population: 3
    )
    assert m.save
    assert_equal 0, NumericData.where("bank_balance > ?", 2000.0).count
  end

  def test_numeric_fields
    m = NumericData.new(
      bank_balance: 1586.43,
      big_bank_balance: BigDecimal("1000234000567.95"),
      world_population: 2**62,
      my_house_population: 3
    )
    assert m.save

    m1 = NumericData.find_by(
      bank_balance: 1586.43,
      big_bank_balance: BigDecimal("1000234000567.95")
    )

    assert_kind_of Integer, m1.world_population
    assert_equal 2**62, m1.world_population

    assert_kind_of Integer, m1.my_house_population
    assert_equal 3, m1.my_house_population

    assert_kind_of BigDecimal, m1.bank_balance
    assert_equal BigDecimal("1586.43"), m1.bank_balance

    assert_kind_of BigDecimal, m1.big_bank_balance
    assert_equal BigDecimal("1000234000567.95"), m1.big_bank_balance
  end

  def test_numeric_fields_with_scale
    m = NumericData.new(
      bank_balance: 1586.43122334,
      big_bank_balance: BigDecimal("234000567.952344"),
      world_population: 2**62,
      my_house_population: 3
    )
    assert m.save

    m1 = NumericData.find_by(
      bank_balance: 1586.43122334,
      big_bank_balance: BigDecimal("234000567.952344")
    )

    assert_kind_of Integer, m1.world_population
    assert_equal 2**62, m1.world_population

    assert_kind_of Integer, m1.my_house_population
    assert_equal 3, m1.my_house_population

    assert_kind_of BigDecimal, m1.bank_balance
    assert_equal BigDecimal("1586.43"), m1.bank_balance

    assert_kind_of BigDecimal, m1.big_bank_balance
    assert_equal BigDecimal("234000567.95"), m1.big_bank_balance
  end

  if current_adapter?(:PostgreSQLAdapter)
    def test_numeric_fields_with_nan
      m = NumericData.new(
        bank_balance: BigDecimal("NaN"),
        big_bank_balance: BigDecimal("NaN"),
        world_population: 2**62,
        my_house_population: 3
      )
      assert_predicate m.bank_balance, :nan?
      assert_predicate m.big_bank_balance, :nan?
      assert m.save

      m1 = NumericData.find_by(
        bank_balance: BigDecimal("NaN"),
        big_bank_balance: BigDecimal("NaN")
      )

      assert_predicate m1.bank_balance, :nan?
      assert_predicate m1.big_bank_balance, :nan?
    end
  end
end