test/chaining_test.rb in ambition-0.1.4 vs test/chaining_test.rb in ambition-0.1.5

- old
+ new

@@ -2,33 +2,33 @@ context "Chaining" do specify "should join selects with AND" do sql = User.select { |m| m.name == 'jon' } sql = sql.select { |m| m.age == 22 } - sql.to_sql.should == "SELECT * FROM users WHERE users.`name` = 'jon' AND users.`age` = 22" + sql.to_sql.should == "SELECT * FROM users WHERE users.name = 'jon' AND users.age = 22" end specify "should join sort_bys with a comma" do sql = User.select { |m| m.name == 'jon' } sql = sql.sort_by { |m| m.name } sql = sql.sort_by { |m| m.age } - sql.to_sql.should == "SELECT * FROM users WHERE users.`name` = 'jon' ORDER BY users.name, users.age" + sql.to_sql.should == "SELECT * FROM users WHERE users.name = 'jon' ORDER BY users.name, users.age" end specify "should join selects and sorts intelligently" do sql = User.select { |m| m.name == 'jon' } sql = sql.select { |m| m.age == 22 } sql = sql.sort_by { |m| -m.name } sql = sql.sort_by { |m| m.age } - sql.to_sql.should == "SELECT * FROM users WHERE users.`name` = 'jon' AND users.`age` = 22 ORDER BY users.name DESC, users.age" + sql.to_sql.should == "SELECT * FROM users WHERE users.name = 'jon' AND users.age = 22 ORDER BY users.name DESC, users.age" end specify "should join lots of selects and sorts intelligently" do sql = User.select { |m| m.name == 'jon' } sql = sql.select { |m| m.age == 22 } sql = sql.sort_by { |m| m.name } sql = sql.select { |m| m.power == true } sql = sql.sort_by { |m| m.email } sql = sql.select { |m| m.admin == true && m.email == 'chris@ozmm.org' } - sql.to_sql.should == "SELECT * FROM users WHERE users.`name` = 'jon' AND users.`age` = 22 AND users.`power` = 1 AND (users.`admin` = 1 AND users.`email` = 'chris@ozmm.org') ORDER BY users.name, users.email" + sql.to_sql.should == "SELECT * FROM users WHERE users.name = 'jon' AND users.age = 22 AND users.power = 1 AND (users.admin = 1 AND users.email = 'chris@ozmm.org') ORDER BY users.name, users.email" end end