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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
|
# 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
|
