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_size/get_meta/get_hash

not supported, yet