1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
require_relative "spec_helper"
describe "Sequel::Plugins::TableSelect" do
before do
@Album = Class.new(Sequel::Model(Sequel.mock[:albums]))
end
it "should add a table.* selection to existing dataset without explicit selection" do
@Album.plugin :table_select
@Album.dataset.sql.must_equal 'SELECT albums.* FROM albums'
@Album.dataset = :albs
@Album.dataset.sql.must_equal 'SELECT albs.* FROM albs'
@Album.dataset = Sequel.identifier(:albs)
@Album.dataset.sql.must_equal 'SELECT albs.* FROM albs'
end
it "should handle qualified tables" do
@Album.dataset = Sequel.qualify(:s2, :albums)
@Album.plugin :table_select
@Album.dataset.sql.must_equal 'SELECT s2.albums.* FROM s2.albums'
end
it "should handle aliases" do
@Album.dataset = Sequel.as(:albums, :b)
@Album.plugin :table_select
@Album.dataset.sql.must_equal 'SELECT b.* FROM albums AS b'
@Album.dataset = @Album.db[:albums].from_self
@Album.dataset.sql.must_equal 'SELECT t1.* FROM (SELECT * FROM albums) AS t1'
@Album.dataset = Sequel.as(@Album.db[:albums], :b)
@Album.dataset.sql.must_equal 'SELECT b.* FROM (SELECT * FROM albums) AS b'
end
with_symbol_splitting "should handle splittable symbols" do
@Album.dataset = :albums___a
@Album.plugin :table_select
@Album.dataset.sql.must_equal 'SELECT a.* FROM albums AS a'
@Album.dataset = :s__albums___a
@Album.dataset.sql.must_equal 'SELECT a.* FROM s.albums AS a'
@Album.dataset = :s__albums
@Album.dataset.sql.must_equal 'SELECT s.albums.* FROM s.albums'
end
it "should not add a table.* selection on existing dataset with explicit selection" do
@Album.dataset = @Album.dataset.select(:name)
@Album.plugin :table_select
@Album.dataset.sql.must_equal 'SELECT name FROM albums'
@Album.dataset = @Album.dataset.select(:name, :artist)
@Album.dataset.sql.must_equal 'SELECT name, artist FROM albums'
end
it "should add a table.* selection on existing dataset with subquery" do
@Album.dataset = @Album.db.from(:a1, :a2).from_self(:alias=>:foo)
@Album.plugin :table_select
@Album.dataset.sql.must_equal 'SELECT foo.* FROM (SELECT * FROM a1, a2) AS foo'
@Album.dataset = @Album.db.from(:a1).cross_join(:a2).from_self(:alias=>:foo)
@Album.dataset.sql.must_equal 'SELECT foo.* FROM (SELECT * FROM a1 CROSS JOIN a2) AS foo'
end
it "should work with implicit subqueries used for joined datasets" do
@Album.dataset = @Album.db.from(:a1, :a2)
@Album.plugin :table_select
@Album.dataset.sql.must_equal 'SELECT a1.* FROM (SELECT * FROM a1, a2) AS a1'
@Album.dataset = @Album.db.from(:a1).cross_join(:a2)
@Album.dataset.sql.must_equal 'SELECT a1.* FROM (SELECT * FROM a1 CROSS JOIN a2) AS a1'
end
it "works correctly when loaded on model without a dataset" do
c = Class.new(Sequel::Model)
c.plugin :table_select
sc = Class.new(c)
sc.dataset = :a
sc.dataset.sql.must_equal "SELECT a.* FROM a"
end
end
|
