On Friday, July 20, 2018 at 11:17:42 AM UTC-7, Steven Schreck wrote:
>
>
> I am using Sequel to connect to an Oracle DB via JRuby. I am using it as a
> simple data adapter through which I execute raw sql queries and return the
> data in a hash. The way I'm doing this is:
> my_hash = db_conn.fetch(sql_query).all
>
> If the table being queried has numeric or decimal fields, the data type
> returned in the hash looks like this:
> :model_yr=>#<BigDecimal:15d0849,'0.12345E4',1(4)>
>
> Is there an easy way to get rid of the BigDecimal exponent and object
> garbage and just return the value? :model_yr=>1234.5
>
Call to_f on the value to convert from BigDecimal to Float, if you don't
mind the possible loss of precision. Make sure you don't do this if
precision may be important.
In terms of doing this automatically, you would have to override
Dataset#type_convertor appropriately. Review how the jdbc/oracle adapter
does that as well as the JDBC documentation, and then do something like:
DB.extend_datasets do
def type_convertor(map, meta, type, i)
case type
when Java::JavaSQL::Types::NUMERIC
lambda{|r, i| r.getDouble(i)}
else
super
end
end
end
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
