getting last_insert

palette has asked for the wisdom of the Perl Monks concerning the following question:

I am using DBIx::Class

$self->{schema}->populate('Order',
                         [ [ qw/description subcode creationdate/],
                         [ $element->severity."-".$element->message , 
+                         $element->completionCode, $current_date ]]);
[download]

I have a sequense for this table which will insert the value in the primary key field of this table ie; order_id.

Now after populating the table I want to get the the value inserted inthe primary key field.

Can anyone suggest what si the easiest way of doing this in DBIx::Class

Comment on getting last_insert_id Download Code

Replies are listed 'Best First'.
Re: getting last_insert_id by bobf (Monsignor) on Mar 28, 2007 at 15:02 UTC
DBI has a method called `last_insert_id`, but you're using DBIx::Class. Take a look at the `insert` method in DBIx::Class::PK::Auto - it may do the trick.	[reply] [d/l] [select]