From c001fadd2f2f420267db809439581e388684e9de Mon Sep 17 00:00:00 2001 From: "Suraj N. Kurapati" Date: Sat, 22 Sep 2012 15:27:10 -0700 Subject: to_sql: add support for emitting SQL subqueries --- lib/arel/visitors/to_sql.rb | 4 ++++ test/visitors/test_to_sql.rb | 5 +++++ 2 files changed, 9 insertions(+) diff --git a/lib/arel/visitors/to_sql.rb b/lib/arel/visitors/to_sql.rb index a350daa3da..f5be934ba5 100644 --- a/lib/arel/visitors/to_sql.rb +++ b/lib/arel/visitors/to_sql.rb @@ -254,6 +254,10 @@ key on UpdateManager using UpdateManager#key= "(#{visit o.expr})" end + def visit_Arel_SelectManager o + "(#{o.to_sql.rstrip})" + end + def visit_Arel_Nodes_Ascending o "#{visit o.expr} ASC" end diff --git a/test/visitors/test_to_sql.rb b/test/visitors/test_to_sql.rb index 1caedacd45..064f14739c 100644 --- a/test/visitors/test_to_sql.rb +++ b/test/visitors/test_to_sql.rb @@ -126,6 +126,11 @@ module Arel @visitor.accept(nil).must_be_like "NULL" end + it "should visit_Arel_SelectManager, which is a subquery" do + mgr = Table.new(:foo).project(:bar) + @visitor.accept(mgr).must_be_like '(SELECT bar FROM "foo")' + end + it "should visit_Arel_Nodes_And" do node = Nodes::And.new [@attr.eq(10), @attr.eq(11)] @visitor.accept(node).must_be_like %{ -- cgit v1.2.3