X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2FDBICTest%2FSchema%2FArtist.pm;h=00c1ef670d2711c045d5c1aae4fc512f47616041;hb=096ab902a;hp=2745c0389baecba263d8e7a8e5b555711d0510f7;hpb=52c53388b5381f9a064a9e31491ff8ce2a123990;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/t/lib/DBICTest/Schema/Artist.pm b/t/lib/DBICTest/Schema/Artist.pm index 2745c03..00c1ef6 100644 --- a/t/lib/DBICTest/Schema/Artist.pm +++ b/t/lib/DBICTest/Schema/Artist.pm @@ -1,7 +1,11 @@ -package # hide from PAUSE +package # hide from PAUSE DBICTest::Schema::Artist; -use base qw/DBICTest::BaseResult/; +use warnings; +use strict; + +use base 'DBICTest::BaseResult'; +use DBICTest::Util 'check_customcond_args'; __PACKAGE__->table('artist'); __PACKAGE__->source_info({ @@ -30,19 +34,106 @@ __PACKAGE__->add_columns( }, ); __PACKAGE__->set_primary_key('artistid'); +__PACKAGE__->add_unique_constraint(['name']); +__PACKAGE__->add_unique_constraint(artist => ['artistid']); # do not remove, part of a test +__PACKAGE__->add_unique_constraint(u_nullable => [qw/charfield rank/]); + __PACKAGE__->mk_classdata('field_name_for', { artistid => 'primary key', name => 'artist name', }); +# the undef condition in this rel is *deliberate* +# tests oddball legacy syntax __PACKAGE__->has_many( cds => 'DBICTest::Schema::CD', undef, - { order_by => 'year' }, + { order_by => { -asc => 'year'} }, +); + +__PACKAGE__->has_many( + cds_cref_cond => 'DBICTest::Schema::CD', + sub { + # This is for test purposes only. A regular user does not + # need to sanity check the passed-in arguments, this is what + # the tests are for :) + my $args = &check_customcond_args; + + return ( + { "$args->{foreign_alias}.artist" => { '=' => { -ident => "$args->{self_alias}.artistid"} }, + }, + $args->{self_result_object} && { + "$args->{foreign_alias}.artist" => $args->{self_rowobj}->artistid, # keep old rowobj syntax as a test + } + ); + }, +); + +__PACKAGE__->has_many( + cds_80s => 'DBICTest::Schema::CD', + sub { + # This is for test purposes only. A regular user does not + # need to sanity check the passed-in arguments, this is what + # the tests are for :) + my $args = &check_customcond_args; + + return ( + { "$args->{foreign_alias}.artist" => { '=' => \ "$args->{self_alias}.artistid" }, + "$args->{foreign_alias}.year" => { '>' => 1979, '<' => 1990 }, + }, + $args->{self_result_object} && { + "$args->{foreign_alias}.artist" => { '=' => \[ '?', $args->{self_result_object}->artistid ] }, + "$args->{foreign_alias}.year" => { '>' => 1979, '<' => 1990 }, + } + ); + }, ); + + +__PACKAGE__->has_many( + cds_84 => 'DBICTest::Schema::CD', + sub { + # This is for test purposes only. A regular user does not + # need to sanity check the passed-in arguments, this is what + # the tests are for :) + my $args = &check_customcond_args; + + return ( + { "$args->{foreign_alias}.artist" => { -ident => "$args->{self_alias}.artistid" }, + "$args->{foreign_alias}.year" => 1984, + }, + $args->{self_result_object} && { + "$args->{foreign_alias}.artist" => $args->{self_result_object}->artistid, + "$args->{foreign_alias}.year" => 1984, + } + ); + } +); + + +__PACKAGE__->has_many( + cds_90s => 'DBICTest::Schema::CD', + sub { + # This is for test purposes only. A regular user does not + # need to sanity check the passed-in arguments, this is what + # the tests are for :) + my $args = &check_customcond_args; + + return ( + { "$args->{foreign_alias}.artist" => { -ident => "$args->{self_alias}.artistid" }, + "$args->{foreign_alias}.year" => { '>' => 1989, '<' => 2000 }, + } + ); + } +); + + __PACKAGE__->has_many( cds_unordered => 'DBICTest::Schema::CD' ); +__PACKAGE__->has_many( + cds_very_very_very_long_relationship_name => 'DBICTest::Schema::CD' +); __PACKAGE__->has_many( twokeys => 'DBICTest::Schema::TwoKeys' ); __PACKAGE__->has_many( onekeys => 'DBICTest::Schema::OneKey' ); @@ -58,6 +149,25 @@ __PACKAGE__->has_many( ); __PACKAGE__->many_to_many('artworks', 'artwork_to_artist', 'artwork'); +__PACKAGE__->has_many( + cds_without_genre => 'DBICTest::Schema::CD', + sub { + # This is for test purposes only. A regular user does not + # need to sanity check the passed-in arguments, this is what + # the tests are for :) + my $args = &check_customcond_args; + + return ( + { + "$args->{foreign_alias}.artist" => { -ident => "$args->{self_alias}.artistid" }, + "$args->{foreign_alias}.genreid" => undef, + }, $args->{self_result_object} && { + "$args->{foreign_alias}.artist" => $args->{self_result_object}->artistid, + "$args->{foreign_alias}.genreid" => undef, + } + ), + }, +); sub sqlt_deploy_hook { my ($self, $sqlt_table) = @_; @@ -70,7 +180,7 @@ sub sqlt_deploy_hook { sub store_column { my ($self, $name, $value) = @_; - $value = 'X '.$value if ($name eq 'name' && $value && $value =~ /store_column test/); + $value = 'X '.$value if ($name eq 'name' && defined $value && $value =~ /(X )?store_column test/); $self->next::method($name, $value); }