full sql statement generation

4 files changed, 57 insertions, 0 deletions

diff --git a/lib/arel/nodes.rb b/lib/arel/nodes.rb
index 07a687405f..53c17a8cca 100644
--- a/lib/arel/nodes.rb
+++ b/lib/arel/nodes.rb
@@ -1,2 +1,3 @@
 require 'arel/nodes/equality'
 require 'arel/nodes/sql_literal'
+require 'arel/nodes/select'
diff --git a/lib/arel/nodes/select.rb b/lib/arel/nodes/select.rb
new file mode 100644
index 0000000000..8f68adbcd5
--- /dev/null
+++ b/lib/arel/nodes/select.rb
@@ -0,0 +1,13 @@
+module Arel
+  module Nodes
+    class Select
+      attr_reader :froms, :projections, :wheres
+
+      def initialize
+        @froms       = []
+        @projections = []
+        @wheres      = []
+      end
+    end
+  end
+end
diff --git a/lib/arel/tree_manager.rb b/lib/arel/tree_manager.rb
new file mode 100644
index 0000000000..b111ca9557
--- /dev/null
+++ b/lib/arel/tree_manager.rb
@@ -0,0 +1,31 @@
+module Arel
+  class TreeManager
+    def initialize engine
+      @engine         = engine
+      @statement_list = []
+
+      # default to Select
+      @statement_list << Nodes::Select.new
+    end
+
+    def from table
+      @statement_list.last.froms << table
+      self
+    end
+
+    def project projection
+      @statement_list.last.projections << projection
+      self
+    end
+
+    def where expr
+      @statement_list.last.wheres << expr
+      self
+    end
+
+    def to_sql
+      viz = Visitors::ToSql.new @engine
+      viz.accept @statement_list.last
+    end
+  end
+end
diff --git a/lib/arel/visitors/to_sql.rb b/lib/arel/visitors/to_sql.rb
index ba92ca7ef1..bb2a4d07e8 100644
--- a/lib/arel/visitors/to_sql.rb
+++ b/lib/arel/visitors/to_sql.rb
@@ -12,6 +12,18 @@ module Arel
       end
 
       private
+      def visit_Arel_Nodes_Select o
+        [
+          "SELECT #{o.projections.map { |x| visit x }.join ', '}",
+          "FROM #{o.froms.map { |x| visit x }.join ', ' }",
+          ("WHERE #{o.wheres.map { |x| visit x }.join ' AND ' }" unless o.wheres.blank?)
+        ].compact.join ' '
+      end
+
+      def visit_Arel_Table o
+        quote_table_name o.name
+      end
+
       def visit_Arel_Nodes_Equality o
         "#{visit o.left} = #{visit o.right}"
       end