2 use Test::More qw(no_plan);
5 use Data::Query::Renderer::SQL::Naive;
6 use Data::Query::ExprHelpers;
8 my $rend = Data::Query::Renderer::SQL::Naive->new({ quote_chars => [ "'" ] });
10 sub binding { map perl_scalar_value($_), @_ }
14 #::Dwarn($expr); return;
15 my $rendered = $rend->render($expr);
16 is_deeply($rendered, @_);
20 Select([ Identifier('*') ], Identifier('foo')),
21 ['SELECT * FROM foo'],
26 Select([ Identifier('*') ], Identifier('foo')),
28 perl_operator('==', Identifier('foo', 'x'), Identifier('bar', 'y'))
30 ['SELECT * FROM foo JOIN bar ON foo.x = bar.y'],
38 Literal('SQL', '?', [ binding(1) ],),
40 Select([ Identifier('*') ], Identifier('foo')),
42 ['SELECT * FROM foo WHERE x = ?', binding(1)],
43 'simple select with where and bind';