Ananke-SqlLink
view release on metacpan or search on metacpan
push(@array,$row);
}
};
}
eval { $self->{pre}->finish };
# Apaga variaveis indesejadas
undef $q; undef $t;
# Retorna os resultados do select
return @array;
}
# executa funcao 'do'
sub do {
my ($self,$q) = @_;
$self->{conn}->do($q);
if (DBI::errstr) {
my $c = new Ananke::SqlLink({
'type' => 'mysql',
'db' => 'test',
'host' => 'localhost',
'username' => 'root',
'passwd' => '',
});
=head2 $c->return(type,query)
only for select
=head3 scalar type
@r = $c->return($q,'scalar');
foreach $i (@r) {
print "ID: ".$i->{id}." - Name: ".$i->{name}."\n";
}
=head3 array type
( run in 1.240 second using v1.01-cache-2.11-cpan-49f99fa48dc )