NAME

 zebot::DB::Helper


DESCRIPTION

zebot::DB::Helper module, fires up a number of worker processes that connect to the database, and then forks off with the incoming tasks.


COPYRIGHT and LICENCE

  Copyright (c) 2002 Bruno Boettcher
  DB::Helper.pm is free software; you can redistribute it and/or
  modify it under the terms of the GNU General Public License
  as published by the Free Software Foundation; version 2
  of the License.
  This program is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.
  You should have received a copy of the GNU General Public License
  along with this program; if not, write to the Free Software
  Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.


Methods of this class

CTOR
instantiation of the Helper

init
Initiaize, means set up this module

dbh
attribute getter previously provided by ObjecTemplate

print
delegator, to make a copy of the console stream to a file, for debugging purposes only, since somehow the STDOUT gets swallowed up for some cases....

version
return the version of this module

doQuery
perform a query to the database arguments is hash: query: SQL string or prepared statemnt values: the optional arguments type: hash|count for the momet for the returntype

doExecute
execute a prepared statement the return value is allready stripped of all DBI interference

condense
pack up the data we received from the DB array of hashes

isa
return the type of thie module

shutdown
close down the activity for a safe shutdown

prepare
prepare a sql statement for further refinement

free
drop a prepared statement to liberate some space...

batch
process a whole transaction arguments are 1 arrays of queries as described in doQuery

doReturn
since the return stuff grew complicated, made an own return method.. check if we can return a perl reference or if it must be go through a packing and to storable conversion stage


AUTHOR

Bruno Böttcher <bboett at adlp.org>


SEE ALSO

zebot home page http://www.freesoftware.fsf.org/zebot/ POD documentation of zebot