On Wednesday, April 29, 2015 at 3:17:32 PM UTC-7, Rohit Amarnath wrote:
>
> Running it directly in jdbc-sqlite3:
>
> [1] pry(#<Dragonfly::Routes>)> rs.getString(5)
> => "55.366667"
> [2] pry(#<Dragonfly::Routes>)> rs.getFloat(5)
> => 55.366668701171875
> [3] pry(#<Dragonfly::Routes>)> rs.getDouble(5)
> => 55.366667
>
> Is there a way in Sequel to have return the Double and not the Float?
>
I tried to replicate this on jdbc/sqlite, but I wasn't able to:
$ jruby bin/sequel -E jdbc:sqlite::memory:
I, [2015-04-29T15:47:30.641000 #10462] INFO -- : (0.002000s) PRAGMA
foreign_keys = 1
I, [2015-04-29T15:47:30.842000 #10462] INFO -- : (0.002000s) PRAGMA
case_sensitive_like = 1
Your database is stored in DB...
irb(main):001:0> DB.create_table(:a){real :a}
I, [2015-04-29T15:47:35.167000 #10462] INFO -- : (0.022000s) CREATE TABLE
`a` (`a` real)
=> nil
irb(main):002:0> DB[:a].insert 55.366667
I, [2015-04-29T15:47:39.487000 #10462] INFO -- : (0.016000s) SELECT
sqlite_version()
I, [2015-04-29T15:47:39.499000 #10462] INFO -- : (0.005000s) INSERT INTO
`a` VALUES (55.366667)
=> 1
irb(main):003:0> DB[:a].all
I, [2015-04-29T15:47:43.373000 #10462] INFO -- : (0.003000s) SELECT * FROM
`a`
=> [{:a=>55.366667}]
However, I am using jdbc-sqlite3 3.7.2.1, maybe this is a regression in
later jdbc-sqlite3 versions.
You can try the following, it may work:
DB.type_convertor_map[Java::JavaSQL::Types::REAL] =
Sequel::JDBC::TypeConvertor::INSTANCE.method(:Double)
Thanks,
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 http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
