View on
MetaCPAN
Scott T. Hardin > Connector > Connector::Proxy::DBI

Download:
Connector-1.25.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  5
Open  0
View/Report Bugs
Source  

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_hash

Return a single row as hashref, by default all columns are returned as retrieved from the database. Pass a hashref to column, where the key is the target key and the value is the name of the column you need.

E.g. when your table has the columns id and name but you need the keys index and title in your result.

    $con->column({ 'id' => 'id', '`index`' => 'id', 'title' => 'name' });

Note: The mapping is set directly on the sql layer and as escaping reserved words is not standardized, we dont do it. You can add escape characters yourself to the column map where required, as shown for the word "index" in the given example.

get_keys

not supported

syntax highlighting: