Connector::Proxy::DBI

Use DBI to make a query to a database, supports calls to a single column only.

Usage

Configuration

my $con = Connector::Proxy::DBI->new({
    LOCATION => 'DBI:mysql:database=openxpki;host=localhost',
    dbuser => 'queryuser',
    password => 'verysecret',
    table => 'mytable',
    column => 1,
    condition => 'id = ?',
});

get

Will return the value of the requested column of the matching row. If no row or more than one row is found, undef is returned (dies if die_on_undef is set).

get_list

Will return the selected column of all matching lines as a list. If no match is found undef is returned (dies if die_on_undef is set).

get_meta

Will return scalar if the query has one result or list if the query has multiple rows. Returns undef if no rows are found.

get_keys/get_hash

not supported