X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F15placeholders.t;h=55731a84aaf4b5826b6bf0aaf42d05e14541bcd8;hb=30e28763210ceaba353331164ccc685a9d000ce6;hp=bba9b6629ccfd012bb467220b92b4187b16c50e5;hpb=9d11f0d4173184b69711d7641557a21d2b6e3927;p=dbsrgits%2FSQL-Abstract.git diff --git a/t/15placeholders.t b/t/15placeholders.t index bba9b66..55731a8 100644 --- a/t/15placeholders.t +++ b/t/15placeholders.t @@ -4,15 +4,13 @@ use warnings; use Test::More; use SQL::Abstract::Tree; -my $placeholders = ['station', 'lolz']; - { my $sqlat = SQL::Abstract::Tree->new({ fill_in_placeholders => 1, placeholder_surround => [qw(; -)], }); - is($sqlat->fill_in_placeholder($placeholders), q(';lolz-'), + is($sqlat->fill_in_placeholder(['lolz']), q(;lolz-), 'placeholders are populated correctly' ); } @@ -23,9 +21,20 @@ my $placeholders = ['station', 'lolz']; placeholder_surround => [qw(< >)], }); - is($sqlat->fill_in_placeholder($placeholders), q(''), + is($sqlat->fill_in_placeholder(['station']), q(), 'placeholders are populated correctly and in order' ); } + +{ + my $sqlat = SQL::Abstract::Tree->new({ + fill_in_placeholders => 1, + placeholder_surround => [qw(' ')], + }); + + is $sqlat->format('SELECT ? AS x, ? AS y FROM Foo WHERE t > ? and z IN (?, ?, ?) ', [qw/frew ribasushi 2008-12-12 1 2 3/]), + q[SELECT 'frew' AS x, 'ribasushi' AS y FROM Foo WHERE t > '2008-12-12' AND z IN ( '1', '2', '3' )], 'Complex placeholders work'; +} + done_testing;