sub insert_all { my ($self) = @_; my $rows = 0; my $sth = $self->{dbh}->prepare($self->insert_sql); while( my $row = $self->get_row() ){ $sth->execute(@$row); ++$rows; } return $rows; }