| Server IP : 79.136.114.73 / Your IP : 3.147.69.134 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/doc/libdbd-mysql-perl/examples/ |
Upload File : |
#!/usr/bin/perl
use strict;
use warnings;
use DBI;
use Test::More;
use Data::Dumper;
use English qw( -no_match_vars );
my $CONF = $ENV{MYCONF} || "$ENV{HOME}/.my.cnf";
my $emulate = 0;
my $dbh;
eval {
#
# change the connection statements
# to suit your purposes
$dbh =
DBI->connect("dbi:mysql:test",
'root',
'',
{RaiseError => 1, PrintError => 1} )
or die "can't connect : $DBI::errstr\n";
};
if ($EVAL_ERROR) {
plan (skip_all => " -- no connection available $EVAL_ERROR");
}
else {
plan ( tests => 10 );
}
print "\nEmulation of ps: $emulate, version: $DBD::mysql::VERSION\n";
print $dbh->{mysql_server_prepare},"\n";
my $drop_proc = qq{
drop procedure if exists test_multi_sets
};
my $create_proc = qq{
create procedure test_multi_sets ()
deterministic
begin
select user() as first_col;
select user() as first_col, now() as second_col;
select user() as first_col, now() as second_col, now() as third_col;
end
};
eval { $dbh->do($drop_proc) };
ok( ! $EVAL_ERROR, 'drop procedure' );
eval { $dbh->do($create_proc) };
ok( ! $EVAL_ERROR , 'create procedure');
my $sth;
print $dbh->{mysql_server_prepare},"\n";
eval { $sth = $dbh->prepare(qq{call test_multi_sets() }) } ;
ok( $sth , 'preparing statement handler');
eval { $sth->execute() };
ok( ! $EVAL_ERROR, 'executing sth - 1st time ' );
diag $EVAL_ERROR if $EVAL_ERROR;
my $dataset;
eval { $dataset = $sth->fetchrow_arrayref(); } ;
print Dumper($dataset),"\n";
ok( $dataset && @$dataset == 1 , 'fetching first dataset');
my $more_results;
eval { $more_results = $sth->more_results() };
ok( $more_results, 'more results available (1st time) ' ) ;
eval { $dataset = $sth->fetchrow_arrayref(); } ;
print Dumper($dataset),"\n";
ok( $dataset && @$dataset == 2 , 'fetching second dataset');
eval { $more_results = $sth->more_results() };
ok( $more_results, 'more results available (2nd time) ' ) ;
eval { $dataset = $sth->fetchrow_arrayref(); } ;
print Dumper($dataset),"\n";
ok( $dataset && @$dataset == 3 , 'fetching third dataset');
eval { $more_results = $sth->more_results() };
ok( ! $more_results, 'no more results available' ) ;