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