📄 09trace.t
字号:
#!perl -w# vim:sw=4:ts=8use strict;# 66 tests originallyuse Test::More tests => 66;## ----------------------------------------------------------------------------## 09trace.t## ----------------------------------------------------------------------------# ## ----------------------------------------------------------------------------BEGIN { use_ok( 'DBI' ); }$|=1;## ----------------------------------------------------------------------------# Connect to the example driver.my $dbh = DBI->connect('dbi:ExampleP:dummy', '', '', { PrintError => 0, RaiseError => 1, PrintWarn => 1, });isa_ok( $dbh, 'DBI::db' );# Clean up when we're done.END { $dbh->disconnect if $dbh };## ----------------------------------------------------------------------------# Check the database handle attributes.cmp_ok($dbh->{TraceLevel}, '==', $DBI::dbi_debug & 0xF, '... checking TraceLevel attribute');my $trace_file = "dbitrace.log";1 while unlink $trace_file;$dbh->trace(0, $trace_file);ok( -f $trace_file, '... trace file successfully created');my @names = qw( SQL foo bar baz boo bop);my %flag;my $all_flags = 0;foreach my $name (@names) { print "parse_trace_flag $name\n"; ok( my $flag1 = $dbh->parse_trace_flag($name) ); ok( my $flag2 = $dbh->parse_trace_flags($name) ); is( $flag1, $flag2 ); $dbh->{TraceLevel} = $flag1; is( $dbh->{TraceLevel}, $flag1 ); $dbh->{TraceLevel} = 0; is( $dbh->{TraceLevel}, 0 ); $dbh->trace($flag1); is $dbh->trace, $flag1; is $dbh->{TraceLevel}, $flag1; $dbh->{TraceLevel} = $name; # set by name $dbh->{TraceLevel} = undef; # check no change on undef is( $dbh->{TraceLevel}, $flag1 ); $flag{$name} = $flag1; $all_flags |= $flag1 if defined $flag1; # reduce noise if there's a bug}print "parse_trace_flag @names\n";ok(eq_set([ keys %flag ], [ @names ]), '...');$dbh->{TraceLevel} = 0;$dbh->{TraceLevel} = join "|", @names;is($dbh->{TraceLevel}, $all_flags, '...');{ print "inherit\n"; my $sth = $dbh->prepare("select ctime, name from foo"); isa_ok( $sth, 'DBI::st' ); is( $sth->{TraceLevel}, $all_flags );}$dbh->{TraceLevel} = 0;ok !$dbh->{TraceLevel};$dbh->{TraceLevel} = 'ALL';ok $dbh->{TraceLevel};{ print "unknown parse_trace_flag\n"; my $warn = 0; local $SIG{__WARN__} = sub { if ($_[0] =~ /unknown/i) { ++$warn; print "warn: ",@_ }else{ warn @_ } }; is $dbh->parse_trace_flag("nonesuch"), undef; is $warn, 0; is $dbh->parse_trace_flags("nonesuch"), 0; is $warn, 1; is $dbh->parse_trace_flags("nonesuch|SQL|nonesuch2"), $dbh->parse_trace_flag("SQL"); is $warn, 2;}$dbh->trace(0);ok !$dbh->{TraceLevel};$dbh->trace(undef, "STDERR"); # close $trace_fileok( -s $trace_file );1;# end
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -