1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54

require 'rubygems'
require 'activesupport'
require 'activerecord'

require 'bacon'
Bacon.summary_on_exit

require 'facon'
require 'sqlite3'
 
ENV['TZ'] = 'UTC'
 
ActiveRecord::Base.time_zone_aware_attributes = true
 
ActiveRecord::Base.establish_connection :adapter => "sqlite3", :database  => ":memory:"
 
class CreateEvents < ActiveRecord::Migration
  def self.up
    create_table :events do |t|
      t.datetime :scheduled_at
      t.timestamps
    end
  end
 
  def self.down
    drop_table :events
  end
end
 
class Event < ActiveRecord::Base; end
 
CreateEvents.down rescue puts("Down failed because db doesn't exist")
CreateEvents.up
 
describe "time zones working great" do
  before do
    Time.zone = "Sydney"
    @events = [
      Event.create!(:scheduled_at => "2009-10-05 23:59"),
      Event.create!(:scheduled_at => "2009-10-06 00:00"),
      Event.create!(:scheduled_at => "2009-10-06 23:59"),
      Event.create!(:scheduled_at => "2009-10-07 00:00")
    ]
  end
  after do
    Event.destroy_all
  end
  describe "find on scheduled_at" do
    it "finds the event using interpolated conditions and a time in utc" do
      day = Time.zone.parse("2009-10-06 00:00").utc
      Event.all(:conditions => {:scheduled_at => day...(day+1.day)}).should.equal([@events[1], @events[2]])
    end
  end
end