cleanup

2 files changed, 116 insertions, 0 deletions

diff --git a/lib/arel/sql/christener.rb b/lib/arel/sql/christener.rb
new file mode 100644
index 0000000000..894f030342
--- /dev/null
+++ b/lib/arel/sql/christener.rb
@@ -0,0 +1,14 @@
+module Arel
+  module Sql
+    class Christener
+      def name_for(relation)
+        @used_names ||= Hash.new(0)
+        @relation_names ||= Hash.new do |h, k|
+          @used_names[k.name] += 1
+          h[k] = k.name + (@used_names[k.name] > 1 ? "_#{@used_names[k.name]}" : '')
+        end
+        @relation_names[relation]
+      end
+    end
+  end
+end
\ No newline at end of file
diff --git a/lib/arel/sql/formatters.rb b/lib/arel/sql/formatters.rb
new file mode 100644
index 0000000000..96bab2495c
--- /dev/null
+++ b/lib/arel/sql/formatters.rb
@@ -0,0 +1,102 @@
+module Arel
+  module Sql
+    class Formatter
+      attr_reader :environment
+      delegate :christener, :engine, :to => :environment
+      delegate :name_for, :to => :christener
+      delegate :quote_table_name, :quote_column_name, :quote, :to => :engine
+      
+      def initialize(environment)
+        @environment = environment
+      end
+    end
+    
+    class SelectClause < Formatter
+      def attribute(attribute)
+        "#{quote_table_name(name_for(attribute.original_relation))}.#{quote_column_name(attribute.name)}" + (attribute.alias ? " AS #{quote(attribute.alias.to_s)}" : "")
+      end
+      
+      def expression(expression)
+        "#{expression.function_sql}(#{expression.attribute.to_sql(self)})" + (expression.alias ? " AS #{quote_column_name(expression.alias)}" : '')
+      end
+      
+      def select(select_sql, name)
+        "(#{select_sql}) AS #{quote_table_name(name.to_s)}"
+      end
+      
+      def value(value)
+        value
+      end
+    end
+    
+    class PassThrough < Formatter
+      def value(value)
+        value
+      end
+    end
+    
+    class WhereClause < PassThrough
+    end
+    
+    class OrderClause < PassThrough      
+      def attribute(attribute)
+        "#{quote_table_name(name_for(attribute.original_relation))}.#{quote_column_name(attribute.name)}"
+      end
+    end
+    
+    class WhereCondition < Formatter
+      def attribute(attribute)
+        "#{quote_table_name(name_for(attribute.original_relation))}.#{quote_column_name(attribute.name)}"
+      end
+      
+      def expression(expression)
+        "#{expression.function_sql}(#{expression.attribute.to_sql(self)})"
+      end
+      
+      def value(value)
+        value.to_sql(self)
+      end
+      
+      def scalar(value, column = nil)
+        quote(value, column)
+      end
+      
+      def select(select_sql, name)
+        "(#{select_sql})"
+      end
+    end
+    
+    class SelectStatement < Formatter
+      def select(select_sql, name)
+        select_sql
+      end
+    end
+    
+    class TableReference < Formatter
+      def select(select_sql, name)
+        "(#{select_sql}) AS #{quote_table_name(name)}"
+      end
+      
+      def table(table)
+        quote_table_name(table.name) + (table.name != name_for(table) ? " AS " + engine.quote_table_name(name_for(table)) : '')
+      end
+    end
+    
+    class Attribute < WhereCondition
+      def scalar(scalar)
+        quote(scalar, environment.column)
+      end
+      
+      def array(array)
+        "(" + array.collect { |e| e.to_sql(self) }.join(', ') + ")"
+      end
+      
+      def range(left, right)
+        "#{left} AND #{right}"
+      end
+    end
+    
+    class Value < WhereCondition
+    end
+  end
+end
\ No newline at end of file