diff options
author | Nick Kallen <nkallen@nick-kallens-computer-2.local> | 2008-01-05 16:04:41 -0800 |
---|---|---|
committer | Nick Kallen <nkallen@nick-kallens-computer-2.local> | 2008-01-05 16:04:41 -0800 |
commit | b8a4dabab94bfaa73ec031337ce9ef9abd798383 (patch) | |
tree | cb04af99acd16c8e7ca9e6b731a78d69358229bd /spec/integration | |
parent | 648209d11f16243a9f073b177e6b32ce8c094408 (diff) | |
download | rails-b8a4dabab94bfaa73ec031337ce9ef9abd798383.tar.gz rails-b8a4dabab94bfaa73ec031337ce9ef9abd798383.tar.bz2 rails-b8a4dabab94bfaa73ec031337ce9ef9abd798383.zip |
quoting
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 |