1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
use strict;
use warnings;
use Test::More;
use DBIx::Class::Storage::Debug::PrettyTrace;
my $cap;
open my $fh, '>', \$cap;
my $pp = DBIx::Class::Storage::Debug::PrettyTrace->new({
profile => 'none',
squash_repeats => 1,
fill_in_placeholders => 1,
placeholder_surround => ['', ''],
show_progress => 0,
});
$pp->debugfh($fh);
$pp->query_start('SELECT * FROM frew WHERE id = ?', q('1'));
is(
$cap,
qq(SELECT * FROM frew WHERE id = '1'\n),
'SQL Logged'
);
open $fh, '>', \$cap;
$pp->query_start('SELECT * FROM frew WHERE id = ?', q('2'));
is(
$cap,
qq(... : '2'\n),
'Repeated SQL ellided'
);
open $fh, '>', \$cap;
$pp->query_start('SELECT * FROM frew WHERE id = ?', q('3'));
is(
$cap,
qq(... : '3'\n),
'Repeated SQL ellided'
);
open $fh, '>', \$cap;
$pp->query_start('SELECT * FROM frew WHERE id = ?', q('4'));
is(
$cap,
qq(... : '4'\n),
'Repeated SQL ellided'
);
open $fh, '>', \$cap;
$pp->query_start('SELECT * FROM bar WHERE id = ?', q('4'));
is(
$cap,
qq(SELECT * FROM bar WHERE id = '4'\n),
'New SQL Logged'
);
open $fh, '>', \$cap;
$pp->query_start('SELECT * FROM frew WHERE id = ?', q('1'));
is(
$cap,
qq(SELECT * FROM frew WHERE id = '1'\n),
'New SQL Logged'
);
done_testing;
|
