Commit | Line | Data |
a1e6f9a5 |
1 | package # hide from PAUSE |
2 | DBICTest::Schema::Year1999CDs; |
3 | ## Used in 104view.t |
4 | |
660cf1be |
5 | use base qw/DBICTest::BaseResult/; |
a1e6f9a5 |
6 | use DBIx::Class::ResultSource::View; |
7 | |
8 | __PACKAGE__->table_class('DBIx::Class::ResultSource::View'); |
9 | |
10 | __PACKAGE__->table('year1999cds'); |
11 | __PACKAGE__->result_source_instance->is_virtual(1); |
12 | __PACKAGE__->result_source_instance->view_definition( |
13 | "SELECT cdid, artist, title FROM cd WHERE year ='1999'" |
14 | ); |
15 | __PACKAGE__->add_columns( |
16 | 'cdid' => { |
17 | data_type => 'integer', |
18 | is_auto_increment => 1, |
19 | }, |
20 | 'artist' => { |
21 | data_type => 'integer', |
22 | }, |
23 | 'title' => { |
24 | data_type => 'varchar', |
25 | size => 100, |
26 | }, |
27 | |
28 | ); |
29 | __PACKAGE__->set_primary_key('cdid'); |
30 | __PACKAGE__->add_unique_constraint([ qw/artist title/ ]); |
31 | |
32 | 1; |