DBIx::Class::ResultSet Update or Create on multiple unique constraints

Question

I was wondering if it is possible update_or_create on multiple unique constraints in dbix

Ex From Cpan:

 my $cd = $schema->resultset('CD')->update_or_create(
    {
      artist => 'Massive Attack',
      title  => 'Mezzanine',
      year   => 1998,
    },
    { key => 'cd_artist_title' }
  );

What I would like to do

   my $cd = $schema->resultset('CD')->update_or_create(
    {
      artist => 'Massive Attack',
      title  => 'Mezzanine',
      year   => 1998,
    },
    { key => {'cd_artist_title','year' }
  );

score 4 · Accepted Answer · edited Jun 10 '11 at 11:35

4

I figured it out: you have to define the unique constraint in the Controller with add_unique_constraint.

edited Jun 10 '11 at 11:35

daxim

39,270
4
65
132

answered Jun 10 '11 at 11:14

shaneburgess

15,702
15
47
66

2

`s/Controller/ResultSource/;` – Ashley Jun 10 '11 at 13:09

DBIx::Class::ResultSet Update or Create on multiple unique constraints

1 Answers1