Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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' }
  );
like image 398
shaneburgess Avatar asked Oct 11 '22 19:10

shaneburgess


1 Answers

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

like image 147
shaneburgess Avatar answered Oct 26 '22 17:10

shaneburgess