getting last_insert


No such thing as a small change
	PerlMonks

getting last_insert_id

by palette (Scribe)

on Mar 28, 2007 at 14:18 UTC ( #607029=perlquestion: print w/replies, xml )

Need Help??

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]

Back to Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: perlquestion [id://607029]
Approved by Corion
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others having an uproarious good time at the Monastery: (3)

As of 2023-05-31 16:50 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found

Notices^?