/[cvs]/nfo/perl/libs/Data/Transfer/Sync.pm
ViewVC logotype

Diff of /nfo/perl/libs/Data/Transfer/Sync.pm

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.1 by joko, Fri Nov 29 04:45:50 2002 UTC revision 1.5 by joko, Thu Dec 5 08:06:05 2002 UTC
# Line 6  Line 6 
6  ##  ##
7  ##    ----------------------------------------------------------------------------------------  ##    ----------------------------------------------------------------------------------------
8  ##    $Log$  ##    $Log$
9    ##    Revision 1.5  2002/12/05 08:06:05  joko
10    ##    + bugfix with determining empty fields (Null) with DBD::CSV
11    ##    + debugging
12    ##    + updated comments
13    ##
14    ##    Revision 1.4  2002/12/03 15:54:07  joko
15    ##    + {import}-flag is now {prepare}-flag
16    ##
17    ##    Revision 1.3  2002/12/01 22:26:59  joko
18    ##    + minor cosmetics for logging
19    ##
20    ##    Revision 1.2  2002/12/01 04:43:25  joko
21    ##    + mapping deatil entries may now be either an ARRAY or a HASH
22    ##    + erase flag is used now (for export-operations)
23    ##    + expressions to refer to values inside deep nested structures
24    ##    - removed old mappingV2-code
25    ##    + cosmetics
26    ##    + sub _erase_all
27    ##
28  ##    Revision 1.1  2002/11/29 04:45:50  joko  ##    Revision 1.1  2002/11/29 04:45:50  joko
29  ##    + initial check in  ##    + initial check in
30  ##  ##
# Line 23  use Data::Dumper; Line 42  use Data::Dumper;
42  use misc::HashExt;  use misc::HashExt;
43  use libp qw( md5_base64 );  use libp qw( md5_base64 );
44  use libdb qw( quotesql hash2Sql );  use libdb qw( quotesql hash2Sql );
45  use Data::Transform::OO qw( hash2object );  use Data::Transform::Deep qw( hash2object refexpr2perlref );
46  use Data::Compare::Struct qw( getDifference isEmpty );  use Data::Compare::Struct qw( getDifference isEmpty );
47    
48  # get logger instance  # get logger instance
# Line 147  sub syncNodes { Line 166  sub syncNodes {
166    $logger->info( __PACKAGE__ . "->syncNodes: source=$self->{meta}->{source}->{dbkey}/$self->{meta}->{source}->{node} $direction_arrow target=$self->{meta}->{target}->{dbkey}/$self->{meta}->{target}->{node}" );    $logger->info( __PACKAGE__ . "->syncNodes: source=$self->{meta}->{source}->{dbkey}/$self->{meta}->{source}->{node} $direction_arrow target=$self->{meta}->{target}->{dbkey}/$self->{meta}->{target}->{node}" );
167    
168    # build mapping    # build mapping
169      # incoming: and Array of node map entries (Array or Hash) - e.g.
170      #   [ 'source:item_name' => 'target:class_val' ]
171      #   { source => 'event->startDateTime', target => 'begindate' }
172    foreach (@{$self->{args}->{mapping}}) {    foreach (@{$self->{args}->{mapping}}) {
173      my @key1 = split(':', $_->[0]);      if (ref $_ eq 'ARRAY') {
174      my @key2 = split(':', $_->[1]);        my @entry1 = split(':', $_->[0]);
175      push @{$self->{meta}->{$key1[0]}->{childnodes}}, $key1[1];        my @entry2 = split(':', $_->[1]);
176      push @{$self->{meta}->{$key2[0]}->{childnodes}}, $key2[1];        my $descent = [];
177          my $node = [];
178          $descent->[0] = $entry1[0];
179          $descent->[1] = $entry2[0];
180          $node->[0] = $entry1[1];
181          $node->[1] = $entry2[1];
182          push @{$self->{meta}->{$descent->[0]}->{childnodes}}, $node->[0];
183          push @{$self->{meta}->{$descent->[1]}->{childnodes}}, $node->[1];
184        } elsif (ref $_ eq 'HASH') {
185          foreach my $entry_key (keys %$_) {
186            my $entry_val = $_->{$entry_key};
187            push @{$self->{meta}->{$entry_key}->{childnodes}}, $entry_val;
188          }
189        }
190    
191    }    }
192    
193    # check partners/nodes: does partner exist / is node available?    # check partners/nodes: does partner exist / is node available?
# Line 185  sub syncNodes { Line 221  sub syncNodes {
221    
222    # import flag means: prepare the source node to be syncable    # import flag means: prepare the source node to be syncable
223    # this is useful if there are e.g. no "ident" or "checksum" columns yet inside a DBI like (row-based) storage    # this is useful if there are e.g. no "ident" or "checksum" columns yet inside a DBI like (row-based) storage
224    if ($self->{args}->{import}) {    if ($self->{args}->{prepare}) {
225      $self->_prepareNode_MetaProperties('source');      $self->_prepareNode_MetaProperties('source');
226      $self->_prepareNode_DummyIdent('source');      $self->_prepareNode_DummyIdent('source');
227      #return;      #return;
228      #$self->_erase_all($opts->{source_node});      #$self->_erase_all($opts->{source_node});
229    }    }
230        
231      # erase flag means: erase the target
232      #if ($opts->{erase}) {
233      if ($self->{args}->{erase}) {
234        # TODO: move this method to the scope of the synchronization core and wrap it around different handlers
235        #print "ERASE", "\n";
236        $self->_erase_all('target');
237      }
238    
239    $self->_syncNodes();    $self->_syncNodes();
240    
241  }  }
# Line 216  sub _syncNodes { Line 260  sub _syncNodes {
260      $results ||= $self->_getNodeList('source', $filter);      $results ||= $self->_getNodeList('source', $filter);
261    }    }
262        
263    # get reference to node list from convenient method provided by corehandle    # get reference to node list from convenient method provided by CORE-HANDLE
264    #$results ||= $self->{source}->getListUnfiltered($self->{meta}->{source}->{node});    #$results ||= $self->{source}->getListUnfiltered($self->{meta}->{source}->{node});
265    #$results ||= $self->{meta}->{source}->{storage}->getListUnfiltered($self->{meta}->{source}->{node});    #$results ||= $self->{meta}->{source}->{storage}->getListUnfiltered($self->{meta}->{source}->{node});
266    $results ||= $self->_getNodeList('source');    $results ||= $self->_getNodeList('source');
# Line 294  sub _syncNodes { Line 338  sub _syncNodes {
338      my $identOK = $self->_resolveNodeIdent('source');      my $identOK = $self->_resolveNodeIdent('source');
339      #if (!$identOK && lc $self->{args}->{direction} ne 'import') {      #if (!$identOK && lc $self->{args}->{direction} ne 'import') {
340      if (!$identOK) {      if (!$identOK) {
341        $logger->critical( __PACKAGE__ . "->syncNodes: Can not synchronize: No ident found in source node, maybe try to \"import\" this node first." );        #print Dumper($self->{meta}->{source});
342          $logger->critical( __PACKAGE__ . "->syncNodes: No ident found in source node \"$self->{meta}->{source}->{node}\", try to \"prepare\" this node first?" );
343        return;        return;
344      }      }
345    
346  #print "statload", "\n";  #print "statload", "\n";
347  #print "ident: ", $self->{node}->{source}->{ident}, "\n";  #print "ident: ", $self->{node}->{source}->{ident}, "\n";
348    #print Dumper($self->{node});
349            
350      my $statOK = $self->_statloadNode('target', $self->{node}->{source}->{ident});      my $statOK = $self->_statloadNode('target', $self->{node}->{source}->{ident});
351    
352    #print Dumper($self->{node});
353            
354      # mark node as new either if there's no ident or if stat/load failed      # mark node as new either if there's no ident or if stat/load failed
355      if (!$statOK) {      if (!$statOK) {
# Line 388  sub _syncNodes { Line 436  sub _syncNodes {
436        $tc->{attempt_new}++;        $tc->{attempt_new}++;
437        $self->_doTransferToTarget('insert');        $self->_doTransferToTarget('insert');
438        # asymmetry: refetch node from target to re-calculate new ident and checksum (TODO: is IdentAuthority of relevance here?)        # asymmetry: refetch node from target to re-calculate new ident and checksum (TODO: is IdentAuthority of relevance here?)
439          #print Dumper($self->{node});
440        $self->_statloadNode('target', $self->{node}->{target}->{ident}, 1);        $self->_statloadNode('target', $self->{node}->{target}->{ident}, 1);
441        $self->_readChecksum('target');        $self->_readChecksum('target');
442    
# Line 413  sub _syncNodes { Line 462  sub _syncNodes {
462      # change ident in source (take from target), if transfer was ok and target is an IdentAuthority      # change ident in source (take from target), if transfer was ok and target is an IdentAuthority
463      # this is (for now) called a "retransmit" indicated by a "r"-character when verbosing      # this is (for now) called a "retransmit" indicated by a "r"-character when verbosing
464      if ($self->{node}->{status}->{ok} && $self->{meta}->{target}->{storage}->{isIdentAuthority}) {      if ($self->{node}->{status}->{ok} && $self->{meta}->{target}->{storage}->{isIdentAuthority}) {
465          print "r" if $self->{verbose};
466        #print Dumper($self->{meta});        #print Dumper($self->{meta});
467        #print Dumper($self->{node});        #print Dumper($self->{node});
468        #exit;        #exit;
469        $self->_doModifySource_IdentChecksum($self->{node}->{target}->{ident});        $self->_doModifySource_IdentChecksum($self->{node}->{target}->{ident});
       print "r" if $self->{verbose};  
470      }      }
471    
472      print ":" if $self->{verbose};      print ":" if $self->{verbose};
# Line 427  sub _syncNodes { Line 476  sub _syncNodes {
476    print "\n" if $self->{verbose};    print "\n" if $self->{verbose};
477        
478    # build user-message from some stats    # build user-message from some stats
479      my $msg = "stats: $tc";      my $msg = "statistics: $tc";
480            
481      if ($tc->{error_per_row}) {      if ($tc->{error_per_row}) {
482        $msg .= "\n";        $msg .= "\n";
483        $msg .= "errors:" . "\n";        $msg .= "errors from \"error_per_row\":" . "\n";
484        $msg .= Dumper($tc->{error_per_row});        $msg .= Dumper($tc->{error_per_row});
485      }      }
486            
# Line 455  sub _dumpCompact { Line 504  sub _dumpCompact {
504      my $item = {};      my $item = {};
505      foreach my $key (keys %$_) {      foreach my $key (keys %$_) {
506        my $val = $_->{$key};        my $val = $_->{$key};
507    
508    #print Dumper($val);
509    
510        if (ref $val eq 'Set::Object') {        if (ref $val eq 'Set::Object') {
511          #print "========================= SET", "\n";          #print "========================= SET", "\n";
512          #print Dumper($val);  #print Dumper($val);
513          #print Dumper($val->members());          #print Dumper($val->members());
514          #$val = $val->members();          #$val = $val->members();
515          #$vars->[$count]->{$key} = $val->members() if $val->can("members");          #$vars->[$count]->{$key} = $val->members() if $val->can("members");
516          #$item->{$key} = $val->members() if $val->can("members");          #$item->{$key} = $val->members() if $val->can("members");
517          $item->{$key} = $val->members();          $item->{$key} = $val->members();
518          #print Dumper($vars->[$count]->{$key});          #print Dumper($vars->[$count]->{$key});
519    
520        } else {        } else {
521          $item->{$key} = $val;          $item->{$key} = $val;
522        }        }
523    
524      }      }
525      push @data, $item;      push @data, $item;
526      $count++;      $count++;
527    }    }
528    
529  #print "Dump:", "\n";  #print "Dump:", Dumper(@data), "\n";
 #print Dumper(@data);  
