No such thing as a small change | |
PerlMonks |
Re: data historization with DBIx::Classby Brutha (Friar) |
on Mar 03, 2011 at 07:19 UTC ( [id://891159]=note: print w/replies, xml ) | Need Help?? |
Although this is quite old, I just offer my solution which might be helpful for another future reader, as this one made me known with the Row->copy() and the Journal module. But none of both really helped me. My problem was the following. Every row has a marker column to mark it as active, history rows are saved in the same table, every row has a timestamp. So I have to copy the current active row, set the active marker to 0 and insert a new copy with the current timestamp and active marker as 1. Here my shortened code:
This gives two SQL statements, which is fine as I have to change differnet columns in two rows. And it came to pass that in time the Great God Om spake unto Brutha, the Chosen One: "Psst!"
In Section
Seekers of Perl Wisdom
|
|