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"
            
          

SEE ALSO

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