530    
531    $Data::Dumper::Indent = 0;    $Data::Dumper::Indent = 0;
532    my $result = Dumper(@data);    my $result = Dumper(@data);
533    $Data::Dumper::Indent = 2;    $Data::Dumper::Indent = 2;
534    return $result;    return $result;
535      
536  }  }
537    
538    
# Line 572  sub _buildMap { Line 626  sub _buildMap {
626        for (my $mapidx = 0; $mapidx <= $#childnodes; $mapidx++) {        for (my $mapidx = 0; $mapidx <= $#childnodes; $mapidx++) {
627          #my $map_right = $self->{args}->{mapping}->{$key};          #my $map_right = $self->{args}->{mapping}->{$key};
628                    
629            $self->{node}->{source}->{propcache} = {};
630            $self->{node}->{target}->{propcache} = {};
631            
632          # get property name          # get property name
633          $self->{node}->{source}->{propcache}->{property} = $self->{meta}->{source}->{childnodes}->[$mapidx];          $self->{node}->{source}->{propcache}->{property} = $self->{meta}->{source}->{childnodes}->[$mapidx];
634          $self->{node}->{target}->{propcache}->{property} = $self->{meta}->{target}->{childnodes}->[$mapidx];          $self->{node}->{target}->{propcache}->{property} = $self->{meta}->{target}->{childnodes}->[$mapidx];
# Line 589  sub _buildMap { Line 646  sub _buildMap {
646            $self->{node}->{source}->{propcache}->{value} = $self->{node}->{source}->{payload}->{$self->{node}->{source}->{propcache}->{property}};            $self->{node}->{source}->{propcache}->{value} = $self->{node}->{source}->{payload}->{$self->{node}->{source}->{propcache}->{property}};
647          }          }
648          #$self->{node}->{map}->{$key} = $value;          #$self->{node}->{map}->{$key} = $value;
649            
650            # detect expression
651            # for transferring deeply nested structures described by expressions
652            #print "val: $self->{node}->{source}->{propcache}->{value}", "\n";
653            if ($self->{node}->{source}->{propcache}->{property} =~ s/^expr://) {
654              
655              # create an anonymous sub to act as callback target dispatcher
656                my $cb_dispatcher = sub {
657                  #print "===============  CALLBACK DISPATCHER", "\n";
658                  #print "ident: ", $self->{node}->{source}->{ident}, "\n";
659                  #return $self->{node}->{source}->{ident};
660                  
661                };
662              
663    
664    #print Dumper($self->{node});
665              
666              # build callback map for helper function
667              #my $cbmap = { $self->{meta}->{source}->{IdentProvider}->{arg} => $cb_dispatcher };
668              my $cbmap = {};
669              my $value = refexpr2perlref($self->{node}->{source}->{payload}, $self->{node}->{source}->{propcache}->{property}, $cbmap);
670              $self->{node}->{source}->{propcache}->{value} = $value;
671            }
672    
673          # encode values dependent on type of underlying storage here - expand cases...          # encode values dependent on type of underlying storage here - expand cases...
674          my $storage_type = $self->{meta}->{target}->{storage}->{locator}->{type};          my $storage_type = $self->{meta}->{target}->{storage}->{locator}->{type};
675          if ($storage_type eq 'DBI') {          if ($storage_type eq 'DBI') {
676            # ...for sql            # ...for sql
677            $self->{node}->{source}->{propcache}->{value} = quotesql($self->{node}->{source}->{propcache}->{value});            $self->{node}->{source}->{propcache}->{value} = quotesql($self->{node}->{source}->{propcache}->{value});
678          } elsif ($storage_type eq 'Tangram') {          }
679             elsif ($storage_type eq 'Tangram') {
680              # iso? utf8 already possible?
681            
682          } elsif ($storage_type eq 'LDAP') {          } elsif ($storage_type eq 'LDAP') {
683            # TODO: encode utf8 here?            # TODO: encode utf8 here?
684          }          }
# Line 606  sub _buildMap { Line 689  sub _buildMap {
689        }        }
690      }      }
691    
 #print "self->{entry}: ", Dumper($self->{node}), "\n"; exit;  
   
     # for transferring deeply nested structures described by expressions  
     # this currently does not work!  
     # TODO: re-enable this!  
     if ($self->{args}->{mappingV2}) {  
         
       # apply mapping from $self->{args}->{mappingV2} to $self->{node}->{map}  
       foreach my $mapStep (@{$self->{args}->{mappingV2}}) {  
           
         # prepare left/right keys/values  
         my $left_key = $mapStep->{left};  
         my $left_val = _resolveMapStepExpr( $self->{node}->{source}->{payload}, $mapStep->{left} );  
         my $right_key = $mapStep->{right};  
         my $right_val = ( $mapStep->{right} );  
         #print "map: $map_right", "\n";  
           
         if ($mapStep->{method}) {  
           if ($mapStep->{method} eq 'v:1') {  
             $left_val = $left_key;  
           }  
         }  
   
         #$self->{node}->{map}->{$key} = $value;  
         #if ( grep(!/$right_key/, @{$self->{args}->{exclude}}) ) {  
           $self->{node}->{map}->{$right_key} = $self->{R}->quoteSql($left_val);  
         #}  
       }  
     }  
