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 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/CAFKVRj8h69dp7uoW1cdiMDwJ-Nqa__bCu7RMYcU35LjgXzzb0w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.