[Dbix-class] Use autoincremented value in other column

[David Schmidt]

Hello everyone,

Is there any way (without transactions or 2 DB trips) to achieve the following:

Insert a row and use the autoincremented primary key value in another column.

table: pictures
id integer primary key,
filename varchar2(128)

my $picture = $c->model('myDB::Pictures')->new_result({
                                           filename => <ID> . '_' . $filename
                                });

thanks in advance

david