From 885a3acb1ce183189b8628f14fa834b3e1ba39ec Mon Sep 17 00:00:00 2001 From: Aaron Patterson Date: Mon, 18 Apr 2011 09:40:47 -0700 Subject: adding a spec to demonstrate subqueries --- test/test_select_manager.rb | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'test/test_select_manager.rb') diff --git a/test/test_select_manager.rb b/test/test_select_manager.rb index 2e6844965b..351d8d321b 100644 --- a/test/test_select_manager.rb +++ b/test/test_select_manager.rb @@ -105,6 +105,18 @@ module Arel as = manager.as('foo') assert_kind_of Arel::Nodes::SqlLiteral, as.right end + + it 'can make a subselect' do + manager = Arel::SelectManager.new Table.engine + manager.project Arel.star + manager.from Arel.sql('zomg') + as = manager.as(Arel.sql('foo')) + + manager = Arel::SelectManager.new Table.engine + manager.project Arel.sql('name') + manager.from as + manager.to_sql.must_be_like "SELECT name FROM (SELECT * FROM zomg ) foo" + end end describe 'from' do -- cgit v1.2.3