[Openinteract-dev] refetch() and update() in SPOPS::DBI

[Ray Z. <rz...@co...>]

Chris,

I know it's been a while since we've discussed these ideas (around 
8/9/01 on ope...@li...), but I finally 
decided to implement a refetch and an update method in SPOPS::DBI. I 
know you weren't completely happy with the name 'update' ... feel 
free to change it to something you like better.

This currently does what I need it to do, but that doesn't mean it 
won't break some area of SPOPS that I don't normally use (security, 
field mapping, etc).
Now I'll just have to generalize it to make it work in ESPOPS. BTW, 
the patch is against SPOPS-0.61.

Here are some examples of usage ...

   $new_val = $obj->refetch( 'field1' );
   ($new_val1, $new_val2) = $obj->refetch( [ qw/ field1 field2 / ] );

   $obj->{field1} = $new_value1;
   $obj->update( 'field1' );

   $obj->{field1} = $new_value1;
   $obj->{field2} = $new_value2;
   $obj->update( [ qw/ field1 field2 / ] );

   $obj->update( { field1 => $new_value1,
                   field2 => $new_value2 } );

   $obj->update( { field1 => $new_value1,
                   field2 => $new_value2 }, { if_match => 1 } );

   $obj->update( { field1 => $new_value1,
                   field2 => $new_value2 }, { if_match => { field3 => $val3 } );

   $obj->update( { field1 => $new_value1,
                   field2 => $new_value2 }, { where => 'field3 > $val3' } );

Let me know what you think ... btw, any progress on any of my other 
pet SPOPS enhancements? :-)

-- 
  Ray Zimmerman  / e-mail: rz...@co... / 428-B Phillips Hall
   Sr Research  /   phone: (607) 255-9645  /  Cornell University
    Associate  /      FAX: (815) 377-3932 /   Ithaca, NY  14853