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
|
require "cases/helper"
unless current_adapter?(:PostgreSQLAdapter) # PostgreSQL does not use type strigns for lookup
module ActiveRecord
module ConnectionAdapters
class TypeLookupTest < ActiveRecord::TestCase
setup do
@connection = ActiveRecord::Base.connection
end
def test_boolean_types
assert_lookup_type :boolean, 'boolean'
assert_lookup_type :boolean, 'BOOLEAN'
end
def test_string_types
assert_lookup_type :string, 'char'
assert_lookup_type :string, 'varchar'
assert_lookup_type :string, 'VARCHAR'
assert_lookup_type :string, 'varchar(255)'
assert_lookup_type :string, 'character varying'
end
def test_binary_types
assert_lookup_type :binary, 'binary'
assert_lookup_type :binary, 'BINARY'
assert_lookup_type :binary, 'blob'
assert_lookup_type :binary, 'BLOB'
end
def test_text_types
assert_lookup_type :text, 'text'
assert_lookup_type :text, 'TEXT'
assert_lookup_type :text, 'clob'
assert_lookup_type :text, 'CLOB'
end
def test_date_types
assert_lookup_type :date, 'date'
assert_lookup_type :date, 'DATE'
end
def test_time_types
assert_lookup_type :time, 'time'
assert_lookup_type :time, 'TIME'
end
def test_datetime_types
assert_lookup_type :datetime, 'datetime'
assert_lookup_type :datetime, 'DATETIME'
assert_lookup_type :datetime, 'timestamp'
assert_lookup_type :datetime, 'TIMESTAMP'
end
def test_decimal_types
assert_lookup_type :decimal, 'decimal'
assert_lookup_type :decimal, 'decimal(2,8)'
assert_lookup_type :decimal, 'DECIMAL'
assert_lookup_type :decimal, 'numeric'
assert_lookup_type :decimal, 'numeric(2,8)'
assert_lookup_type :decimal, 'NUMERIC'
assert_lookup_type :decimal, 'number'
assert_lookup_type :decimal, 'number(2,8)'
assert_lookup_type :decimal, 'NUMBER'
end
def test_float_types
assert_lookup_type :float, 'float'
assert_lookup_type :float, 'FLOAT'
assert_lookup_type :float, 'double'
assert_lookup_type :float, 'DOUBLE'
end
def test_integer_types
assert_lookup_type :integer, 'integer'
assert_lookup_type :integer, 'INTEGER'
assert_lookup_type :integer, 'tinyint'
assert_lookup_type :integer, 'smallint'
assert_lookup_type :integer, 'bigint'
end
def test_bigint_limit
cast_type = @connection.type_map.lookup("bigint")
if current_adapter?(:OracleAdapter)
assert_equal 19, cast_type.limit
else
assert_equal 8, cast_type.limit
end
end
def test_decimal_without_scale
types = %w{decimal(2) decimal(2,0) numeric(2) numeric(2,0) number(2) number(2,0)}
types.each do |type|
cast_type = @connection.type_map.lookup(type)
assert_equal :decimal, cast_type.type
assert_equal 2, cast_type.cast(2.1)
end
end
private
def assert_lookup_type(type, lookup)
cast_type = @connection.type_map.lookup(lookup)
assert_equal type, cast_type.type
end
end
end
end
end
|