aboutsummaryrefslogtreecommitdiffstats
path: root/spec/arel/unit/relations/project_spec.rb
diff options
context:
space:
mode:
authorNick Kallen <nkallen@nick-kallens-computer-2.local>2008-05-19 13:57:21 -0700
committerNick Kallen <nkallen@nick-kallens-computer-2.local>2008-05-19 13:57:21 -0700
commit518db17ca3dade07fc67b6044b63c826cefb1442 (patch)
tree6a472954f44bbfd2d38198c33517f76a75150785 /spec/arel/unit/relations/project_spec.rb
parent3eae3b08eef84237c201a2f7bfc5292dbbe6951c (diff)
downloadrails-518db17ca3dade07fc67b6044b63c826cefb1442.tar.gz
rails-518db17ca3dade07fc67b6044b63c826cefb1442.tar.bz2
rails-518db17ca3dade07fc67b6044b63c826cefb1442.zip
renamed ion classes
Diffstat (limited to 'spec/arel/unit/relations/project_spec.rb')
-rw-r--r--spec/arel/unit/relations/project_spec.rb74
1 files changed, 74 insertions, 0 deletions
diff --git a/spec/arel/unit/relations/project_spec.rb b/spec/arel/unit/relations/project_spec.rb
new file mode 100644
index 0000000000..2a4b690dd8
--- /dev/null
+++ b/spec/arel/unit/relations/project_spec.rb
@@ -0,0 +1,74 @@
+require File.join(File.dirname(__FILE__), '..', '..', '..', 'spec_helper')
+
+module Arel
+ describe Project do
+ before do
+ @relation = Table.new(:users)
+ @attribute = @relation[:id]
+ end
+
+ describe '#attributes' do
+ before do
+ @projection = Project.new(@relation, @attribute)
+ end
+
+ it "manufactures attributes associated with the projection relation" do
+ @projection.attributes.should == [@attribute].collect { |a| a.bind(@projection) }
+ end
+ end
+
+ describe '#to_sql' do
+ describe 'when given an attribute' do
+ it "manufactures sql with a limited select clause" do
+ Project.new(@relation, @attribute).to_sql.should be_like("
+ SELECT `users`.`id`
+ FROM `users`
+ ")
+ end
+ end
+
+ describe 'when given a relation' do
+ before do
+ @scalar_relation = Project.new(@relation, @relation[:name])
+ end
+
+ it "manufactures sql with scalar selects" do
+ Project.new(@relation, @scalar_relation).to_sql.should be_like("
+ SELECT (SELECT `users`.`name` FROM `users`) AS `users` FROM `users`
+ ")
+ end
+ end
+
+ describe 'when given a string' do
+ it "passes the string through to the select clause" do
+ Project.new(@relation, 'asdf').to_sql.should be_like("
+ SELECT asdf FROM `users`
+ ")
+ end
+ end
+
+ describe 'when given an expression' do
+ it 'manufactures sql with expressions' do
+ @relation.project(@attribute.count).to_sql.should be_like("
+ SELECT COUNT(`users`.`id`)
+ FROM `users`
+ ")
+ end
+ end
+ end
+
+ describe '#aggregation?' do
+ describe 'when the projections are attributes' do
+ it 'returns false' do
+ Project.new(@relation, @attribute).should_not be_aggregation
+ end
+ end
+
+ describe 'when the projections include an aggregation' do
+ it "obtains" do
+ Project.new(@relation, @attribute.sum).should be_aggregation
+ end
+ end
+ end
+ end
+end \ No newline at end of file