Sha256: d77ca52d7825d70027bbb330b490ad7dc4213ad8611022ad17643e3e20b97908
Contents?: true
Size: 1.35 KB
Versions: 13
Compression:
Stored size: 1.35 KB
Contents
require File.join(File.dirname(File.expand_path(__FILE__)), "spec_helper")
describe "filter_having extension" do
before do
@dataset = Sequel.mock[:test].extension(:empty_array_consider_nulls)
end
it "should handle all types of IN/NOT IN queries with empty arrays" do
@dataset.filter(:id => []).sql.must_equal "SELECT * FROM test WHERE (id != id)"
@dataset.filter([:id1, :id2] => []).sql.must_equal "SELECT * FROM test WHERE ((id1 != id1) AND (id2 != id2))"
@dataset.exclude(:id => []).sql.must_equal "SELECT * FROM test WHERE (id = id)"
@dataset.exclude([:id1, :id2] => []).sql.must_equal "SELECT * FROM test WHERE ((id1 = id1) AND (id2 = id2))"
end
it "should handle IN/NOT IN queries with multiple columns and an empty dataset where the database doesn't support it" do
db = Sequel.mock
d1 = db[:test].select(:id1, :id2).filter(:region=>'Asia').columns(:id1, :id2)
@dataset = @dataset.with_extend{def supports_multiple_column_in?; false end}
@dataset.filter([:id1, :id2] => d1).sql.must_equal "SELECT * FROM test WHERE ((id1 != id1) AND (id2 != id2))"
db.sqls.must_equal ["SELECT id1, id2 FROM test WHERE (region = 'Asia')"]
@dataset.exclude([:id1, :id2] => d1).sql.must_equal "SELECT * FROM test WHERE ((id1 = id1) AND (id2 = id2))"
db.sqls.must_equal ["SELECT id1, id2 FROM test WHERE (region = 'Asia')"]
end
end
Version data entries
13 entries across 11 versions & 2 rubygems