NAME
LibWeb::Database - A generic database driver for libweb applications
SUPPORTED PLATFORMS
REQUIRE
DBI
ISA
LibWeb::Core
SYNOPSIS
use LibWeb::Database;
my $db = new LibWeb::Database();
my ($sql, $user, $host, $fetch, $result);
$sql = "select USER_NAME, USER_HOST ".
"from USER_TABLE ".
"where USER_LOGIN_STATUS = ".
"LOGIN_INDICATOR";
$fetch = $db->query(
-sql => $sql,
-bind_cols => [\$user, \$host]
);
while ( &$fetch ) {
$result .= "$user $host <BR>\n";
}
$db->done();
print "Content-Type: text/html\n\n";
print "<P> The following users have logged in: $result";
ABSTRACT
As long as you have the proper DBD installed for your database, you can use this class to interact with your database in your LibWeb applications.
The current version of LibWeb::Database is available at
http://libweb.sourceforge.net
Several LibWeb applications (LEAPs) have be written, released and are available at
http://leaps.sourceforge.net
TYPOGRAPHICAL CONVENTIONS AND TERMINOLOGY
Variables in all-caps (e.g. USER_TABLE) are those variables set through LibWeb's rc file. Please read LibWeb::Core for more information. Method's parameters in square brackets means optional.
DESCRIPTION
do()
Params:
-sql =>
Pre:
-sql
is a valid sql statement.
Post:
Return the number of rows affected by the SQL statement,
-sql
.
query()
Params:
-sql=>, -bind_cols=> [, -want_hash=> ]
Pre:
-sql
is the sql statement to perform the query,-bind_cols
is an ARRAY reference to SCALAR references to fields to be bound in the table specified in-sql
,-want_hash
indicates whether the returning function (a reference) is a reference to DBI's fetchrow_hashref() or fetchrow_arrayref().
Post:
Returns a reference to a fetching function based on
-sql
. A reference to DBI's fetchrow_arrayref() is returned if-want_hash
is not defined; otherwise a reference to DBI's fetchrow_hashref() is returned.
finish()
Finish a statement execution.
disconnect()
Disconnect the current database session.
done()
Finish a statement execution and disconnect the current database session.