implementing where_sql method

1 files changed, 17 insertions, 0 deletions

diff --git a/spec/select_manager_spec.rb b/spec/select_manager_spec.rb
index 287657d0c1..b8512eb741 100644
--- a/spec/select_manager_spec.rb
+++ b/spec/select_manager_spec.rb
@@ -379,6 +379,23 @@ module Arel
       end
     end
 
+    describe 'where_sql' do
+      it 'gives me back the where sql' do
+        table   = Table.new :users
+        manager = Arel::SelectManager.new Table.engine
+        manager.from table
+        manager.where table[:id].eq 10
+        manager.where_sql.should be_like %{ WHERE "users"."id" = 10 }
+      end
+
+      it 'returns nil when there are no wheres' do
+        table   = Table.new :users
+        manager = Arel::SelectManager.new Table.engine
+        manager.from table
+        manager.where_sql.should be_nil
+      end
+    end
+
     describe 'update' do
       it 'copies limits' do
         engine  = EngineProxy.new Table.engine