./test/order_test.rb in ambition-0.1.4 vs ./test/order_test.rb in ambition-0.1.5
- old
+ new
@@ -5,41 +5,41 @@
@sql = User.select { |m| m.name == 'jon' }
end
specify "simple order" do
string = @sql.sort_by { |m| m.name }.to_sql
- string.should == "SELECT * FROM users WHERE users.`name` = 'jon' ORDER BY users.name"
+ string.should == "SELECT * FROM users WHERE users.name = 'jon' ORDER BY users.name"
end
specify "simple combined order" do
string = @sql.sort_by { |m| [ m.name, m.age ] }.to_sql
- string.should == "SELECT * FROM users WHERE users.`name` = 'jon' ORDER BY users.name, users.age"
+ string.should == "SELECT * FROM users WHERE users.name = 'jon' ORDER BY users.name, users.age"
end
specify "simple combined order with single reverse" do
string = @sql.sort_by { |m| [ m.name, -m.age ] }.to_sql
- string.should == "SELECT * FROM users WHERE users.`name` = 'jon' ORDER BY users.name, users.age DESC"
+ string.should == "SELECT * FROM users WHERE users.name = 'jon' ORDER BY users.name, users.age DESC"
end
specify "simple combined order with two reverses" do
string = @sql.sort_by { |m| [ -m.name, -m.age ] }.to_sql
- string.should == "SELECT * FROM users WHERE users.`name` = 'jon' ORDER BY users.name DESC, users.age DESC"
+ string.should == "SELECT * FROM users WHERE users.name = 'jon' ORDER BY users.name DESC, users.age DESC"
end
specify "reverse order with -" do
string = @sql.sort_by { |m| -m.age }.to_sql
- string.should == "SELECT * FROM users WHERE users.`name` = 'jon' ORDER BY users.age DESC"
+ string.should == "SELECT * FROM users WHERE users.name = 'jon' ORDER BY users.age DESC"
end
xspecify "reverse order with #reverse" do
# TODO: not implemented
string = @sql.sort_by { |m| m.age }.reverse.to_sql
- string.should == "SELECT * FROM users WHERE users.`name` = 'jon' ORDER BY users.age DESC"
+ string.should == "SELECT * FROM users WHERE users.name = 'jon' ORDER BY users.age DESC"
end
specify "random order" do
string = @sql.sort_by { rand }.to_sql
- string.should == "SELECT * FROM users WHERE users.`name` = 'jon' ORDER BY RAND()"
+ string.should == "SELECT * FROM users WHERE users.name = 'jon' ORDER BY RAND()"
end
specify "non-existent method to sort by" do
should.raise { @sql.sort_by { foo }.to_sql }
end