DBIx::BulkLoader::Mysql 1.006

DBIx::BulkLoader::Mysql is a simple buffering bulk loader interface for MySQL.

SYNOPSIS

 use DBIx::BulkLoader::Mysql;

 # non repeating portion of the insert statement
 my $insert='insert into bulk_insert (col_a,col_b,col_c) values ';

 # repeating portion of the insert statement
 my $placeholders='(?,?,?)';

 # how many rows to buffer until insert is called
 my $bulk_insert_count=5;

 # db connection
 my $dbh=DBI->connect(db connection info here);
 my $placeholder_count=3;

 my ($bulk,$error)=DBIx::BulkLoader::Mysql->new(
 dbh=>$dbh
 ,sql_insert=>$insert
 ,placeholders=>$placeholders
 );
 die $error unless $bulk;

 for( 1 .. 50 ) {
 $bulk->insert(qw(a b c));
 }
 # inserted 50 rows at once

 $bulk->insert(qw(l l x));
 # inserted 0 rows

 $bulk->insert(qw(l l x));
 # inserted 0 rows

 $bulk->flush;
 # inserted 2 rows 1 at a time


Product's homepage

Requirements:

· Perl