Michael,

My bad toLocaleFormat work for JS , Can you try this ? to convert into a
database friendly format. source
<http://stackoverflow.com/questions/1255983/ruby-datetime-suitable-for-mysql-comparison>

activated_at: <%= Time.zone.now.to_s(:db) %>




On Sat, Dec 20, 2014 at 3:15 AM, Michael Sutyak <msut...@gmail.com> wrote:

> HI Vivek,
>
> I got these new errors:
>
>   1) Error:
> UserMailerTest#test_account_activation:
> NoMethodError: undefined method `toLocaleFormat' for Fri, 19 Dec 2014
> 21:44:44 UTC +00:00:Time
>
>
>
>   2) Error:
> UserMailerTest#test_password_reset:
> NoMethodError: undefined method `toLocaleFormat' for Fri, 19 Dec 2014
> 21:44:44 UTC +00:00:Time
>
>
> On Thu, Dec 18, 2014 at 9:27 PM, Vivek Sampara <ravensnowb...@gmail.com>
> wrote:
>>
>> Try toLocaleFormat()
>>
>> On Fri, Dec 19, 2014 at 6:24 AM, Michael Sutyak <msut...@gmail.com>
>> wrote:
>>
>>> am running a test with mailers within Ruby on Rails, and I am getting
>>> the following errors:
>>>
>>> *********-C02MGBVJFD57:myapp ************$ bundle exec rake test:mailers
>>> # Running:
>>>
>>> EE
>>> Finished in 0.110500s, 18.0995 runs/s, 0.0000 assertions/s.
>>>
>>>   1) 
>>> Error:UserMailerTest#test_account_activation:ActiveRecord::StatementInvalid:
>>>  Mysql2::Error: Incorrect datetime value: '2014-12-18 01:07:49 UTC' for 
>>> column 'activated_at' at row 1: INSERT INTO `users` (`name`, `email`, 
>>> `password_digest`, `admin`, `activated`, `activated_at`, `created_at`, 
>>> `updated_at`, `id`) VALUES ('Michael Example', 'mich...@example.com', 
>>> '$2a$04$hz6pvZctid6gZEuv0.qAe.0mEfbEjxso9GrXwC3yHRhIThIJ7Vx5m', 1, 1, 
>>> '2014-12-18 01:07:49 UTC', '2014-12-18 01:07:49', '2014-12-18 01:07:49', 
>>> 762146111)
>>>
>>>
>>>
>>>   2) 
>>> Error:UserMailerTest#test_password_reset:ActiveRecord::StatementInvalid: 
>>> Mysql2::Error: Incorrect datetime value: '2014-12-18 01:07:49 UTC' for 
>>> column 'activated_at' at row 1: INSERT INTO `users` (`name`, `email`, 
>>> `password_digest`, `admin`, `activated`, `activated_at`, `created_at`, 
>>> `updated_at`, `id`) VALUES ('Michael Example', 'mich...@example.com', 
>>> '$2a$04$XTAWn5P9kikgOXqxQgiJqOjP027p4HnucHZ6pth2aaLwolaFcehsm', 1, 1, 
>>> '2014-12-18 01:07:49 UTC', '2014-12-18 01:07:49', '2014-12-18 01:07:49', 
>>> 762146111)
>>>
>>> 2 runs, 0 assertions, 0 failures, 2 errors, 0 skips
>>>
>>> When I check my fixtures users.yml file, I see that I am using the time
>>> zone ruby stamp:
>>>
>>> michael:
>>>   name: Michael Example
>>>   email: mich...@example.com
>>>   password_digest: <%= User.digest('password') %>
>>>   admin: true
>>>   activated: true
>>>   activated_at: <%= Time.zone.now %>
>>>
>>> archer:
>>>   name: Sterling Archer
>>>   email: duch...@example.gov
>>>   password_digest: <%= User.digest('password') %>
>>>   activated: true
>>>   activated_at: <%= Time.zone.now %>
>>>
>>> lana:
>>>   name: Lana Kane
>>>   email: ha...@example.gov
>>>   password_digest: <%= User.digest('password') %>
>>>   activated: true
>>>   activated_at: <%= Time.zone.now %>
>>>
>>> mallory:
>>>   name: Mallory Archer
>>>   email: b...@example.gov
>>>   password_digest: <%= User.digest('password') %>
>>>   activated: true
>>>   activated_at: <%= Time.zone.now %>
>>> <% 30.times do |n| %>
>>> user_<%= n %>:
>>>   name:  <%= "User #{n}" %>
>>>   email: <%= "user-#{n}@example.com" %>
>>>   password_digest: <%= User.digest('password') %>
>>>   activated: true
>>>   activated_at: <%= Time.zone.now %><% end %>
>>>
>>> and my db/seeds.rb file looks like so:
>>>
>>> User.create!(name:  "Example User",
>>>              email: "exam...@railstutorial.org",
>>>              password:              "foobar",
>>>              password_confirmation: "foobar",
>>>              admin: true,
>>>              activated: true,
>>>              activated_at: Time.zone.now)
>>> 99.times do |n|
>>>   name  = Faker::Name.name
>>>   email = "example-#{n+1}@railstutorial.org"
>>>   password = "password"
>>>   User.create!(name:  name,
>>>                email: email,
>>>                password:              password,
>>>                password_confirmation: password,
>>>                activated: true,
>>>                activated_at: Time.zone.now)end
>>>
>>> So I should be using the right time form.
>>>
>>> Here is the test itself:
>>>
>>> user_mailer_test.rb:
>>>
>>> require 'test_helper'
>>>
>>> class UserMailerTest < ActionMailer::TestCase
>>>
>>>   test "account_activation" do
>>>     mail = UserMailer.account_activation
>>>     assert_equal "Account activation", mail.subject
>>>     assert_equal ["t...@example.org"], mail.to
>>>     assert_equal ["f...@example.com"], mail.from
>>>     assert_match "Hi", mail.body.encoded
>>>   end
>>>
>>>   test "password_reset" do
>>>     mail = UserMailer.password_reset
>>>     assert_equal "Password reset", mail.subject
>>>     assert_equal ["t...@example.org"], mail.to
>>>     assert_equal ["f...@example.com"], mail.from
>>>     assert_match "Hi", mail.body.encoded
>>>   end
>>> end
>>>
>>> Is there something I am doing wrong? Thank you for your help.
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Ruby on Rails: Talk" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to rubyonrails-talk+unsubscr...@googlegroups.com.
>>> To post to this group, send email to rubyonrails-talk@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/rubyonrails-talk/7c779d06-608c-46ac-ad27-15bda1365bf1%40googlegroups.com
>>> <https://groups.google.com/d/msgid/rubyonrails-talk/7c779d06-608c-46ac-ad27-15bda1365bf1%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>  --
>> You received this message because you are subscribed to a topic in the
>> Google Groups "Ruby on Rails: Talk" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/rubyonrails-talk/UDImbwXMpso/unsubscribe
>> .
>> To unsubscribe from this group and all its topics, send an email to
>> rubyonrails-talk+unsubscr...@googlegroups.com.
>> To post to this group, send email to rubyonrails-talk@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/rubyonrails-talk/CAFKVRj8h69dp7uoW1cdiMDwJ-Nqa__bCu7RMYcU35LjgXzzb0w%40mail.gmail.com
>> <https://groups.google.com/d/msgid/rubyonrails-talk/CAFKVRj8h69dp7uoW1cdiMDwJ-Nqa__bCu7RMYcU35LjgXzzb0w%40mail.gmail.com?utm_medium=email&utm_source=footer>
>> .
>>
>> For more options, visit https://groups.google.com/d/optout.
>>
>  --
> You received this message because you are subscribed to the Google Groups
> "Ruby on Rails: Talk" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rubyonrails-talk+unsubscr...@googlegroups.com.
> To post to this group, send email to rubyonrails-talk@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rubyonrails-talk/CAMbJeJhZbg4NMrpLMcJAAfCYkhAGH4X0%2BOHDrmLYV8kdtFG6bg%40mail.gmail.com
> <https://groups.google.com/d/msgid/rubyonrails-talk/CAMbJeJhZbg4NMrpLMcJAAfCYkhAGH4X0%2BOHDrmLYV8kdtFG6bg%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rubyonrails-talk+unsubscr...@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rubyonrails-talk/CAFKVRj_rKVkxcUhNQFUmq2GYw9cnugyfR5972fpSTwRiKvyhqA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to