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
|
require_relative "spec_helper"
describe "pg_extended_integer_support extension" do
before do
@db = Sequel.mock(:host=>'postgres').extension(:pg_extended_integer_support)
end
it "should literalize integers out of range using single quotes by default" do
@db.literal(2**63).must_equal "'9223372036854775808'"
end
it "should literalize integers out of range without quotes when configured with :raw strategy" do
@db.dataset.integer_outside_bigint_range_strategy(:raw).literal(2**63).must_equal "9223372036854775808"
end
it "should raise for integers out of range when configured with :raise strategy" do
ds = @db.dataset.integer_outside_bigint_range_strategy(:raise)
proc{ds.literal(2**63)}.must_raise Sequel::InvalidValue
end
it "should raise for integers out of range when configured with :quote strategy" do
@db.dataset.integer_outside_bigint_range_strategy(:quote).literal(2**63).must_equal "'9223372036854775808'"
end
it "should respect :integer_outside_bigint_range_strategy Database option for strategy" do
@db.opts[:integer_outside_bigint_range_strategy] = :raw
@db.literal(2**63).must_equal "9223372036854775808"
@db.opts[:integer_outside_bigint_range_strategy] = :quote
@db.literal(2**63).must_equal "'9223372036854775808'"
@db.opts[:integer_outside_bigint_range_strategy] = :raise
proc{@db.literal(2**63)}.must_raise Sequel::InvalidValue
end
end
|
