Commit | Line | Data |
7364d776 |
1 | package # hide from PAUSE |
2 | ViewDeps::Result::ANameArtists; |
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('a_name_artists'); |
10 | __PACKAGE__->result_source_instance->view_definition( |
11 | "SELECT id,name FROM artist WHERE name like 'a%'" |
12 | ); |
13 | |
14 | __PACKAGE__->add_columns( |
15 | id => { data_type => 'integer', is_auto_increment => 1 }, |
16 | name => { data_type => 'text' }, |
17 | ); |
18 | |
19 | __PACKAGE__->set_primary_key('id'); |
20 | |
21 | __PACKAGE__->has_many( 'cds', 'ViewDeps::Result::CD', |
22 | { "foreign.artist" => "self.id" }, |
23 | ); |
24 | |
25 | 1; |