From: Tom Willis <tom.willis@...>
Date: 2005-03-23T09:48:04+09:00
Subject: Re: Noob: DateTime /DBI/ActiveRecord possible error...who knows

On Mon, 21 Mar 2005 18:56:26 -0500, Tom Willis <tom.willis@gmail.com> wrote:
> OK, I feel I've done the due dilligence (googledilligence) and I can
> not figure this out.
> 
> I'm using ActiveRecord to hit mysql.
> 
> ddl: the tables relevant parts in question...
> ================================
> # Table: 'transactions'
> CREATE TABLE `pf_transactions` (
> #...
>   `entry_date` datetime NOT NULL,
>   `tran_date` datetime NOT NULL,
> #...
> ) TYPE=InnoDB;
> 
> The unit test code...
> ======================
> 
>                 entry_date = DateTime.new(2005,4,1)
>                 tran_date = DateTime.new(2005,4,1)
> 
>                 tran = PFTransaction.new("entry_date"=>entry_date,"tran_date"=>tran_date)
>                 tran.save
> 
>                 assert_not_nil tran.id #works
> 
>                 t2 = PFTransaction.find(tran.id) #works
>                 assert_not_nil t2 #works
>                 assert_equal t2.id,tran.id, "id" #works
>                 assert_equal t2.entry_date,tran.entry_date, "entry_date" #error
>                 assert_equal t2.tran_date,tran.tran_date,"tran_date" #error
> 
> output
> ================================
>         Loaded suite test_transactions
> Started
> E
> Finished in 2.396059 seconds.
> 
>   1) Error:
> test_transaction(TC_TestTransaction):
> NoMethodError: private method `gsub!' called for #<DateTime:
> 4906923/2,0,2299161>
>     /usr/lib/ruby/1.8/date/format.rb:253:in `_parse'
>     /usr/lib/ruby/1.8/parsedate.rb:9:in `parsedate'
>     /usr/local/lib/site_ruby/1.8/active_record/connection_adapters/abstract_adapter.rb:216:in
> `string_to_time'
>     /usr/local/lib/site_ruby/1.8/active_record/connection_adapters/abstract_adapter.rb:184:in
> `type_cast'
>     /usr/local/lib/site_ruby/1.8/active_record/base.rb:1151:in `read_attribute'
>     /usr/local/lib/site_ruby/1.8/active_record/base.rb:1128:in `method_missing'
>     test_transactions.rb:65:in `test_transaction'
> 
> 1 tests, 3 assertions, 0 failures, 1 errors
> So I guess my question is, is there a trick to getting DateTime values
> into out of Mysql through ruby dbi, and active_record?
> 
> I didn't get any hits that indicated this was a known bug and there
> was a workaround, so I'm assuming I'm doing something incorrectly.
> Here's to hoping.
> --
> Thomas G. Willis
> http://paperbackmusic.net
> 
Man, amazing what you find when you can look at the source code and
you are not afraid. I should learn my llesson.


Anyway, Using a Time.local instead of DateTime.new works as expected,
however Time.gm somehow gets translated to local somewhere between the
db and retrieval for evaluation.

Oh well, I can work with this.



-- 
Thomas G. Willis
http://paperbackmusic.net