DBIx-Broker
view release on metacpan or search on metacpan
@customers = $db->select_all( 'customers', "WHERE age < 30", 1 );
foreach my $customer ( @customers ) {
print "Customer $customer->{'customerID'}: ";
print "$customer->{'last_name'}, $customer->{'first_name'}";
}
And if none of the existing functions are adequate, you can send
a raw SQL statement if you\'d like, by using
$db->execute_sql( "SELCET name FORM mailbox_tabel WHEER login = 'binkler'" );
You may retrieve table schema information in the form of a
hashtable, whose keys are the field names and whose values are
hashrefs to the various characteristics of each field, such as
'Type', 'Key', etc. For convenience, the ->get_primary_key()
and ->get_auto_increments() methods have also been added.
=head1 AUTHOR
xomina@bitstream.net
( run in 0.479 second using v1.01-cache-2.11-cpan-a5abf4f5562 )