From 49d119ae84bbb7cd180ca855cf48997dc731554c Mon Sep 17 00:00:00 2001
From: Bryan Helmkamp <bryan@brynary.com>
Date: Sat, 16 May 2009 21:13:32 -0400
Subject: Adding spec:mysql and spec:sqlite3 tasks

---
 spec/arel/unit/relations/table_spec.rb | 41 +++++++++++++++++++++-------------
 1 file changed, 26 insertions(+), 15 deletions(-)

(limited to 'spec/arel/unit/relations/table_spec.rb')

diff --git a/spec/arel/unit/relations/table_spec.rb b/spec/arel/unit/relations/table_spec.rb
index 54520bf3b6..08486c7b6c 100644
--- a/spec/arel/unit/relations/table_spec.rb
+++ b/spec/arel/unit/relations/table_spec.rb
@@ -5,7 +5,7 @@ module Arel
     before do
       @relation = Table.new(:users)
     end
-  
+
     describe '[]' do
       describe 'when given a', Symbol do
         it "manufactures an attribute if the symbol names an attribute within the relation" do
@@ -18,39 +18,50 @@ module Arel
         it "returns the attribute if the attribute is within the relation" do
           @relation[@relation[:id]].should == @relation[:id]
         end
-        
+
         it "returns nil if the attribtue is not within the relation" do
           another_relation = Table.new(:photos)
           @relation[another_relation[:id]].should be_nil
         end
       end
-      
+
       describe 'when given an', Expression do
         before do
           @expression = @relation[:id].count
         end
-        
+
         it "returns the Expression if the Expression is within the relation" do
           @relation[@expression].should be_nil
         end
       end
     end
-    
+
     describe '#to_sql' do
       it "manufactures a simple select query" do
-        @relation.to_sql.should be_like("
-          SELECT `users`.`id`, `users`.`name`
-          FROM `users`
-        ")
+        sql = @relation.to_sql
+
+        adapter_is :mysql do
+          sql.should be_like(%Q{
+            SELECT `users`.`id`, `users`.`name`
+            FROM `users`
+          })
+        end
+
+        adapter_is_not :mysql do
+          sql.should be_like(%Q{
+            SELECT "users"."id", "users"."name"
+            FROM "users"
+          })
+        end
       end
     end
-    
+
     describe '#column_for' do
       it "returns the column corresponding to the attribute" do
         @relation.column_for(@relation[:id]).should == @relation.columns.detect { |c| c.name == 'id' }
       end
     end
-    
+
     describe '#attributes' do
       it 'manufactures attributes corresponding to columns in the table' do
         @relation.attributes.should == [
@@ -58,7 +69,7 @@ module Arel
           Attribute.new(@relation, :name)
         ]
       end
-      
+
       describe '#reset' do
         it "reloads columns from the database" do
           lambda { stub(@relation.engine).columns { [] } }.should_not change { @relation.attributes }
@@ -66,20 +77,20 @@ module Arel
         end
       end
     end
-  
+
     describe 'hashing' do
       it "implements hash equality" do
         Table.new(:users).should hash_the_same_as(Table.new(:users))
         Table.new(:users).should_not hash_the_same_as(Table.new(:photos))
       end
     end
-    
+
     describe '#engine' do
       it "defaults to global engine" do
         Table.engine = engine = Engine.new
         Table.new(:users).engine.should == engine
       end
-      
+
       it "can be specified" do
         Table.new(:users, engine = Engine.new).engine.should == engine
       end
-- 
cgit v1.2.3