t/lib/DBICTest/Schema/Artwork.pm

   1 package # hide from PAUSE
   2     DBICTest::Schema::Artwork;
   3
   4 use base qw/DBICTest::BaseResult/;
   5
   6 __PACKAGE__->table('cd_artwork');
   7 __PACKAGE__->add_columns(
   8   'cd_id' => {
   9     data_type => 'integer',
  10     is_nullable => 0,
  11   },
  12 );
  13 __PACKAGE__->set_primary_key('cd_id');
  14 __PACKAGE__->belongs_to('cd', 'DBICTest::Schema::CD', 'cd_id');
  15 __PACKAGE__->has_many('images', 'DBICTest::Schema::Image', 'artwork_id');
  16
  17 __PACKAGE__->has_many('artwork_to_artist', 'DBICTest::Schema::Artwork_to_Artist', 'artwork_cd_id');
  18 __PACKAGE__->many_to_many('artists', 'artwork_to_artist', 'artist');
  19
  20 # both to test manytomany with custom rel
  21 __PACKAGE__->many_to_many('artists_test_m2m', 'artwork_to_artist', 'artist_test_m2m');
  22 __PACKAGE__->many_to_many('artists_test_m2m_noopt', 'artwork_to_artist', 'artist_test_m2m_noopt');
  23
  24 # other test to manytomany
  25 __PACKAGE__->has_many('artwork_to_artist_test_m2m', 'DBICTest::Schema::Artwork_to_Artist',
  26                       sub {
  27                         my $args = shift;
  28                         return (
  29                                 { "$args->{foreign_alias}.artwork_cd_id" => { -ident => "$args->{self_alias}.cd_id" },
  30                                 },
  31                                 $args->{self_rowobj} && {
  32                                   "$args->{foreign_alias}.artwork_cd_id" => $args->{self_rowobj}->cd_id,
  33                                 }
  34                                );
  35                       });
  36 __PACKAGE__->many_to_many('artists_test_m2m2', 'artwork_to_artist_test_m2m', 'artist');
  37
  38 1;