kivitendo/SL/Helper/Csv/Dispatcher.pm @ b8a5c591
| 17d58914 | Sven Schöling | package SL::Helper::Csv::Dispatcher;
|
||
use strict;
|
||||
use Data::Dumper;
|
||||
use Carp;
|
||||
use Scalar::Util qw(weaken);
|
||||
| 7ec8b55e | Bernd Bleßmann | use List::MoreUtils qw(all pairwise);
|
||
| 17d58914 | Sven Schöling | use Rose::Object::MakeMethods::Generic scalar => [ qw(
|
||
| 7ec8b55e | Bernd Bleßmann | _specs _row_class _row_spec _errors
|
||
| 17d58914 | Sven Schöling | ) ];
|
||
| c46898c7 | Sven Schöling | use SL::Helper::Csv::Error;
|
||
| 17d58914 | Sven Schöling | sub new {
|
||
my ($class, $parent) = @_;
|
||||
my $self = bless { }, $class;
|
||||
weaken($self->{_csv} = $parent);
|
||||
$self->_errors([]);
|
||||
return $self;
|
||||
}
|
||||
sub dispatch {
|
||||
| c8473408 | Bernd Bleßmann | my ($self, $line) = @_;
|
||
| af205393 | Bernd Bleßmann | my $class = $self->_class_by_line($line);
|
||
croak 'no class given' unless $class;
|
||||
| 17d58914 | Sven Schöling | |||
| af205393 | Bernd Bleßmann | eval "require " . $class;
|
||
my $obj = $class->new;
|
||||
my $specs = $self->_specs_by_line($line);
|
||||
for my $spec (@{ $specs }) {
|
||||
| 17d58914 | Sven Schöling | $self->apply($obj, $spec, $line->{$spec->{key}});
|
||
}
|
||||
| c8473408 | Bernd Bleßmann | |||
return $obj;
|
||||
| 17d58914 | Sven Schöling | }
|
||
| af205393 | Bernd Bleßmann | sub _class_by_line {
|
||
my ($self, $line) = @_;
|
||||
| 7ec8b55e | Bernd Bleßmann | # initialize lookup hash if not already done
|
||
if ($self->_csv->is_multiplexed && ! defined $self->_row_class ) {
|
||||
$self->_row_class({ map { $_->{row_ident} => $_->{class} } @{ $self->_csv->profile } });
|
||||
}
|
||||
| af205393 | Bernd Bleßmann | if ($self->_csv->is_multiplexed) {
|
||
| 7ec8b55e | Bernd Bleßmann | return $self->_row_class->{$line->{datatype}};
|
||
| af205393 | Bernd Bleßmann | } else {
|
||
| 7ec8b55e | Bernd Bleßmann | return $self->_csv->profile->[0]->{class};
|
||
| af205393 | Bernd Bleßmann | }
|
||
}
|
||||
sub _specs_by_line {
|
||||
my ($self, $line) = @_;
|
||||
| 7ec8b55e | Bernd Bleßmann | # initialize lookup hash if not already done
|
||
if ($self->_csv->is_multiplexed && ! defined $self->_row_spec ) {
|
||||
| d161c66c | Bernd Bleßmann | $self->_row_spec({ pairwise { no warnings 'once'; $a->{row_ident} => $b } @{ $self->_csv->profile }, @{ $self->_specs } });
|
||
| 7ec8b55e | Bernd Bleßmann | }
|
||
| af205393 | Bernd Bleßmann | if ($self->_csv->is_multiplexed) {
|
||
| 7ec8b55e | Bernd Bleßmann | return $self->_row_spec->{$line->{datatype}};
|
||
| af205393 | Bernd Bleßmann | } else {
|
||
| 7ec8b55e | Bernd Bleßmann | return $self->_specs->[0];
|
||
| af205393 | Bernd Bleßmann | }
|
||
}
|
||||
| 17d58914 | Sven Schöling | sub apply {
|
||
my ($self, $obj, $spec, $value) = @_;
|
||||
return unless $value;
|
||||
for my $step (@{ $spec->{steps} }) {
|
||||
| 90af0ce7 | Sven Schöling | my ($acc, $class, $index) = @$step;
|
||
| 17d58914 | Sven Schöling | if ($class) {
|
||
| 90af0ce7 | Sven Schöling | |||
# autovifify
|
||||
if (defined $index) {
|
||||
if (! $obj->$acc || !$obj->$acc->[$index]) {
|
||||
my @objects = $obj->$acc;
|
||||
$obj->$acc(@objects, map { $class->new } 0 .. $index - @objects);
|
||||
}
|
||||
$obj = $obj->$acc->[$index];
|
||||
} else {
|
||||
if (! $obj->$acc) {
|
||||
$obj->$acc($class->new);
|
||||
}
|
||||
$obj = $obj->$acc;
|
||||
}
|
||||
| 17d58914 | Sven Schöling | } else {
|
||
$obj->$acc($value);
|
||||
}
|
||||
}
|
||||
}
|
||||
sub is_known {
|
||||
| fb1a574b | Sven Schöling | my ($self, $col, $row) = @_;
|
||
return grep { $col eq $_->{key} } @{ $self->_specs->[$row // 0] };
|
||||
| 17d58914 | Sven Schöling | }
|
||
sub parse_profile {
|
||||
my ($self, %params) = @_;
|
||||
| af205393 | Bernd Bleßmann | my @specs;
|
||
| 8ad3a60e | Bernd Bleßmann | my $csv_profile = $self->_csv->profile;
|
||
| e95294b5 | Bernd Bleßmann | my $h_aref = ($self->_csv->is_multiplexed)? $self->_csv->header : [ $self->_csv->header ];
|
||
| af205393 | Bernd Bleßmann | my $i = 0;
|
||
| e95294b5 | Bernd Bleßmann | foreach my $header (@{ $h_aref }) {
|
||
| 8ad3a60e | Bernd Bleßmann | my $spec = $self->_parse_profile(profile => $csv_profile->[$i]->{profile},
|
||
| f74b0dac | Sven Schöling | mapping => $csv_profile->[$i]->{mapping},
|
||
| 8ad3a60e | Bernd Bleßmann | class => $csv_profile->[$i]->{class},
|
||
| af205393 | Bernd Bleßmann | header => $header);
|
||
push @specs, $spec;
|
||||
$i++;
|
||||
}
|
||||
$self->_specs(\@specs);
|
||||
| c80cdcf8 | Bernd Bleßmann | $self->_csv->_push_error($self->errors);
|
||
| af205393 | Bernd Bleßmann | return ! $self->errors;
|
||
}
|
||||
sub _parse_profile {
|
||||
my ($self, %params) = @_;
|
||||
my $profile = $params{profile};
|
||||
my $class = $params{class};
|
||||
my $header = $params{header};
|
||||
| f74b0dac | Sven Schöling | my $mapping = $params{mapping};
|
||
| af205393 | Bernd Bleßmann | |||
| 17d58914 | Sven Schöling | my @specs;
|
||
for my $col (@$header) {
|
||||
next unless $col;
|
||||
| f74b0dac | Sven Schöling | if (exists $mapping->{$col} && $profile->{$mapping->{$col}}) {
|
||
push @specs, $self->make_spec($col, $profile->{$mapping->{$col}}, $class);
|
||||
} elsif (exists $mapping->{$col}) {
|
||||
push @specs, $self->make_spec($col, $mapping->{$col}, $class);
|
||||
} elsif (exists $profile->{$col}) {
|
||||
push @specs, $self->make_spec($col, $profile->{$col}, $class);
|
||||
| 09294068 | Sven Schöling | } else {
|
||
| f74b0dac | Sven Schöling | if ($self->_csv->strict_profile) {
|
||
$self->unknown_column($col, undef);
|
||||
| a54fc392 | Sven Schöling | } else {
|
||
| af205393 | Bernd Bleßmann | push @specs, $self->make_spec($col, $col, $class);
|
||
| a54fc392 | Sven Schöling | }
|
||
| 09294068 | Sven Schöling | }
|
||
| 17d58914 | Sven Schöling | }
|
||
| af205393 | Bernd Bleßmann | return \@specs;
|
||
| 17d58914 | Sven Schöling | }
|
||
sub make_spec {
|
||||
| af205393 | Bernd Bleßmann | my ($self, $col, $path, $cur_class) = @_;
|
||
| 17d58914 | Sven Schöling | |||
| a0d9f09a | Sven Schöling | my $spec = { key => $col, path => $path, steps => [] };
|
||
| a54fc392 | Sven Schöling | |||
return unless $path;
|
||||
| 457ad636 | Sven Schöling | return unless $cur_class;
|
||
| 90af0ce7 | Sven Schöling | for my $step_index ( split /\.(?!\d)/, $path ) {
|
||
my ($step, $index) = split /\./, $step_index;
|
||||
| 17d58914 | Sven Schöling | if ($cur_class->can($step)) {
|
||
| 45119ead | Sven Schöling | if (my $rel = $cur_class->meta->relationship($step)) { #a
|
||
if ($index && ! $rel->isa('Rose::DB::Object::Metadata::Relationship::OneToMany')) {
|
||||
$self->_push_error([
|
||||
$path,
|
||||
undef,
|
||||
"Profile path error. Indexed relationship is not OneToMany around here: '$step_index'",
|
||||
undef,
|
||||
0,
|
||||
]);
|
||||
return;
|
||||
} else {
|
||||
my $next_class = $cur_class->meta->relationship($step)->class;
|
||||
push @{ $spec->{steps} }, [ $step, $next_class, $index ];
|
||||
$cur_class = $next_class;
|
||||
| 7358571b | Sven Schöling | eval "require $cur_class; 1" or die "could not load class '$cur_class'";
|
||
| 45119ead | Sven Schöling | }
|
||
| 17d58914 | Sven Schöling | } else { # simple dispatch
|
||
push @{ $spec->{steps} }, [ $step ];
|
||||
last;
|
||||
}
|
||||
} else {
|
||||
$self->unknown_column($col, $path);
|
||||
}
|
||||
}
|
||||
return $spec;
|
||||
}
|
||||
sub unknown_column {
|
||||
my ($self, $col, $path) = @_;
|
||||
return if $self->_csv->ignore_unknown_columns;
|
||||
$self->_push_error([
|
||||
$col,
|
||||
undef,
|
||||
"header field '$col' is not recognized",
|
||||
undef,
|
||||
0,
|
||||
]);
|
||||
}
|
||||
sub _csv {
|
||||
$_[0]->{_csv};
|
||||
}
|
||||
sub errors {
|
||||
@{ $_[0]->_errors }
|
||||
}
|
||||
sub _push_error {
|
||||
my ($self, @errors) = @_;
|
||||
| c46898c7 | Sven Schöling | my @new_errors = ($self->errors, map { SL::Helper::Csv::Error->new(@$_) } @errors);
|
||
| 17d58914 | Sven Schöling | $self->_errors(\@new_errors);
|
||
}
|
||||
1;
|