X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2FDBICTest%2FSchema%2FArtist.pm;h=20affe0e412e7b81444f8ca9e9a65b879bdc58f8;hb=4a233f3019d2baa4bf2abee0c873c74d5cdf3a11;hp=c57537444f502b53fc996a1ee1cd70bb7834ed7d;hpb=1f5bf3246dd2046c2979b1c59af36fd152aaab85;p=dbsrgits%2FDBIx-Class.git diff --git a/t/lib/DBICTest/Schema/Artist.pm b/t/lib/DBICTest/Schema/Artist.pm index c575374..20affe0 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 'DBIx::Class::Core'; +use warnings; +use strict; + +use base qw/DBICTest::BaseResult/; +use Carp qw/confess/; __PACKAGE__->table('artist'); __PACKAGE__->source_info({ @@ -30,6 +34,10 @@ __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', @@ -38,11 +46,90 @@ __PACKAGE__->mk_classdata('field_name_for', { __PACKAGE__->has_many( cds => 'DBICTest::Schema::CD', undef, - { order_by => 'year' }, + { order_by => { -asc => 'year'} }, +); + + +__PACKAGE__->has_many( + cds_80s => 'DBICTest::Schema::CD', + sub { + my $args = shift; + + # 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 @missing_args = grep { ! defined $args->{$_} } + qw/self_alias foreign_alias self_resultsource foreign_relname/; + confess "Required arguments not supplied to custom rel coderef: @missing_args\n" + if @missing_args; + + return ( + { "$args->{foreign_alias}.artist" => { '=' => { -ident => "$args->{self_alias}.artistid"} }, + "$args->{foreign_alias}.year" => { '>' => 1979, '<' => 1990 }, + }, + $args->{self_rowobj} && { + "$args->{foreign_alias}.artist" => $args->{self_rowobj}->artistid, + "$args->{foreign_alias}.year" => { '>' => 1979, '<' => 1990 }, + } + ); + }, +); + + +__PACKAGE__->has_many( + cds_84 => 'DBICTest::Schema::CD', + sub { + my $args = shift; + + # 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 @missing_args = grep { ! defined $args->{$_} } + qw/self_alias foreign_alias self_resultsource foreign_relname/; + confess "Required arguments not supplied to custom rel coderef: @missing_args\n" + if @missing_args; + + return ( + { "$args->{foreign_alias}.artist" => { -ident => "$args->{self_alias}.artistid" }, + "$args->{foreign_alias}.year" => 1984, + }, + $args->{self_rowobj} && { + "$args->{foreign_alias}.artist" => $args->{self_rowobj}->artistid, + "$args->{foreign_alias}.year" => 1984, + } + ); + } +); + + +__PACKAGE__->has_many( + cds_90s => 'DBICTest::Schema::CD', + sub { + my $args = shift; + + # 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 @missing_args = grep { ! defined $args->{$_} } + qw/self_alias foreign_alias self_resultsource foreign_relname/; + confess "Required arguments not supplied to custom rel coderef: @missing_args\n" + if @missing_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' ); @@ -53,6 +140,12 @@ __PACKAGE__->has_many( { cascade_copy => 0 } # this would *so* not make sense ); +__PACKAGE__->has_many( + artwork_to_artist => 'DBICTest::Schema::Artwork_to_Artist' => 'artist_id' +); +__PACKAGE__->many_to_many('artworks', 'artwork_to_artist', 'artwork'); + + sub sqlt_deploy_hook { my ($self, $sqlt_table) = @_; @@ -62,4 +155,11 @@ sub sqlt_deploy_hook { } } +sub store_column { + my ($self, $name, $value) = @_; + $value = 'X '.$value if ($name eq 'name' && $value && $value =~ /(X )?store_column test/); + $self->next::method($name, $value); +} + + 1;