1 files changed, 87 insertions, 0 deletions
diff --git a/spec/arel/select_manager_spec.rb b/spec/arel/select_manager_spec.rb
new file mode 100644
index 0000000000..928db49c52
--- /dev/null
+++ b/spec/arel/select_manager_spec.rb
@@ -0,0 +1,87 @@
+require 'spec_helper'
+
+module Arel
+  describe 'select manager' do
+    describe 'project' do
+      it 'takes strings' do
+        table   = Table.new :users
+        manager = Arel::SelectManager.new Table.engine
+        manager.project '*'
+        manager.to_sql.should be_like %{
+          SELECT *
+        }
+      end
+
+      it "takes sql literals" do
+        table   = Table.new :users
+        manager = Arel::SelectManager.new Table.engine
+        manager.project Nodes::SqlLiteral.new '*'
+        manager.to_sql.should be_like %{
+          SELECT *
+        }
+      end
+    end
+
+    describe 'take' do
+      it "knows take" do
+        table   = Table.new :users
+        manager = Arel::SelectManager.new Table.engine
+        manager.from(table).project(table['id'])
+        manager.where(table['id'].eq(1))
+        manager.take 1
+
+        manager.to_sql.should be_like %{
+          SELECT "users"."id"
+          FROM "users"
+          WHERE "users"."id" = 1
+          LIMIT 1
+        }
+      end
+
+      it "chains" do
+        table   = Table.new :users
+        manager = Arel::SelectManager.new Table.engine
+        manager.take(1).should == manager
+      end
+    end
+
+    describe 'where' do
+      it "knows where" do
+        table   = Table.new :users
+        manager = Arel::SelectManager.new Table.engine
+        manager.from(table).project(table['id'])
+        manager.where(table['id'].eq(1))
+        manager.to_sql.should be_like %{
+          SELECT "users"."id"
+          FROM "users"
+          WHERE "users"."id" = 1
+        }
+      end
+
+      it "chains" do
+        table   = Table.new :users
+        manager = Arel::SelectManager.new Table.engine
+        manager.from(table)
+        manager.project(table['id']).where(table['id'].eq 1).should == manager
+      end
+    end
+
+    describe 'from' do
+      it "makes sql" do
+        table   = Table.new :users
+        manager = Arel::SelectManager.new Table.engine
+
+        manager.from table
+        manager.project table['id']
+        manager.to_sql.should be_like 'SELECT "users"."id" FROM "users"'
+      end
+
+      it "chains" do
+        table   = Table.new :users
+        manager = Arel::SelectManager.new Table.engine
+        manager.from(table).project(table['id']).should == manager
+        manager.to_sql.should be_like 'SELECT "users"."id" FROM "users"'
+      end
+    end
+  end
+end