Sha256: 470a11be55bc3f3468f192f50532a180d380e0261419a4f8eac6508562f4e8ad
Contents?: true
Size: 1.88 KB
Versions: 10
Compression:
Stored size: 1.88 KB
Contents
require File.join(File.dirname(__FILE__), 'spec_helper.rb')
describe "Sequel timezone support" do
def test_timezone
t = Time.now
@db[:t].insert(t)
t2 = @db[:t].single_value
t2 = Sequel.database_to_application_timestamp(t2.to_s) unless t2.is_a?(Time)
(t2 - t).should be_close(0, 2)
t2.utc_offset.should == 0 if Sequel.application_timezone == :utc
t2.utc_offset.should == t.getlocal.utc_offset if Sequel.application_timezone == :local
@db[:t].delete
dt = DateTime.now
Sequel.datetime_class = DateTime
@db[:t].insert(dt)
dt2 = @db[:t].single_value
dt2 = Sequel.database_to_application_timestamp(dt2.to_s) unless dt2.is_a?(DateTime)
(dt2 - dt).should be_close(0, 0.00002)
dt2.offset.should == 0 if Sequel.application_timezone == :utc
dt2.offset.should == dt.offset if Sequel.application_timezone == :local
end
before do
@db = INTEGRATION_DB
@db.create_table!(:t){DateTime :t}
end
after do
@db.drop_table(:t)
Sequel.default_timezone = nil
Sequel.datetime_class = Time
end
cspecify "should support using UTC for database storage and local time for the application", [:do, proc{|db| db.database_type != :sqlite}] do
Sequel.database_timezone = :utc
Sequel.application_timezone = :local
test_timezone
end
cspecify "should support using local time for database storage and UTC for the application", [:do, proc{|db| db.database_type != :sqlite}] do
Sequel.database_timezone = :local
Sequel.application_timezone = :utc
test_timezone
end
cspecify "should support using UTC for both database storage and for application", [:do, proc{|db| db.database_type != :sqlite}] do
Sequel.default_timezone = :utc
test_timezone
end
specify "should support using local time for both database storage and for application" do
Sequel.default_timezone = :local
test_timezone
end
end
Version data entries
10 entries across 10 versions & 2 rubygems