aboutsummaryrefslogtreecommitdiffstats
path: root/spec/engines/sql/unit/relations/table_spec.rb
diff options
context:
space:
mode:
authorCarl Lerche <carllerche@mac.com>2010-03-12 14:46:37 -0800
committerCarl Lerche <carllerche@mac.com>2010-03-12 14:46:37 -0800
commite13420c86afb5c31e90cff800f121bd49255b939 (patch)
tree7089d188061b2a676143add52227e107a5cf9b45 /spec/engines/sql/unit/relations/table_spec.rb
parent0b8b87fb947a746d4e58d11ea73ef20cfb23f576 (diff)
downloadrails-e13420c86afb5c31e90cff800f121bd49255b939.tar.gz
rails-e13420c86afb5c31e90cff800f121bd49255b939.tar.bz2
rails-e13420c86afb5c31e90cff800f121bd49255b939.zip
We're obviously writing specs for arel. No need for a sub directory.
Diffstat (limited to 'spec/engines/sql/unit/relations/table_spec.rb')
-rw-r--r--spec/engines/sql/unit/relations/table_spec.rb129
1 files changed, 129 insertions, 0 deletions
diff --git a/spec/engines/sql/unit/relations/table_spec.rb b/spec/engines/sql/unit/relations/table_spec.rb
new file mode 100644
index 0000000000..6afd9964a4
--- /dev/null
+++ b/spec/engines/sql/unit/relations/table_spec.rb
@@ -0,0 +1,129 @@
+require 'spec_helper'
+
+module Arel
+ describe Table do
+ before do
+ @relation = Table.new(:users)
+ end
+
+ describe '#to_sql' do
+ it "manufactures a simple select query" do
+ sql = @relation.to_sql
+
+ adapter_is :mysql do
+ sql.should be_like(%Q{
+ SELECT `users`.`id`, `users`.`name`
+ FROM `users`
+ })
+ end
+
+ adapter_is :oracle do
+ sql.should be_like(%Q{
+ SELECT "USERS"."ID", "USERS"."NAME"
+ FROM "USERS"
+ })
+ end
+
+ adapter_is_not :mysql, :oracle do
+ sql.should be_like(%Q{
+ SELECT "users"."id", "users"."name"
+ FROM "users"
+ })
+ end
+ end
+ end
+
+ describe '#as' do
+ it "manufactures a simple select query using aliases" do
+ sql = @relation.as(:super_users).to_sql
+
+ adapter_is :mysql do
+ sql.should be_like(%Q{
+ SELECT `super_users`.`id`, `super_users`.`name`
+ FROM `users` `super_users`
+ })
+ end
+
+ adapter_is :oracle do
+ sql.should be_like(%Q{
+ SELECT "SUPER_USERS"."ID", "SUPER_USERS"."NAME"
+ FROM "USERS" "SUPER_USERS"
+ })
+ end
+
+ adapter_is_not :mysql, :oracle do
+ sql.should be_like(%Q{
+ SELECT "super_users"."id", "super_users"."name"
+ FROM "users" "super_users"
+ })
+ end
+ end
+
+ it "does not apply alias if it's same as the table name" do
+ sql = @relation.as(:users).to_sql
+
+ adapter_is :mysql do
+ sql.should be_like(%Q{
+ SELECT `users`.`id`, `users`.`name`
+ FROM `users`
+ })
+ end
+
+ adapter_is :oracle do
+ sql.should be_like(%Q{
+ SELECT "USERS"."ID", "USERS"."NAME"
+ FROM "USERS"
+ })
+ end
+
+ adapter_is_not :mysql, :oracle do
+ sql.should be_like(%Q{
+ SELECT "users"."id", "users"."name"
+ FROM "users"
+ })
+ end
+ end
+
+ end
+
+ describe '#column_for' do
+ it "returns the column corresponding to the attribute" do
+ @relation.column_for(@relation[:id]).should == @relation.columns.detect { |c| c.name == 'id' }
+ end
+ end
+
+ describe '#attributes' do
+ it 'manufactures attributes corresponding to columns in the table' do
+ @relation.attributes.should == [
+ Attribute.new(@relation, :id),
+ Attribute.new(@relation, :name)
+ ]
+ end
+
+ describe '#reset' do
+ it "reloads columns from the database" do
+ lambda { @relation.engine.stub!(:columns => []) }.should_not change { @relation.attributes }
+ lambda { @relation.reset }.should change { @relation.attributes }
+ end
+ end
+ end
+
+ describe 'hashing' do
+ it "implements hash equality" do
+ Table.new(:users).should hash_the_same_as(Table.new(:users))
+ Table.new(:users).should_not hash_the_same_as(Table.new(:photos))
+ end
+ end
+
+ describe '#engine' do
+ it "defaults to global engine" do
+ Table.engine = engine = Sql::Engine.new
+ Table.new(:users).engine.should == engine
+ end
+
+ it "can be specified" do
+ Table.new(:users, engine = Sql::Engine.new).engine.should == engine
+ end
+ end
+ end
+end