spec/extensions/table_select_spec.rb in sequel-4.22.0 vs spec/extensions/table_select_spec.rb in sequel-4.23.0

- old
+ new

@@ -5,67 +5,67 @@ @Album = Class.new(Sequel::Model(Sequel.mock[:albums])) end it "should add a table.* selection to existing dataset without explicit selection" do @Album.plugin :table_select - @Album.dataset.sql.should == 'SELECT albums.* FROM albums' + @Album.dataset.sql.must_equal 'SELECT albums.* FROM albums' @Album.dataset = :albs - @Album.dataset.sql.should == 'SELECT albs.* FROM albs' + @Album.dataset.sql.must_equal 'SELECT albs.* FROM albs' @Album.dataset = Sequel.identifier(:albs) - @Album.dataset.sql.should == 'SELECT albs.* FROM albs' + @Album.dataset.sql.must_equal 'SELECT albs.* FROM albs' end it "should handle qualified tables" do @Album.dataset = :s__albums @Album.plugin :table_select - @Album.dataset.sql.should == 'SELECT s.albums.* FROM s.albums' + @Album.dataset.sql.must_equal 'SELECT s.albums.* FROM s.albums' @Album.dataset = Sequel.qualify(:s2, :albums) - @Album.dataset.sql.should == 'SELECT s2.albums.* FROM s2.albums' + @Album.dataset.sql.must_equal 'SELECT s2.albums.* FROM s2.albums' end it "should handle aliases" do @Album.dataset = :albums___a @Album.plugin :table_select - @Album.dataset.sql.should == 'SELECT a.* FROM albums AS a' + @Album.dataset.sql.must_equal 'SELECT a.* FROM albums AS a' @Album.dataset = Sequel.as(:albums, :b) - @Album.dataset.sql.should == 'SELECT b.* FROM albums AS b' + @Album.dataset.sql.must_equal 'SELECT b.* FROM albums AS b' @Album.dataset = :s__albums___a - @Album.dataset.sql.should == 'SELECT a.* FROM s.albums AS a' + @Album.dataset.sql.must_equal 'SELECT a.* FROM s.albums AS a' @Album.dataset = @Album.db[:albums].from_self - @Album.dataset.sql.should == 'SELECT t1.* FROM (SELECT * FROM albums) AS t1' + @Album.dataset.sql.must_equal 'SELECT t1.* FROM (SELECT * FROM albums) AS t1' @Album.dataset = Sequel.as(@Album.db[:albums], :b) - @Album.dataset.sql.should == 'SELECT b.* FROM (SELECT * FROM albums) AS b' + @Album.dataset.sql.must_equal 'SELECT b.* FROM (SELECT * FROM albums) AS b' end it "should not add a table.* selection on existing dataset with explicit selection" do @Album.dataset = @Album.dataset.select(:name) @Album.plugin :table_select - @Album.dataset.sql.should == 'SELECT name FROM albums' + @Album.dataset.sql.must_equal 'SELECT name FROM albums' @Album.dataset = @Album.dataset.select(:name, :artist) - @Album.dataset.sql.should == 'SELECT name, artist FROM albums' + @Album.dataset.sql.must_equal 'SELECT name, artist FROM albums' end it "should not add a table.* selection on existing dataset with multiple tables" do @Album.dataset = @Album.db.from(:a1, :a2) @Album.plugin :table_select - @Album.dataset.sql.should == 'SELECT * FROM a1, a2' + @Album.dataset.sql.must_equal 'SELECT * FROM a1, a2' @Album.dataset = @Album.db.from(:a1).cross_join(:a2) - @Album.dataset.sql.should == 'SELECT * FROM a1 CROSS JOIN a2' + @Album.dataset.sql.must_equal 'SELECT * FROM a1 CROSS JOIN a2' end it "works correctly when loaded on model without a dataset" do c = Class.new(Sequel::Model) c.plugin :table_select sc = Class.new(c) sc.dataset = :a - sc.dataset.sql.should == "SELECT a.* FROM a" + sc.dataset.sql.must_equal "SELECT a.* FROM a" end end