The whole stuff:

ETL.pm

package Karl::ETL;

use Moo;

use MooX::Types::MooseLike::Base qw( Str );

has user   => ( is => 'rw', isa => Str );

has passwd => ( is => 'rw', isa => Str );

has dsn    => ( is => 'rw', isa => Str );

with qw(
  Karl::DBIxODBC
  Karl::MyParseExcel
);

1;

[download]

DBIxODBC.pm

package Karl::DBIxODBC;

use Moo::Role;
use MooX::Types::MooseLike::Base qw(InstanceOf HashRef ArrayRef);
use DBIx::Simple;

requires qw( user passwd dsn );

has 'loader' => (
    is      => 'rw',
    isa     => HashRef[ ArrayRef ],
    trigger => \&_load,
);

has '_dbix' => (
    is      => 'ro',
    isa     => InstanceOf('DBIx::Simple'),
    handles => [qw( insert )],
    builder => '_build_dbix',
    lazy    => 1,
);

sub _build_dbix() {
    my $self = shift;
    my $connect_string;
    $connect_string = "dbi:ODBC:" . $self->dsn;
    DBIx::Simple->new( $connect_string, $self->user, $self->passwd );
}

sub _load() {
    my ( $self, $input ) = @_;
    my $table = ( keys %$input )[0];
    foreach my $row ( @{ $input->{$table} } ) {
       $self->insert( $table, $row );
    }
}

1;

[download]

MyParseExcel.pm

package Karl::MyParseExcel;
use Moo::Role;
use Spreadsheet::ParseExcel;
use MooX::Types::MooseLike::Base qw(InstanceOf Str);
1;

[download]

etl.pl (was run.pl)

#!C:/perl/bin/perl.exe

use strict;
use warnings;
use lib q(C:/local/lib/perl);
use Karl::ETL;

my $etl = Karl::ETL->new(
    dsn    => 'dsn_name',
    user   => 'name',
    passwd => 'secret',
);

my $data->{test} = [ [qw(foo bar)] ];

$etl->loader($data);

[download]
Regards, Karl
«The Crux of the Biscuit is the Apostrophe» Karl Goethebier

In reply to Re^4: Moo and Spreadsheet::ParseExcel by karlgoethebier
in thread Moo and Spreadsheet::ParseExcel by karlgoethebier

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.