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.