Sha256: dd31f8ca8394bda63b73c9c96a786a63d79de9337a8b13902e31d6b7a5f79697
Contents?: true
Size: 1.48 KB
Versions: 26
Compression:
Stored size: 1.48 KB
Contents
require File.join(File.dirname(File.expand_path(__FILE__)), "spec_helper") describe "filter_having extension" do before do @ds = Sequel.mock[:t].extension(:filter_having) @dsh = @ds.having(:a) end it "should make filter operate on HAVING clause if dataset has a HAVING clause" do @dsh.filter(:b).sql.should == 'SELECT * FROM t HAVING (a AND b)' end it "should make filter operate on WHERE clause if dataset does not have a HAVING clause" do @ds.filter(:b).sql.should == 'SELECT * FROM t WHERE b' end it "should make and operate on HAVING clause if dataset has a HAVING clause" do @dsh.and(:b).sql.should == 'SELECT * FROM t HAVING (a AND b)' end it "should make and operate on WHERE clause if dataset does not have a HAVING clause" do @ds.where(:a).and(:b).sql.should == 'SELECT * FROM t WHERE (a AND b)' end it "should make or operate on HAVING clause if dataset has a HAVING clause" do @dsh.or(:b).sql.should == 'SELECT * FROM t HAVING (a OR b)' end it "should make or operate on WHERE clause if dataset does not have a HAVING clause" do @ds.where(:a).or(:b).sql.should == 'SELECT * FROM t WHERE (a OR b)' end it "should make exclude operate on HAVING clause if dataset has a HAVING clause" do @dsh.exclude(:b).sql.should == 'SELECT * FROM t HAVING (a AND NOT b)' end it "should make exclude operate on WHERE clause if dataset does not have a HAVING clause" do @ds.exclude(:b).sql.should == 'SELECT * FROM t WHERE NOT b' end end
Version data entries
26 entries across 26 versions & 2 rubygems