Adding spec:mysql and spec:sqlite3 tasks

2 files changed, 44 insertions, 28 deletions

diff --git a/spec/arel/unit/primitives/attribute_spec.rb b/spec/arel/unit/primitives/attribute_spec.rb
index b341c6f88e..6d0f146a39 100644
--- a/spec/arel/unit/primitives/attribute_spec.rb
+++ b/spec/arel/unit/primitives/attribute_spec.rb
@@ -6,57 +6,57 @@ module Arel
       @relation = Table.new(:users)
       @attribute = @relation[:id]
     end
-  
+
     describe Attribute::Transformations do
       describe '#as' do
         it "manufactures an aliased attributed" do
           @attribute.as(:alias).should == Attribute.new(@relation, @attribute.name, :alias => :alias, :ancestor => @attribute)
         end
       end
-    
+
       describe '#bind' do
         it "manufactures an attribute with the relation bound and self as an ancestor" do
           derived_relation = @relation.where(@relation[:id].eq(1))
           @attribute.bind(derived_relation).should == Attribute.new(derived_relation, @attribute.name, :ancestor => @attribute)
         end
-        
+
         it "returns self if the substituting to the same relation" do
           @attribute.bind(@relation).should == @attribute
         end
       end
-    
+
       describe '#to_attribute' do
         it "returns self" do
           @attribute.to_attribute.should == @attribute
         end
       end
     end
-    
+
     describe '#column' do
       it "returns the corresponding column in the relation" do
         @attribute.column.should == @relation.column_for(@attribute)
       end
     end
-    
+
     describe '#engine' do
       it "delegates to its relation" do
         Attribute.new(@relation, :id).engine.should == @relation.engine
       end
     end
-    
+
     describe Attribute::Congruence do
       describe '/' do
         before do
           @aliased_relation = @relation.alias
           @doubly_aliased_relation = @aliased_relation.alias
         end
-        
+
         describe 'when dividing two unrelated attributes' do
           it "returns 0.0" do
             (@relation[:id] / @relation[:name]).should == 0.0
           end
         end
-        
+
         describe 'when dividing two matching attributes' do
           it 'returns a the highest score for the most similar attributes' do
             (@aliased_relation[:id] / @relation[:id]) \
@@ -67,97 +67,105 @@ module Arel
         end
       end
     end
-    
+
     describe '#to_sql' do
       describe 'for a simple attribute' do
         it "manufactures sql with an alias" do
-          @attribute.to_sql.should be_like("`users`.`id`")
+          sql = @attribute.to_sql
+
+          adapter_is :mysql do
+            sql.should be_like(%Q{`users`.`id`})
+          end
+
+          adapter_is_not :mysql do
+            sql.should be_like(%Q{"users"."id"})
+          end
         end
       end
     end
-  
+
     describe Attribute::Predications do
       before do
         @attribute = Attribute.new(@relation, :name)
       end
-    
+
       describe '#eq' do
         it "manufactures an equality predicate" do
           @attribute.eq('name').should == Equality.new(@attribute, 'name')
         end
       end
-    
+
       describe '#lt' do
         it "manufactures a less-than predicate" do
           @attribute.lt(10).should == LessThan.new(@attribute, 10)
         end
       end
-    
+
       describe '#lteq' do
         it "manufactures a less-than or equal-to predicate" do
           @attribute.lteq(10).should == LessThanOrEqualTo.new(@attribute, 10)
         end
       end
-    
+
       describe '#gt' do
         it "manufactures a greater-than predicate" do
           @attribute.gt(10).should == GreaterThan.new(@attribute, 10)
         end
       end
-    
+
       describe '#gteq' do
         it "manufactures a greater-than or equal-to predicate" do
           @attribute.gteq(10).should == GreaterThanOrEqualTo.new(@attribute, 10)
         end
       end
-    
+
       describe '#matches' do
         it "manufactures a match predicate" do
           @attribute.matches(/.*/).should == Match.new(@attribute, /.*/)
         end
       end
-      
+
       describe '#in' do
         it "manufactures an in predicate" do
           @attribute.in(1..30).should == In.new(@attribute, (1..30))
         end
       end
     end
-  
+
     describe Attribute::Expressions do
       before do
-        @attribute = Attribute.new(@relation, :name)    
+        @attribute = Attribute.new(@relation, :name)
       end
-    
+
       describe '#count' do
         it "manufactures a count Expression" do
           @attribute.count.should == Expression.new(@attribute, "COUNT")
         end
       end
-    
+
       describe '#sum' do
         it "manufactures a sum Expression" do
           @attribute.sum.should == Expression.new(@attribute, "SUM")
         end
       end
-    
+
       describe '#maximum' do
         it "manufactures a maximum Expression" do
           @attribute.maximum.should == Expression.new(@attribute, "MAX")
         end
       end
-    
+
       describe '#minimum' do
         it "manufactures a minimum Expression" do
           @attribute.minimum.should == Expression.new(@attribute, "MIN")
         end
       end
-    
+
       describe '#average' do
         it "manufactures an average Expression" do
           @attribute.average.should == Expression.new(@attribute, "AVG")
         end
-      end 
+      end
     end
   end
 end
\ No newline at end of file
diff --git a/spec/arel/unit/primitives/expression_spec.rb b/spec/arel/unit/primitives/expression_spec.rb
index 4943f4ef33..ebde55ff90 100644
--- a/spec/arel/unit/primitives/expression_spec.rb
+++ b/spec/arel/unit/primitives/expression_spec.rb
@@ -38,7 +38,15 @@ module Arel
 
     describe '#to_sql' do
       it "manufactures sql with the expression and alias" do
-        Expression.new(@attribute, "COUNT", :alias).to_sql.should == "COUNT(`users`.`id`) AS `alias`"
+        sql = Expression.new(@attribute, "COUNT", :alias).to_sql
+
+        adapter_is :mysql do
+          sql.should be_like(%Q{COUNT(`users`.`id`) AS `alias`})
+        end
+
+        adapter_is_not :mysql do
+          sql.should be_like(%Q{COUNT("users"."id") AS "alias"})
+        end
       end
     end
   end