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
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
|
shared_examples_for 'supporting Float' do
before :all do
setup_test_environment
end
before do
@connection = DataObjects::Connection.new(CONFIG.uri)
end
after do
@connection.close
end
describe 'reading a Float' do
describe 'with manual typecasting' do
before do
@command = @connection.create_command("SELECT id FROM widgets WHERE ad_description = ?")
@command.set_types(Float)
@reader = @command.execute_reader('Buy this product now!')
@reader.next!
@values = @reader.values
end
after do
@reader.close
end
it 'should return the correctly typed result' do
expect(@values.first).to be_kind_of(Float)
end
it 'should return the correct result' do
#Some of the drivers starts autoincrementation from 0 not 1
expect(@values.first).to satisfy { |val| val == 1.0 or val == 0.0 }
end
end
describe 'with manual typecasting a nil' do
before do
@command = @connection.create_command("SELECT cost1 FROM widgets WHERE id = ?")
@command.set_types(Float)
@reader = @command.execute_reader(5)
@reader.next!
@values = @reader.values
end
after do
@reader.close
end
it 'should return the correctly typed result' do
expect(@values.first).to be_kind_of(NilClass)
end
it 'should return the correct result' do
expect(@values.first).to be_nil
end
end
end
describe 'writing a Float' do
before do
@reader = @connection.create_command("SELECT id FROM widgets WHERE id = ?").execute_reader(2.0)
@reader.next!
@values = @reader.values
end
after do
@reader.close
end
it 'should return the correct entry' do
#Some of the drivers starts autoincrementation from 0 not 1
expect(@values.first).to satisfy { |val| val == 1 or val == 2 }
end
end
end
shared_examples_for 'supporting Float autocasting' do
before :all do
setup_test_environment
end
before do
@connection = DataObjects::Connection.new(CONFIG.uri)
end
after do
@connection.close
end
describe 'reading a Float' do
describe 'with automatic typecasting' do
before do
@reader = @connection.create_command("SELECT weight, cost1 FROM widgets WHERE ad_description = ?").execute_reader('Buy this product now!')
@reader.next!
@values = @reader.values
end
after do
@reader.close
end
it 'should return the correctly typed result' do
expect(@values.first).to be_kind_of(Float)
expect(@values.last).to be_kind_of(Float)
end
it 'should return the correct result' do
expect(@values.first).to eq(13.4)
expect(BigDecimal(@values.last.to_s).round(2)).to eq(10.23)
end
end
end
end
|
