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
|
require_relative "spec_helper"
Sequel.extension :eval_inspect
describe "eval_inspect extension" do
before do
@ds = Sequel.mock.dataset.with_extend do
def supports_window_functions?; true end
def literal_blob_append(sql, s) sql << "X'#{s}'" end
end
end
it "should make eval(obj.inspect) == obj for all Sequel::SQL::Expression subclasses" do
[
# Objects with components where eval(inspect) == self
Sequel::SQL::AliasedExpression.new(:b, :a),
Sequel::SQL::AliasedExpression.new(:b, :a, [:c, :d]),
Sequel::SQL::CaseExpression.new({:b=>:a}, :c),
Sequel::SQL::CaseExpression.new({:b=>:a}, :c, :d),
Sequel::SQL::Cast.new(:a, :b),
Sequel::SQL::ColumnAll.new(:a),
Sequel::SQL::ComplexExpression.new(:'=', :b, :a),
Sequel::SQL::Constant.new(:a),
Sequel::CURRENT_DATE,
Sequel::CURRENT_TIMESTAMP,
Sequel::CURRENT_TIME,
Sequel::SQLTRUE,
Sequel::SQLFALSE,
Sequel::NULL,
Sequel::NOTNULL,
Sequel::SQL::Function.new(:a, :b, :c),
Sequel::SQL::Identifier.new(:a),
Sequel::SQL::JoinClause.new(:inner, :b),
Sequel::SQL::JoinOnClause.new({:d=>:a}, :inner, :b),
Sequel::SQL::JoinUsingClause.new([:a], :inner, :b),
Sequel::SQL::JoinClause.new(:inner, Sequel.as(:b, :c, [:d, :e])),
Sequel::SQL::JoinOnClause.new({:d=>:a}, :inner, Sequel.as(:b, :c, [:d, :e])),
Sequel::SQL::JoinUsingClause.new([:a], :inner, Sequel.as(:b, :c, [:d, :e])),
Sequel::SQL::PlaceholderLiteralString.new('? = ?', [:a, :b]),
Sequel::SQL::PlaceholderLiteralString.new(':a = :b', [{:a=>:b, :b=>42}]),
Sequel::SQL::OrderedExpression.new(:a),
Sequel::SQL::OrderedExpression.new(:a, false),
Sequel::SQL::OrderedExpression.new(:a, false, :nulls=>:first),
Sequel::SQL::OrderedExpression.new(:a, false, :nulls=>:last),
Sequel::SQL::QualifiedIdentifier.new(:b, :a),
Sequel::SQL::Subscript.new(:a, [1, 2]),
Sequel::SQL::Window.new(:order=>:a, :partition=>:b),
Sequel::SQL::Function.new(:a, :b, :c).over(:order=>:a, :partition=>:b),
Sequel::SQL::Wrapper.new(:a),
# Objects with components where eval(inspect) != self
Sequel::SQL::AliasedExpression.new(Sequel::SQL::Blob.new('s'), :a),
Sequel::SQL::AliasedExpression.new(Sequel::LiteralString.new('s'), :a),
Sequel::SQL::PlaceholderLiteralString.new('(a, b) IN ?', [Sequel::SQL::ValueList.new([[1, 2]])]),
Sequel::SQL::CaseExpression.new({{:d=>Sequel::LiteralString.new('e')}=>:a}, :c, :d),
Sequel::SQL::AliasedExpression.new(Date.new(2011, 10, 11), :a),
Sequel::SQL::AliasedExpression.new(Sequel::SQLTime.create(10, 20, 30, 500000.125), :a),
Sequel::SQL::AliasedExpression.new(DateTime.new(2011, 9, 11, 10, 20, 30), :a),
Sequel::SQL::AliasedExpression.new(DateTime.new(2011, 9, 11, 10, 20, 30, 0.25), :a),
Sequel::SQL::AliasedExpression.new(DateTime.new(2011, 9, 11, 10, 20, 30, -0.25), :a),
Sequel::SQL::AliasedExpression.new(Time.local(2011, 9, 11, 10, 20, 30), :a),
Sequel::SQL::AliasedExpression.new(Time.local(2011, 9, 11, 10, 20, 30, 500000.125), :a),
Sequel::SQL::AliasedExpression.new(Time.utc(2011, 9, 11, 10, 20, 30), :a),
Sequel::SQL::AliasedExpression.new(Time.utc(2011, 9, 11, 10, 20, 30, 500000.125), :a),
Sequel::SQL::AliasedExpression.new(BigDecimal('1.000000000000000000000000000000000000000000000001'), :a),
Sequel::SQL::AliasedExpression.new(Sequel::CURRENT_DATE, :a),
Sequel::SQL::AliasedExpression.new(Sequel::CURRENT_TIMESTAMP, :a),
].each do |o|
v = eval(o.inspect)
v.must_equal o
@ds.literal(v).must_equal @ds.literal(o)
ds = @ds
@ds.db.create_table(:test) do
v = eval(o.inspect)
v.must_equal o
ds.literal(v).must_equal ds.literal(o)
end
end
end
end
|
