X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2FDBICTest%2FSchema%2FYear1999CDs.pm;h=db3bc3f2093d4cac80738e9f462d0d93e701c851;hb=c97338007ede15e7c62095a642b3de382a3508bd;hp=4aea12203c19f1d9993e19d69fdd2b4a49bdea81;hpb=660cf1be74795a5a5784f413741816413a724c1a;p=dbsrgits%2FDBIx-Class.git diff --git a/t/lib/DBICTest/Schema/Year1999CDs.pm b/t/lib/DBICTest/Schema/Year1999CDs.pm index 4aea122..db3bc3f 100644 --- a/t/lib/DBICTest/Schema/Year1999CDs.pm +++ b/t/lib/DBICTest/Schema/Year1999CDs.pm @@ -1,16 +1,15 @@ -package # hide from PAUSE +package # hide from PAUSE DBICTest::Schema::Year1999CDs; ## Used in 104view.t use base qw/DBICTest::BaseResult/; -use DBIx::Class::ResultSource::View; __PACKAGE__->table_class('DBIx::Class::ResultSource::View'); __PACKAGE__->table('year1999cds'); __PACKAGE__->result_source_instance->is_virtual(1); __PACKAGE__->result_source_instance->view_definition( - "SELECT cdid, artist, title FROM cd WHERE year ='1999'" + "SELECT cdid, artist, title, single_track FROM cd WHERE year ='1999'" ); __PACKAGE__->add_columns( 'cdid' => { @@ -24,9 +23,17 @@ __PACKAGE__->add_columns( data_type => 'varchar', size => 100, }, - + 'single_track' => { + data_type => 'integer', + is_nullable => 1, + is_foreign_key => 1, + }, ); __PACKAGE__->set_primary_key('cdid'); __PACKAGE__->add_unique_constraint([ qw/artist title/ ]); +__PACKAGE__->belongs_to( artist => 'DBICTest::Schema::Artist' ); +__PACKAGE__->has_many( tracks => 'DBICTest::Schema::Track', + { "foreign.cd" => "self.cdid" }); + 1;