diff options
Diffstat (limited to 'spec/integration')
-rw-r--r-- | spec/integration/scratch_spec.rb | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/spec/integration/scratch_spec.rb b/spec/integration/scratch_spec.rb index 725ac755c0..32ee98d361 100644 --- a/spec/integration/scratch_spec.rb +++ b/spec/integration/scratch_spec.rb @@ -12,30 +12,30 @@ describe 'Relational Algebra' do it 'simulates User.has_many :photos' do @user_photos.project(*@photos.attributes).to_s.should be_like(""" - SELECT photos.id, photos.user_id, photos.camera_id - FROM users - LEFT OUTER JOIN photos - ON users.id = photos.user_id + SELECT `photos`.`id`, `photos`.`user_id`, `photos`.`camera_id` + FROM `users` + LEFT OUTER JOIN `photos` + ON `users`.`id` = `photos`.`user_id` WHERE - users.id = 1 + `users`.`id` = 1 """) end it 'simulates a User.has_many :cameras :through => :photos' do @user_cameras.project(*@cameras.attributes).to_s.should be_like(""" - SELECT cameras.id - FROM users - LEFT OUTER JOIN photos - ON users.id = photos.user_id - LEFT OUTER JOIN cameras - ON photos.camera_id = cameras.id + SELECT `cameras`.`id` + FROM `users` + LEFT OUTER JOIN `photos` + ON `users`.`id` = `photos`.`user_id` + LEFT OUTER JOIN `cameras` + ON `photos`.`camera_id` = `cameras`.`id` WHERE - users.id = 1 + `users`.`id` = 1 """) end it '' do - # @user_cameras.qualify.to_s + # p @user_cameras.qualify.to_s # # @users.rename() end |