| 1 | package Puzzle::DBIx::ClassConverter; | ||
| 2 | |||
| 3 | our $VERSION = '0.18'; | ||
| 4 | |||
| 5 | use base 'Class::Container'; | ||
| 6 | |||
| 7 | sub resultset { | ||
| 8 | my $self = shift; | ||
| 9 | my $rs = shift; | ||
| 10 | my $key = shift || $rs->result_source->name; | ||
| 11 | my $relship = shift || {}; | ||
| 12 | |||
| 13 | my @ret; | ||
| 14 | |||
| 15 | while ($rec = $rs->next) { | ||
| 16 | push @ret,$self->row($rec,$relship); | ||
| 17 | } | ||
| 18 | |||
| 19 | return {$key => \@ret}; | ||
| 20 | } | ||
| 21 | |||
| 22 | sub row { | ||
| 23 | my $self = shift; | ||
| 24 | my $rs = shift; | ||
| 25 | my $relship = shift || {}; | ||
| 26 | |||
| 27 | my $tblName = $rs->result_source->name; | ||
| 28 | |||
| 29 | my %ret = $rs->get_columns; | ||
| 30 | $ret{"$tblName.$_"} = $ret{$_} foreach(keys %ret); | ||
| 31 | |||
| 32 | #foreach (keys %{$rs->result_source->_relationships}) { | ||
| 33 | foreach my $rel (keys %$relship) { | ||
| 34 | # relationships must exist | ||
| 35 | if (exists $rs->result_source->_relationships->{$rel}) { | ||
| 36 | my $rrow = $rs->$rel; | ||
| 37 | if (ref($rrow) eq 'DBIx::Class::ResultSet') { | ||
| 38 | if ($rrow->count == 1) { | ||
| 39 | my $single_row = $rrow->next; | ||
| 40 | %ret = (%ret,%{$self->row($single_row, $relsphip->{$rel})}); | ||
| 41 | } else { | ||
| 42 | %ret = (%ret,%{$self->resultset($rrow,undef,$relsphip->{$rel})}); | ||
| 43 | } | ||
| 44 | } elsif ($rrow && $rrow->isa('DBIx::Class::Row')) { | ||
| 45 | %ret = (%ret,%{$self->row($rrow)}); | ||
| 46 | } | ||
| 47 | } | ||
| 48 | } | ||
| 49 | |||
| 50 | return \%ret; | ||
| 51 | } | ||
| 52 | |||
| 53 | 1; |