Oak::IO::DBI - IO routines to exchange data with databases using DBI


NAME

Oak::IO::DBI - IO routines to exchange data with databases using DBI


DESCRIPTION

This module provides access for exchange data with databases using DBI.


HIERARCHY

Oak::Object

Oak::Persistent

Oak::Component

Oak::IO::DBI


PROPERTIES

datasource
DBI datasorce string, used to create the connection. See perldoc DBI for more information.

username,password,options
DBI options. See DBI documentation for more help.


EVENTS

ev_onConnect
When a connection is openned

ev_onSql
When a sql is executed

ev_onDisconnect
When the database is explicitly disconnected (not on DESTROY)


METHODS

connect
Register the connection for this object. Generates an ev_onConnect event.

Could raise the Oak::IO::DBI::Error::ConnectionFailure exception.

do_sql(SQL)
Prepare, executes and test if successfull. Returns the Sth. Generates an ev_onSql event (passes $sql and $sth to the function called).

Could rause the following exceptions: Oak::Filer::DBI::Error::SQLSyntaxError and Oak::Filer::DBI::Error::SQLExecuteError

quote
Quotes a string, using DBI->quote unless empty, else uses ``''''.

get_dbh
Returns the DBI object.

disconnect
Called by DESTROY, releases the DBI connection. It disconnects. Generates a ev_onDisconnect event.

begin_work, commit, rollback
Calls the method with the same name at DBI.


EXCEPTION HANDLING

Oak::IO::DBI::Error::ConnectionFailure;
This class is used in the register_connection when it fails

Oak::IO::DBI::Error::SQLSyntaxError;
This class is raised when the sql has wrong syntax

Oak::IO::DBI::Error::SQLExecuteError;
This class is raised when the sql has an error while executing


COPYRIGHT

Copyright (c) 2001 Daniel Ruoso <daniel@ruoso.com> and Rodolfo Sikora <rodolfo@trevas.net>. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

 Oak::IO::DBI - IO routines to exchange data with databases using DBI