Skip Menu |
 

This queue is for tickets about the Class-DBI CPAN distribution.

Report information
The Basics
Id: 13305
Status: stalled
Priority: 0/
Queue: Class-DBI

People
Owner: Nobody in particular
Requestors: jason [...] multiply.org
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



To: cdbi-talk [...] groups.kasei.com
From: jason [...] multiply.org
Subject: feature request for after_update trigger
Date: Wed, 12 May 2004 20:43:55 +0100 (BST)
Download (untitled) / with headers
text/plain 1.3k
Hi All. I have a feature request regarding an after_update trigger. Currently, it receives the object in question (post update), the list of discardecd columns and the number of affected rows. It looks like this: $VAR1 = [ bless( { 'dependency_id' => '2', '__Changed' => { 'input_value' => 1 }, 'input_value' => 'asdf' }, 'PackageName' ), 'discard_columns', [ 'input_value' ] ]; It would be nice if you could get something like this instead: $VAR1 = [ bless( { 'dependency_id' => '2', '__Changed' => { 'input_value' => 1 }, 'input_value' => 'asdf' }, 'PackageName' ), 'discard_columns', [ 'input_value' => 'old_value_here' ] ]; In oracle, you have :old and :new automatic variables in certain triggers. I recently tried to do something with an after_update trigger, but I can no longer retrieve the pre-update value of the field I want to act on. Changing discard_columns to changed_columns as a list of field names and old and new values would be most helpful. Thoughts?
Download (untitled) / with headers
text/plain 731b
[jason@multiply.org - Sat Jun 18 07:31:58 2005]: Show quoted text
> In oracle, you have :old and :new automatic variables in certain > triggers. I recently tried to do something with an after_update > trigger, but I can no longer retrieve the pre-update value of the > field I want to act on. Changing discard_columns to changed_columns > as a list of field names and old and new values would be most > helpful. > Thoughts?
I'd certainly like to see something like this, but it's not high on my priority list (as you've probably guessed!) I'm open to patches, so you may want to rustle up some support on the mailing list if you're still interested in this, and see if you can get something together. Sorry for the delay, Tony


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.