aboutsummaryrefslogtreecommitdiffstats
path: root/spec/arel/tree_manager.rb
diff options
context:
space:
mode:
authorAaron Patterson <aaron.patterson@gmail.com>2010-08-12 21:21:20 -0700
committerAaron Patterson <aaron.patterson@gmail.com>2010-08-12 21:21:20 -0700
commite573a9ea468d748cf0ebd1a70521c1589efda23e (patch)
tree0d92325a54370b1412b47e247efe4bd4d86efdc7 /spec/arel/tree_manager.rb
parent16e7273245473bb6466a79a38702a52387bab44d (diff)
downloadrails-e573a9ea468d748cf0ebd1a70521c1589efda23e.tar.gz
rails-e573a9ea468d748cf0ebd1a70521c1589efda23e.tar.bz2
rails-e573a9ea468d748cf0ebd1a70521c1589efda23e.zip
limits are added
Diffstat (limited to 'spec/arel/tree_manager.rb')
-rw-r--r--spec/arel/tree_manager.rb23
1 files changed, 23 insertions, 0 deletions
diff --git a/spec/arel/tree_manager.rb b/spec/arel/tree_manager.rb
index 513b41e305..44dbb9f727 100644
--- a/spec/arel/tree_manager.rb
+++ b/spec/arel/tree_manager.rb
@@ -2,6 +2,29 @@ require 'spec_helper'
module Arel
describe 'tree manager' do
+ describe 'take' do
+ it "knows take" do
+ table = Table.new :users
+ manager = Arel::TreeManager.new Table.engine
+ manager.from(table).project(table['id'])
+ manager.where(table['id'].eq(1))
+ manager.take 1
+
+ manager.to_sql.should == %{
+ SELECT "users"."id"
+ FROM "users"
+ WHERE "users"."id" = 1
+ LIMIT 1
+ }.gsub("\n", '').gsub(/(^\s*|\s*$)/, '').squeeze(' ')
+ end
+
+ it "chains" do
+ table = Table.new :users
+ manager = Arel::TreeManager.new Table.engine
+ manager.take(1).should == manager
+ end
+ end
+
describe 'where' do
it "knows where" do
table = Table.new :users