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/sql_builder | |
parent | 648209d11f16243a9f073b177e6b32ce8c094408 (diff) | |
download | rails-b8a4dabab94bfaa73ec031337ce9ef9abd798383.tar.gz rails-b8a4dabab94bfaa73ec031337ce9ef9abd798383.tar.bz2 rails-b8a4dabab94bfaa73ec031337ce9ef9abd798383.zip |
quoting
Diffstat (limited to 'spec/sql_builder')
-rw-r--r-- | spec/sql_builder/conditions_spec.rb | 4 | ||||
-rw-r--r-- | spec/sql_builder/select_builder_spec.rb | 30 |
2 files changed, 17 insertions, 17 deletions
diff --git a/spec/sql_builder/conditions_spec.rb b/spec/sql_builder/conditions_spec.rb index 78590e2631..c1cae902c1 100644 --- a/spec/sql_builder/conditions_spec.rb +++ b/spec/sql_builder/conditions_spec.rb @@ -7,10 +7,10 @@ describe ConditionsBuilder do ConditionsBuilder.new do equals do column(:a, :b) - column(:c, :d, :e) + column(:c, :d, 'e') end end.to_s.should be_like(""" - a.b = e + `a`.`b` = 'e' """) end end diff --git a/spec/sql_builder/select_builder_spec.rb b/spec/sql_builder/select_builder_spec.rb index 7b059bd6bd..060c642c1b 100644 --- a/spec/sql_builder/select_builder_spec.rb +++ b/spec/sql_builder/select_builder_spec.rb @@ -11,7 +11,7 @@ describe SelectBuilder do from :users end.to_s.should be_like(""" SELECT * - FROM users + FROM `users` """) end end @@ -20,13 +20,13 @@ describe SelectBuilder do it 'manufactures correct sql' do SelectBuilder.new do select do - column(:a, :b, :c) - column(:e, :f) + column :a, :b, 'c' + column :e, :f end from :users end.to_s.should be_like(""" - SELECT a.b AS c, e.f - FROM users + SELECT `a`.`b` AS 'c', `e`.`f` + FROM `users` """) end end @@ -40,14 +40,14 @@ describe SelectBuilder do from :users where do equals do - value :a + value 1 column :b, :c end end end.to_s.should be_like(""" SELECT * - FROM users - WHERE a = b.c + FROM `users` + WHERE 1 = `b`.`c` """) end end @@ -61,14 +61,14 @@ describe SelectBuilder do from :users do inner_join(:friendships) do equals do - value :id - value :user_id + column :users, :id + column :friendships, :user_id end end end end.to_s.should be_like(""" SELECT * - FROM users INNER JOIN friendships ON id = user_id + FROM `users` INNER JOIN `friendships` ON `users`.`id` = `friendships`.`user_id` """) end end @@ -82,12 +82,12 @@ describe SelectBuilder do from :users order_by do column :users, :id - column :users, :created_at, :alias + column :users, :created_at, 'alias' end end.to_s.should be_like(""" SELECT * - FROM users - ORDER BY users.id, alias + FROM `users` + ORDER BY `users`.`id`, 'alias' """) end end @@ -103,7 +103,7 @@ describe SelectBuilder do offset 10 end.to_s.should be_like(""" SELECT * - FROM users + FROM `users` LIMIT 10 OFFSET 10 """) |