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
|
# frozen-string-literal: true
#
# The LooserTypecasting extension loosens the default database typecasting
# for the following types:
#
# :float :: use to_f instead of Float()
# :integer :: use to_i instead of Integer()
# :decimal :: use 0.0 for unsupported strings
# :string :: silently allow hash and array conversion to string
#
# This also removes bytesize checks for string inputs for float, integer
# and decimal conversions.
#
# To load the extension into the database:
#
# DB.extension :looser_typecasting
#
# Related module: Sequel::LooserTypecasting
#
module Sequel
module LooserTypecasting
private
# Typecast the value to a Float using to_f instead of Kernel.Float
def typecast_value_float(value)
value.to_f
end
# Typecast the value to an Integer using to_i instead of Kernel.Integer
def typecast_value_integer(value)
value.to_i
end
# Typecast the value to an String using to_s instead of Kernel.String
def typecast_value_string(value)
value.to_s
end
# Typecast invalid BigDecimal to 0.0.
def _typecast_value_string_to_decimal(value)
BigDecimal(value)
rescue
BigDecimal('0.0')
end
end
Database.register_extension(:looser_typecasting, LooserTypecasting)
end
|
