← Back to branch summary

~michaelforrest/use-case-mapper/trunk

« back to all changes in this revision

Viewing changes to vendor/rails/activerecord/test/cases/datatype_test_postgresql.rb

  • Committer: Michael Forrest
  • Date: 2010-10-15 16:28:50 UTC
  • Revision ID: michael.forrest@canonical.com-20101015162850-tj2vchanv0kr0dun
refroze gems

Show diffs side-by-side

added added

removed removed

Lines of Context:
vendor/rails/activerecord/test/cases/datatype_test_postgresql.rb
 
1
require "cases/helper"
 
2
 
 
3
class PostgresqlArray < ActiveRecord::Base
 
4
end
 
5
 
 
6
class PostgresqlMoney < ActiveRecord::Base
 
7
end
 
8
 
 
9
class PostgresqlNumber < ActiveRecord::Base
 
10
end
 
11
 
 
12
class PostgresqlTime < ActiveRecord::Base
 
13
end
 
14
 
 
15
class PostgresqlNetworkAddress < ActiveRecord::Base
 
16
end
 
17
 
 
18
class PostgresqlBitString < ActiveRecord::Base
 
19
end
 
20
 
 
21
class PostgresqlOid < ActiveRecord::Base
 
22
end
 
23
 
 
24
class PostgresqlDataTypeTest < ActiveRecord::TestCase
 
25
  self.use_transactional_fixtures = false
 
26
 
 
27
  def setup
 
28
    @connection = ActiveRecord::Base.connection
 
29
    @connection.execute("set lc_monetary = 'C'")
 
30
 
 
31
    @connection.execute("INSERT INTO postgresql_arrays (commission_by_quarter, nicknames) VALUES ( '{35000,21000,18000,17000}', '{foo,bar,baz}' )")
 
32
    @first_array = PostgresqlArray.find(1)
 
33
 
 
34
    @connection.execute("INSERT INTO postgresql_moneys (wealth) VALUES ('567.89'::money)")
 
35
    @connection.execute("INSERT INTO postgresql_moneys (wealth) VALUES ('-567.89'::money)")
 
36
    @first_money = PostgresqlMoney.find(1)
 
37
    @second_money = PostgresqlMoney.find(2)
 
38
 
 
39
    @connection.execute("INSERT INTO postgresql_numbers (single, double) VALUES (123.456, 123456.789)")
 
40
    @first_number = PostgresqlNumber.find(1)
 
41
 
 
42
    @connection.execute("INSERT INTO postgresql_times (time_interval) VALUES ('1 year 2 days ago')")
 
43
    @first_time = PostgresqlTime.find(1)
 
44
 
 
45
    @connection.execute("INSERT INTO postgresql_network_addresses (cidr_address, inet_address, mac_address) VALUES('192.168.0/24', '172.16.1.254/32', '01:23:45:67:89:0a')")
 
46
    @first_network_address = PostgresqlNetworkAddress.find(1)
 
47
 
 
48
    @connection.execute("INSERT INTO postgresql_bit_strings (bit_string, bit_string_varying) VALUES (B'00010101', X'15')")
 
49
    @first_bit_string = PostgresqlBitString.find(1)
 
50
 
 
51
    @connection.execute("INSERT INTO postgresql_oids (obj_id) VALUES (1234)")
 
52
    @first_oid = PostgresqlOid.find(1)
 
53
  end
 
54
 
 
55
  def test_data_type_of_array_types
 
56
    assert_equal :string, @first_array.column_for_attribute(:commission_by_quarter).type
 
57
    assert_equal :string, @first_array.column_for_attribute(:nicknames).type
 
58
  end
 
59
 
 
60
  def test_data_type_of_money_types
 
61
    assert_equal :decimal, @first_money.column_for_attribute(:wealth).type
 
62
  end
 
63
 
 
64
  def test_data_type_of_number_types
 
65
    assert_equal :float, @first_number.column_for_attribute(:single).type
 
66
    assert_equal :float, @first_number.column_for_attribute(:double).type
 
67
  end
 
68
 
 
69
  def test_data_type_of_time_types
 
70
    assert_equal :string, @first_time.column_for_attribute(:time_interval).type
 
71
  end
 
72
 
 
73
  def test_data_type_of_network_address_types
 
74
    assert_equal :string, @first_network_address.column_for_attribute(:cidr_address).type
 
75
    assert_equal :string, @first_network_address.column_for_attribute(:inet_address).type
 
76
    assert_equal :string, @first_network_address.column_for_attribute(:mac_address).type
 
77
  end
 
78
 
 
79
  def test_data_type_of_bit_string_types
 
80
    assert_equal :string, @first_bit_string.column_for_attribute(:bit_string).type
 
81
    assert_equal :string, @first_bit_string.column_for_attribute(:bit_string_varying).type
 
82
  end
 
83
 
 
84
  def test_data_type_of_oid_types
 
85
    assert_equal :integer, @first_oid.column_for_attribute(:obj_id).type
 
86
  end
 
87
 
 
88
  def test_array_values
 
