NAME
Maplat::Worker::PostgresDB - Worker module for accessing PostgreSQL databases
SYNOPSIS
This module is a wrapper around DBI/DBD::Pg.
DESCRIPTION
With this worker module, you can easely maintain connections to multiple databases (just declare multiple modules with different modnames).
Configuration
<module>
<modname>maindb</modname>
<pm>PostgresDB</pm>
<options>
<dburl>dbi:Pg:dbname=Maplat_DB</dburl>
<dbuser>Maplat_Server</dbuser>
<dbpassword>SECRET</dbpassword>
</options>
</module>
dburl is the DBI connection string, see DBD::Pg.
AutoCommit
Get/Set the DBD::Pg "AutoCommit" setting
RaiseError
Get/Set the DBD::Pg "RaiseError" setting
errstr
Get the DBI errorstring.
do
Execute a DBI statement with "do"
prepare
Prepare a (non-cached) Statement.
prepare_cached
Prepare a server cached statement (may fall back to non-cached transparently, see DBD::Pg and PostgreSQL documentation for details).
quote
Quote a variable for use in PostgreSQL statements.
commit
Commit transaction.
rollback
Rollback transaction.
Dependencies
This module is a basic module which does not depend on other worker modules.
SEE ALSO
Maplat::Worker DBD::Pg
AUTHOR
Rene Schickbauer, <rene.schickbauer@gmail.com>
COPYRIGHT AND LICENSE
Copyright (C) 2008-2010 by Rene Schickbauer
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.10.0 or, at your option, any later version of Perl 5 you may have available.