aboutsummaryrefslogtreecommitdiffstats
path: root/spec/sql_builder
diff options
context:
space:
mode:
authorNick Kallen <nkallen@nick-kallens-computer-2.local>2008-01-05 16:04:41 -0800
committerNick Kallen <nkallen@nick-kallens-computer-2.local>2008-01-05 16:04:41 -0800
commitb8a4dabab94bfaa73ec031337ce9ef9abd798383 (patch)
treecb04af99acd16c8e7ca9e6b731a78d69358229bd /spec/sql_builder
parent648209d11f16243a9f073b177e6b32ce8c094408 (diff)
downloadrails-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.rb4
-rw-r--r--spec/sql_builder/select_builder_spec.rb30
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
""")