NAME

Catmandu::Importer::DBI - Catmandu module to import data from any DBI source

SYNOPSIS

 use Catmandu::Importer::DBI;

 my %attrs = (
        dsn => 'dbi:mysql:foobar' ,
        user => 'foo' ,
        password => 'bar' ,
        query => 'select * from table'
 );

 my $importer = Catmandu::Importer::DBI->new(%attrs);

 # Optional set extra parameters on the database handle
 # $importer->dbh->{LongReadLen} = 1024 * 64;

 $importer->each(sub {
        my $row_hash = shift;
        ...
 });


 # or

 $ catmandu convert DBI --dsn dbi:mysql:foobar --user foo --password bar --query "select * from table"

AUTHORS

 Patrick Hochstenbach, C<< <patrick.hochstenbach at ugent.be> >>

SEE ALSO

Catmandu, Catmandu::Importer , Catmandu::Store::DBI