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

Version Path
sequel-4.22.0 spec/extensions/filter_having_spec.rb
sequel-4.21.0 spec/extensions/filter_having_spec.rb
sequel-4.20.0 spec/extensions/filter_having_spec.rb
sequel-4.19.0 spec/extensions/filter_having_spec.rb
sequel-4.18.0 spec/extensions/filter_having_spec.rb
sequel-4.17.0 spec/extensions/filter_having_spec.rb
sequel-4.16.0 spec/extensions/filter_having_spec.rb
asana2flowdock-1.0.0 vendor/bundle/ruby/1.9.1/gems/sequel-4.15.0/spec/extensions/filter_having_spec.rb
sequel-4.15.0 spec/extensions/filter_having_spec.rb
sequel-4.14.0 spec/extensions/filter_having_spec.rb
sequel-4.13.0 spec/extensions/filter_having_spec.rb
sequel-4.12.0 spec/extensions/filter_having_spec.rb
sequel-4.11.0 spec/extensions/filter_having_spec.rb
sequel-4.10.0 spec/extensions/filter_having_spec.rb
sequel-4.9.0 spec/extensions/filter_having_spec.rb
sequel-4.8.0 spec/extensions/filter_having_spec.rb
sequel-4.7.0 spec/extensions/filter_having_spec.rb
sequel-4.6.0 spec/extensions/filter_having_spec.rb
sequel-4.5.0 spec/extensions/filter_having_spec.rb
sequel-4.4.0 spec/extensions/filter_having_spec.rb