[dbsrgits/SQL-Abstract.git] / t / dbic / bulk-insert.t

use strict;
use warnings;

use Test::More;
use DBIx::Class::Storage::Debug::PrettyPrint;

my $cap;
open my $fh, '>', \$cap;

my $pp = DBIx::Class::Storage::Debug::PrettyPrint->new({
   profile => 'none',
   fill_in_placeholders => 1,
   placeholder_surround => [qw(' ')],
   show_progress => 0,
});

$pp->debugfh($fh);

$pp->query_start('INSERT INTO self_ref_alias (alias, self_ref) VALUES ( ?, ? )', qw('__BULK_INSERT__' '1'));
is(
   $cap,
   qq{INSERT INTO self_ref_alias( alias, self_ref ) VALUES( ?, ? ) : '__BULK_INSERT__', '1'\n},
   'SQL Logged'
);

done_testing;
Commit	Line	Data
fda8a675	1	use strict;
	2	use warnings;
	3
	4	use Test::More;
	5	use DBIx::Class::Storage::Debug::PrettyPrint;
	6
	7	my $cap;
	8	open my $fh, '>', \$cap;
	9
	10	my $pp = DBIx::Class::Storage::Debug::PrettyPrint->new({
	11	profile => 'none',
	12	fill_in_placeholders => 1,
	13	placeholder_surround => [qw(' ')],
	14	show_progress => 0,
	15	});
	16
	17	$pp->debugfh($fh);
	18
	19	$pp->query_start('INSERT INTO self_ref_alias (alias, self_ref) VALUES ( ?, ? )', qw('__BULK_INSERT__' '1'));
	20	is(
	21	$cap,
c4d7cfcf	22	qq{INSERT INTO self_ref_alias( alias, self_ref ) VALUES( ?, ? ) : '__BULK_INSERT__', '1'\n},
fda8a675	23	'SQL Logged'
	24	);
	25
	26	done_testing;