X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F03values.t;h=c0ec9cc655cf5fa02ebcd02c394e81fcf84b04a2;hb=bd6a65cac4599702fc4a717772934ff28421c6be;hp=a9e3946490efd2752694ae6127daa71eb8d4d028;hpb=bab725ceb3539ee6cff3afba859ec296625a2f9b;p=dbsrgits%2FSQL-Abstract.git diff --git a/t/03values.t b/t/03values.t index a9e3946..c0ec9cc 100644 --- a/t/03values.t +++ b/t/03values.t @@ -94,15 +94,23 @@ for my $record (@data) { { my $sql = SQL::Abstract->new; - my $data = { event => 'rapture', time => \ 'now()', xfunc => \ 'somefunc(?)', stuff => 'fluff', }; + my $data = { + event => 'rapture', + stuff => 'fluff', + time => \ 'now()', + xfunc => \ 'xfunc(?)', + yfunc => ['yfunc(?)', 'ystuff' ], + zfunc => \['zfunc(?)', 'zstuff' ], + zzlast => 'zzstuff', + }; my ($stmt, @bind) = $sql->insert ('table', $data); is_same_sql_bind ( $stmt, \@bind, - 'INSERT INTO table ( event, stuff, time, xfunc) VALUES ( ?, ?, now(), somefunc (?) )', - [qw/rapture fluff/], # event < stuff + 'INSERT INTO table ( event, stuff, time, xfunc, yfunc, zfunc, zzlast) VALUES ( ?, ?, now(), xfunc (?), yfunc(?), zfunc(?), ? )', + [qw/rapture fluff ystuff zstuff zzstuff/], # event < stuff ); is_same_bind (