{
my
$sqlat
= SQL::Abstract::Tree->new({
fill_in_placeholders
=> 1,
placeholder_surround
=> [
qw(; -)
],
});
is(
$sqlat
->fill_in_placeholder([
'lolz'
]),
q(;lolz-)
,
'placeholders are populated correctly'
);
}
{
my
$sqlat
= SQL::Abstract::Tree->new({
fill_in_placeholders
=> 1,
placeholder_surround
=> [
qw(< >)
],
});
is(
$sqlat
->fill_in_placeholder([
'station'
]),
q(<station>)
,
'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;