X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2FDBICTest%2FSchema%2FCD.pm;h=fadd5391100a75a52a900182f0d53958fcf80e38;hb=157ce0cfdee831491de41596b44e19cd7b45dfeb;hp=0c79e609c99f9c8c4d6dcef626c15d0c969df4be;hpb=c89815db08bb4cc35d69efefa8a27bf71ae13142;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/t/lib/DBICTest/Schema/CD.pm b/t/lib/DBICTest/Schema/CD.pm index 0c79e60..fadd539 100644 --- a/t/lib/DBICTest/Schema/CD.pm +++ b/t/lib/DBICTest/Schema/CD.pm @@ -1,9 +1,12 @@ package # hide from PAUSE DBICTest::Schema::CD; -use base 'DBIx::Class::Core'; +use base qw/DBICTest::BaseResult/; + +# this tests table name as scalar ref +# DO NOT REMOVE THE \ +__PACKAGE__->table(\'cd'); -__PACKAGE__->table('cd'); __PACKAGE__->add_columns( 'cdid' => { data_type => 'integer', @@ -23,6 +26,7 @@ __PACKAGE__->add_columns( 'genreid' => { data_type => 'integer', is_nullable => 1, + accessor => undef, }, 'single_track' => { data_type => 'integer', @@ -38,7 +42,9 @@ __PACKAGE__->belongs_to( artist => 'DBICTest::Schema::Artist', undef, { }); # in case this is a single-cd it promotes a track from another cd -__PACKAGE__->belongs_to( single_track => 'DBICTest::Schema::Track' ); +__PACKAGE__->belongs_to( single_track => 'DBICTest::Schema::Track', 'single_track', + { join_type => 'left'} +); __PACKAGE__->has_many( tracks => 'DBICTest::Schema::Track' ); __PACKAGE__->has_many( @@ -54,6 +60,7 @@ __PACKAGE__->might_have( { proxy => [ qw/notes/ ] }, ); __PACKAGE__->might_have(artwork => 'DBICTest::Schema::Artwork', 'cd_id'); +__PACKAGE__->has_one(mandatory_artwork => 'DBICTest::Schema::Artwork', 'cd_id'); __PACKAGE__->many_to_many( producers => cd_to_producer => 'producer' ); __PACKAGE__->many_to_many( @@ -67,13 +74,19 @@ __PACKAGE__->belongs_to('genre', 'DBICTest::Schema::Genre', join_type => 'left', on_delete => 'SET NULL', on_update => 'CASCADE', - any_null_means_no_value => 1, }, ); -#__PACKAGE__->add_relationship('genre', 'DBICTest::Schema::Genre', -# { 'foreign.genreid' => 'self.genreid' }, -# { 'accessor' => 'single' } -#); +#This second relationship was added to test the short-circuiting of pointless +#queries provided by undef_on_null_fk. the relevant test in 66relationship.t +__PACKAGE__->belongs_to('genre_inefficient', 'DBICTest::Schema::Genre', + { 'foreign.genreid' => 'self.genreid' }, + { + join_type => 'left', + on_delete => 'SET NULL', + on_update => 'CASCADE', + undef_on_null_fk => 0, + }, +); 1;