t/lib/ViewDepsBad/Result/AbaNameArtists.pm

   1 package    # hide from PAUSE
   2     ViewDepsBad::Result::AbaNameArtists;
   3
   4 use strict;
   5 use warnings;
   6 use base 'DBIx::Class::Core';
   7
   8 __PACKAGE__->table_class('DBIx::Class::ResultSource::View');
   9 __PACKAGE__->table('aba_name_artists');
  10 __PACKAGE__->result_source_instance->view_definition(
  11     "SELECT id,name FROM ab_name_artists WHERE name like 'aba%'" );
  12 __PACKAGE__->result_source_instance->deploy_depends_on(
  13     ["AbNameArtists", "AbaNameArtistsAnd2010CDsWithManyTracks"] );
  14
  15 __PACKAGE__->add_columns(
  16     id   => { data_type => 'integer', is_auto_increment => 1 },
  17     name => { data_type => 'text' },
  18 );
  19
  20 __PACKAGE__->set_primary_key('id');
  21
  22 __PACKAGE__->has_many( 'cds', 'ViewDepsBad::Result::CD',
  23     { "foreign.artist" => "self.id" },
  24 );
  25
  26 1;