1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
require_relative "spec_helper"
describe "pg_timestamptz extension" do
before do
@db = Sequel.mock(:host=>'postgres').extension :pg_timestamptz
end
it "should use timestamptz as default timestamp type" do
@db.create_table(:t){Time :t; DateTime :tz; Time :ot, :only_time=>true}
@db.sqls.must_equal ['CREATE TABLE "t" ("t" timestamptz, "tz" timestamptz, "ot" time)']
end
it "should use timestamptz when casting" do
@db.get(Sequel.cast('a', Time))
@db.sqls.must_equal ["SELECT CAST('a' AS timestamptz) AS \"v\" LIMIT 1"]
end
end
|
