Adding spec:mysql and spec:sqlite3 tasks

1 files changed, 43 insertions, 14 deletions

diff --git a/spec/arel/unit/relations/delete_spec.rb b/spec/arel/unit/relations/delete_spec.rb
index fa887d20fd..3798178ccc 100644
--- a/spec/arel/unit/relations/delete_spec.rb
+++ b/spec/arel/unit/relations/delete_spec.rb
@@ -8,26 +8,55 @@ module Arel
 
     describe '#to_sql' do
       it 'manufactures sql deleting a table relation' do
-        Deletion.new(@relation).to_sql.should be_like("
-          DELETE
-          FROM `users`
-        ")
+        sql = Deletion.new(@relation).to_sql
+
+        adapter_is :mysql do
+          sql.should be_like(%Q{DELETE FROM `users`})
+        end
+
+        adapter_is_not :mysql do
+          sql.should be_like(%Q{DELETE FROM "users"})
+        end
       end
 
       it 'manufactures sql deleting a where relation' do
-        Deletion.new(@relation.where(@relation[:id].eq(1))).to_sql.should be_like("
-          DELETE
-          FROM `users`
-          WHERE `users`.`id` = 1
-        ")
+        sql = Deletion.new(@relation.where(@relation[:id].eq(1))).to_sql
+
+        adapter_is :mysql do
+          sql.should be_like(%Q{
+            DELETE
+            FROM `users`
+            WHERE `users`.`id` = 1
+          })
+        end
+
+        adapter_is_not :mysql do
+          sql.should be_like(%Q{
+            DELETE
+            FROM "users"
+            WHERE "users"."id" = 1
+          })
+        end
       end
 
       it "manufactures sql deleting a ranged relation" do
-        Deletion.new(@relation.take(1)).to_sql.should be_like("
-          DELETE
-          FROM `users`
-          LIMIT 1
-        ")
+        sql = Deletion.new(@relation.take(1)).to_sql
+
+        adapter_is :mysql do
+          sql.should be_like(%Q{
+            DELETE
+            FROM `users`
+            LIMIT 1
+          })
+        end
+
+        adapter_is_not :mysql do
+          sql.should be_like(%Q{
+            DELETE
+            FROM "users"
+            LIMIT 1
+          })
+        end
       end
     end