aboutsummaryrefslogtreecommitdiffstats
path: root/test/test_select_manager.rb
diff options
context:
space:
mode:
authorArthur Taylor <arthur@aupeo.com>2011-04-28 10:11:50 +0200
committerArthur Taylor <arthur@aupeo.com>2011-04-28 10:11:50 +0200
commit85882d1b26b033afb2643865afe6410673949d32 (patch)
tree0d98d8d0711564635ebf0b61964685267c63d3f5 /test/test_select_manager.rb
parent8a8d396cae40f272eb8c76df2e743d53fc9a8c0b (diff)
downloadrails-85882d1b26b033afb2643865afe6410673949d32.tar.gz
rails-85882d1b26b033afb2643865afe6410673949d32.tar.bz2
rails-85882d1b26b033afb2643865afe6410673949d32.zip
Add support for ordering on expressions
Conflicts: lib/arel.rb lib/arel/attributes/attribute.rb lib/arel/nodes/infix_operation.rb lib/arel/nodes/named_function.rb Conflicts: lib/arel.rb lib/arel/attributes/attribute.rb
Diffstat (limited to 'test/test_select_manager.rb')
-rw-r--r--test/test_select_manager.rb23
1 files changed, 23 insertions, 0 deletions
diff --git a/test/test_select_manager.rb b/test/test_select_manager.rb
index 8de1520b6f..29d317e16a 100644
--- a/test/test_select_manager.rb
+++ b/test/test_select_manager.rb
@@ -484,6 +484,29 @@ module Arel
manager = Arel::SelectManager.new Table.engine
manager.order(table[:id]).must_equal manager
end
+
+ it 'has order attributes' do
+ table = Table.new :users
+ manager = Arel::SelectManager.new Table.engine
+ manager.project SqlLiteral.new '*'
+ manager.from table
+ manager.order table[:id].desc
+ manager.to_sql.must_be_like %{
+ SELECT * FROM "users" ORDER BY "users"."id" DESC
+ }
+ end
+
+ it 'has order attributes for expressions' do
+ table = Table.new :users
+ manager = Arel::SelectManager.new Table.engine
+ manager.project SqlLiteral.new '*'
+ manager.from table
+ manager.order table[:id].count.desc
+ manager.to_sql.must_be_like %{
+ SELECT * FROM "users" ORDER BY COUNT("users"."id") DESC
+ }
+ end
+
end
describe 'on' do