1 files changed, 45 insertions, 0 deletions
diff --git a/spec/arel/engines/sql/unit/engine_spec.rb b/spec/arel/engines/sql/unit/engine_spec.rb
new file mode 100644
index 0000000000..c607abcfa1
--- /dev/null
+++ b/spec/arel/engines/sql/unit/engine_spec.rb
@@ -0,0 +1,45 @@
+require File.join(File.dirname(__FILE__), '..', '..', '..', '..', 'spec_helper')
+
+module Arel
+  describe Sql::Engine do
+    before do
+      @users = Table.new(:users)
+      @users.delete
+    end
+
+    describe "CRUD" do
+      describe "#create" do
+        it "inserts into the relation" do
+          @users.insert @users[:name] => "Bryan"
+          @users.first[@users[:name]].should == "Bryan"
+        end
+      end
+
+      describe "#read" do
+        it "reads from the relation" do
+          @users.insert @users[:name] => "Bryan"
+
+          @users.each do |row|
+            row[@users[:name]].should == "Bryan"
+          end
+        end
+      end
+
+      describe "#update" do
+        it "updates the relation" do
+          @users.insert @users[:name] => "Nick"
+          @users.update @users[:name] => "Bryan"
+          @users.first[@users[:name]].should == "Bryan"
+        end
+      end
+
+      describe "#delete" do
+        it "deletes from the relation" do
+          @users.insert @users[:name] => "Bryan"
+          @users.delete
+          @users.first.should == nil
+        end
+      end
+    end
+  end
+end