692            
693    # TODO: $logger->dump( ... );    # TODO: $logger->dump( ... );
694    #$logger->debug( "sqlmap:" . "\n" . Dumper($self->{node}->{map}) );    #$logger->debug( "sqlmap:" . "\n" . Dumper($self->{node}->{map}) );
# Line 708  sub _modifyNode { Line 762  sub _modifyNode {
762      }      }
763    }    }
764        
765      
766      #print Dumper($self->{meta});
767    
768    # DBI speaks SQL    # DBI speaks SQL
769    if ($self->{meta}->{$descent}->{storage}->{locator}->{type} eq 'DBI') {    if ($self->{meta}->{$descent}->{storage}->{locator}->{type} eq 'DBI') {
# Line 809  sub _modifyNode { Line 865  sub _modifyNode {
865        hash2object($object, $map);        hash2object($object, $map);
866    
867        # ... and re-update@orm.        # ... and re-update@orm.
868    #print Dumper($object);
869        $self->{meta}->{$descent}->{storage}->update($object);        $self->{meta}->{$descent}->{storage}->update($object);
870    
871        # asymmetry: get ident after insert        # asymmetry: get ident after insert
872        # TODO:        # TODO:
873        #   - just do this if it is an IdentAuthority        #   - just do this if it is an IdentAuthority
874        #   - use IdentProvider metadata here        #   - use IdentProvider metadata here
875        $self->{node}->{$descent}->{ident} = $self->{meta}->{$descent}->{storage}->id($object);  #print Dumper($self->{meta}->{$descent});
876          my $oid = $self->{meta}->{$descent}->{storage}->id($object);
877    #print "oid: $oid", "\n";
878          $self->{node}->{$descent}->{ident} = $oid;
879    
880    
881      } elsif (lc $action eq 'update') {      } elsif (lc $action eq 'update') {
# Line 912  sub _statloadNode { Line 972  sub _statloadNode {
972        #print "\n", "Attempt to fetch entry implicitely by ident failed: no ident given! This may result in an insert if no write-protection is in the way.", "\n";        #print "\n", "Attempt to fetch entry implicitely by ident failed: no ident given! This may result in an insert if no write-protection is in the way.", "\n";
973        return;        return;
974      }      }
975        
976        # patch for DBD::CSV
977        if ($ident && $ident eq 'Null') {
978          return;
979        }
980    
981      my $result = $self->{meta}->{$descent}->{storage}->sendQuery({      my $result = $self->{meta}->{$descent}->{storage}->sendQuery({
982        node => $self->{meta}->{$descent}->{node},        node => $self->{meta}->{$descent}->{node},
# Line 926  sub _statloadNode { Line 991  sub _statloadNode {
991      my $entry = $result->getNextEntry();      my $entry = $result->getNextEntry();
992      my $status = $result->getStatus();      my $status = $result->getStatus();
993    
994    #print Dumper($status);
995        
996      # TODO: enhance error handling (store inside tc)      # TODO: enhance error handling (store inside tc)
997      #if (!$row) {      #if (!$row) {
998      #  print "\n", "row error", "\n";      #  print "\n", "row error", "\n";
999      #  next;      #  next;
1000      #}      #}
1001      if (($status && $status->{err}) || !$entry) {  
1002        #$logger->critical( __PACKAGE__ . "->_loadNode (ident=\"$ident\") failed" );      # these checks run before actually loading payload- and meta-data to node-container
1003        return;      
1004      }        # 1st level - hard error
1005          if ($status && $status->{err}) {
1006            $logger->debug( __PACKAGE__ . "->_statloadNode (ident=\"$ident\") failed - hard error (that's ok)" );
1007            return;
1008          }
1009      
1010          # 2nd level - logical (empty/notfound) error
1011          if (($status && $status->{empty}) || !$entry) {
1012            $logger->debug( __PACKAGE__ . "->_statloadNode (ident=\"$ident\") failed - logical error (that's ok)" );
1013            #print "no entry (logical)", "\n";
1014            return;
1015          }
1016    
1017    #print Dumper($entry);
1018    
1019      # was:      # was:
1020      # $self->{node}->{$descent}->{ident} = $ident;        # $self->{node}->{$descent}->{ident} = $ident;  
1021      # is:      # is:
1022      # TODO: re-resolve ident from entry via metadata "IdentProvider"      # TODO: re-resolve ident from entry via metadata "IdentProvider" here - like elsewhere
1023      $self->{node}->{$descent}->{ident} = $ident;      $self->{node}->{$descent}->{ident} = $ident;
1024      $self->{node}->{$descent}->{payload} = $entry;      $self->{node}->{$descent}->{payload} = $entry;
1025    
1026    }    }
1027        
1028    return 1;    return 1;
# Line 964  sub _doModifySource_IdentChecksum { Line 1046  sub _doModifySource_IdentChecksum {
1046      $self->{meta}->{source}->{IdentProvider}->{arg} => $ident_new,      $self->{meta}->{source}->{IdentProvider}->{arg} => $ident_new,
1047      cs => $self->{node}->{target}->{checksum},      cs => $self->{node}->{target}->{checksum},
1048    };    };
1049    #print Dumper($map);  
1050    #print Dumper($self->{node});  #print Dumper($map);
1051    #exit;  #print Dumper($self->{node});
1052    #exit;
1053    
1054    $self->_modifyNode('source', 'update', $map);    $self->_modifyNode('source', 'update', $map);
1055  }  }
1056    
# Line 1048  sub _prepareNode_DummyIdent { Line 1132  sub _prepareNode_DummyIdent {
1132      }      }
1133      my $crit = join ' AND ', @crits;      my $crit = join ' AND ', @crits;
1134      print "p" if $self->{verbose};      print "p" if $self->{verbose};
1135    
1136    #print Dumper($map);
1137    #print Dumper($crit);
1138    
1139      $self->_modifyNode($descent, 'update', $map, $crit);      $self->_modifyNode($descent, 'update', $map, $crit);
1140      $i++;      $i++;
1141    }    }
# Line 1063  sub _prepareNode_DummyIdent { Line 1151  sub _prepareNode_DummyIdent {
1151  # TODO: handle this in an abstract way (wipe out use of 'source' and/or 'target' inside core)  # TODO: handle this in an abstract way (wipe out use of 'source' and/or 'target' inside core)
1152  sub _otherSide {  sub _otherSide {
1153    my $self = shift;    my $self = shift;
1154    my $side = shift;    my $descent = shift;
1155    return 'source' if $side eq 'target';    return 'source' if $descent eq 'target';
1156    return 'target' if $side eq 'source';    return 'target' if $descent eq 'source';
1157    return '';    return '';
1158  }  }
1159    
1160    sub _erase_all {
1161      my $self = shift;
1162      my $descent = shift;
1163      #my $node = shift;
1164      my $node = $self->{meta}->{$descent}->{node};
1165      $self->{meta}->{$descent}->{storage}->eraseAll($node);
1166    }
1167    
1168    
1169  =pod  =pod
1170    
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.5
MailToCvsAdmin">MailToCvsAdmin
 ViewVC Help
Powered by ViewVC 1.1.26 RSS 2.0 feed