1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
require_relative "spec_helper"
describe "constant_sql_override extension" do
before do
@db = Sequel.mock.extension(:constant_sql_override)
end
it 'overrides configured constants' do
@db.set_constant_sql(Sequel::CURRENT_TIMESTAMP, "CURRENT TIMESTAMP AT TIME ZONE 'UTC'")
@db[:tbl].where(foo: Sequel::CURRENT_TIMESTAMP).first
@db.sqls.must_equal ["SELECT * FROM tbl WHERE (foo = CURRENT TIMESTAMP AT TIME ZONE 'UTC') LIMIT 1"]
end
it 'does not change behavior for unconfigured constants' do
@db[:tbl].where(foo: Sequel::CURRENT_TIMESTAMP).first
@db.sqls.must_equal ["SELECT * FROM tbl WHERE (foo = CURRENT_TIMESTAMP) LIMIT 1"]
end
it 'freezes the constant_sqls hash when frozen' do
@db.freeze
@db.constant_sqls.frozen?.must_equal true
proc{@db.set_constant_sql(Sequel::CURRENT_TIMESTAMP, "CURRENT TIMESTAMP AT TIME ZONE 'UTC'")}.must_raise RuntimeError
end
end
|