89
   assert_equal '{35000,21000,18000,17000}', @first_array.commission_by_quarter
 
90
   assert_equal '{foo,bar,baz}', @first_array.nicknames
 
91
  end
 
92
 
 
93
  def test_money_values
 
94
    assert_equal 567.89, @first_money.wealth
 
95
    assert_equal -567.89, @second_money.wealth
 
96
  end
 
97
 
 
98
  def test_number_values
 
99
    assert_equal 123.456, @first_number.single
 
100
    assert_equal 123456.789, @first_number.double
 
101
  end
 
102
 
 
103
  def test_time_values
 
104
    assert_equal '-1 years -2 days', @first_time.time_interval
 
105
  end
 
106
 
 
107
  def test_network_address_values
 
108
    assert_equal '192.168.0.0/24', @first_network_address.cidr_address
 
109
    assert_equal '172.16.1.254', @first_network_address.inet_address
 
110
    assert_equal '01:23:45:67:89:0a', @first_network_address.mac_address
 
111
  end
 
112
 
 
113
  def test_bit_string_values
 
114
    assert_equal '00010101', @first_bit_string.bit_string
 
115
    assert_equal '00010101', @first_bit_string.bit_string_varying
 
116
  end
 
117
 
 
118
  def test_oid_values
 
119
    assert_equal 1234, @first_oid.obj_id
 
120
  end
 
121
 
 
122
  def test_update_integer_array
 
123
    new_value = '{32800,95000,29350,17000}'
 
124
    assert @first_array.commission_by_quarter = new_value
 
125
    assert @first_array.save
 
126
    assert @first_array.reload
 
127
    assert_equal @first_array.commission_by_quarter, new_value
 
128
    assert @first_array.commission_by_quarter = new_value
 
129
    assert @first_array.save
 
130
    assert @first_array.reload
 
131
    assert_equal @first_array.commission_by_quarter, new_value
 
132
  end
 
133
 
 
134
  def test_update_text_array
 
135
    new_value = '{robby,robert,rob,robbie}'
 
136
    assert @first_array.nicknames = new_value
 
137
    assert @first_array.save
 
138
    assert @first_array.reload
 
139
    assert_equal @first_array.nicknames, new_value
 
140
    assert @first_array.nicknames = new_value
 
141
    assert @first_array.save
 
142
    assert @first_array.reload
 
143
    assert_equal @first_array.nicknames, new_value
 
144
  end
 
145
 
 
146
  def test_update_money
 
147
    new_value = BigDecimal.new('123.45')
 
148
    assert @first_money.wealth = new_value
 
149
    assert @first_money.save
 
150
    assert @first_money.reload
 
151
    assert_equal new_value, @first_money.wealth
 
152
  end
 
153
 
 
154
  def test_update_number
 
155
    new_single = 789.012
 
156
    new_double = 789012.345
 
157
    assert @first_number.single = new_single
 
158
    assert @first_number.double = new_double
 
159
    assert @first_number.save
 
160
    assert @first_number.reload
 
161
    assert_equal @first_number.single, new_single
 
162
    assert_equal @first_number.double, new_double
 
163
  end
 
164
 
 
165
  def test_update_time
 
166
    assert @first_time.time_interval = '2 years 3 minutes'
 
167
    assert @first_time.save
 
168
    assert @first_time.reload
 
169
    assert_equal @first_time.time_interval, '2 years 00:03:00'
 
170
  end
 
171
 
 
172
  def test_update_network_address
 
173
    new_cidr_address = '10.1.2.3/32'
 
174
    new_inet_address = '10.0.0.0/8'
 
175
    new_mac_address = 'bc:de:f0:12:34:56'
 
176
    assert @first_network_address.cidr_address = new_cidr_address
 
177
    assert @first_network_address.inet_address = new_inet_address
 
178
    assert @first_network_address.mac_address = new_mac_address
 
179
    assert @first_network_address.save
 
180
    assert @first_network_address.reload
 
181
    assert_equal @first_network_address.cidr_address, new_cidr_address
 
182
    assert_equal @first_network_address.inet_address, new_inet_address
 
183
    assert_equal @first_network_address.mac_address, new_mac_address
 
184
  end
 
185
 
 
186
  def test_update_bit_string
 
187
    new_bit_string = '11111111'
 
188
    new_bit_string_varying = 'FF'
 
189
    assert @first_bit_string.bit_string = new_bit_string
 
190
    assert @first_bit_string.bit_string_varying = new_bit_string_varying
 
191
    assert @first_bit_string.save
 
192
    assert @first_bit_string.reload
 
193
    assert_equal @first_bit_string.bit_string, new_bit_string
 
194
    assert_equal @first_bit_string.bit_string, @first_bit_string.bit_string_varying
 
195
  end
 
196
 
 
197
  def test_update_oid
 
198
    new_value = 567890
 
199
    assert @first_oid.obj_id = new_value
 
200
    assert @first_oid.save
 
201
    assert @first_oid.reload
 
202
    assert_equal @first_oid.obj_id, new_value
 
203
  end
 
204
end