X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2FDBICTest%2FSchema%2FTrack.pm;h=c43591a2be994b5bb679cfaf5a546603c86dc3f5;hb=7df2b5df3d6c48b35c73a9e840d8e8ef395b11f6;hp=0a6c346967e60727d747a60290b2c7bdc556c029;hpb=18129e8117befc4681180910901210aeef4fdf42;p=dbsrgits%2FDBIx-Class.git diff --git a/t/lib/DBICTest/Schema/Track.pm b/t/lib/DBICTest/Schema/Track.pm index 0a6c346..c43591a 100644 --- a/t/lib/DBICTest/Schema/Track.pm +++ b/t/lib/DBICTest/Schema/Track.pm @@ -1,8 +1,17 @@ -package # hide from PAUSE +package # hide from PAUSE DBICTest::Schema::Track; -use base qw/DBICTest::BaseResult/; -__PACKAGE__->load_components(qw/InflateColumn::DateTime Ordered/); +use warnings; +use strict; + +use base 'DBICTest::BaseResult'; +use DBICTest::Util 'check_customcond_args'; + +__PACKAGE__->load_components(qw{ + +DBICTest::DeployComponent + InflateColumn::DateTime + Ordered +}); __PACKAGE__->table('track'); __PACKAGE__->add_columns( @@ -30,10 +39,6 @@ __PACKAGE__->add_columns( data_type => 'datetime', is_nullable => 1 }, - small_dt => { # for mssql and sybase DT tests - data_type => 'smalldatetime', - is_nullable => 1 - }, ); __PACKAGE__->set_primary_key('trackid'); @@ -43,9 +48,37 @@ __PACKAGE__->add_unique_constraint([ qw/cd title/ ]); __PACKAGE__->position_column ('position'); __PACKAGE__->grouping_column ('cd'); +# the undef condition in this rel is *deliberate* +# tests oddball legacy syntax +__PACKAGE__->belongs_to( cd => 'DBICTest::Schema::CD', undef, { + proxy => { cd_title => 'title' }, +}); +# custom condition coderef +__PACKAGE__->belongs_to( cd_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; -__PACKAGE__->belongs_to( cd => 'DBICTest::Schema::CD' ); -__PACKAGE__->belongs_to( disc => 'DBICTest::Schema::CD' => 'cd'); + return ( + { + "$args->{foreign_alias}.cdid" => { -ident => "$args->{self_alias}.cd" }, + }, + + ! $args->{self_result_object} ? () : { + "$args->{foreign_alias}.cdid" => $args->{self_result_object}->get_column('cd') + }, + + ! $args->{foreign_values} ? () : { + "$args->{self_alias}.cd" => $args->{foreign_values}{cdid} + }, + ); +} +); +__PACKAGE__->belongs_to( disc => 'DBICTest::Schema::CD' => 'cd', { + proxy => 'year' +}); __PACKAGE__->might_have( cd_single => 'DBICTest::Schema::CD', 'single_track' ); __PACKAGE__->might_have( lyrics => 'DBICTest::Schema::Lyrics', 'track_id' ); @@ -53,12 +86,43 @@ __PACKAGE__->might_have( lyrics => 'DBICTest::Schema::Lyrics', 'track_id' ); __PACKAGE__->belongs_to( "year1999cd", "DBICTest::Schema::Year1999CDs", - { "foreign.cdid" => "self.cd" }, + 'cd', + { join_type => 'left' }, # the relationship is of course optional ); __PACKAGE__->belongs_to( "year2000cd", "DBICTest::Schema::Year2000CDs", - { "foreign.cdid" => "self.cd" }, + 'cd', + { join_type => 'left' }, ); +__PACKAGE__->has_many ( + next_tracks => __PACKAGE__, + 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}.cd" => { -ident => "$args->{self_alias}.cd" }, + "$args->{foreign_alias}.position" => { '>' => { -ident => "$args->{self_alias}.position" } }, + }, + $args->{self_result_object} && { + "$args->{foreign_alias}.cd" => $args->{self_result_object}->get_column('cd'), + "$args->{foreign_alias}.position" => { '>' => $args->{self_result_object}->pos }, + } + ) + } +); + +our $hook_cb; + +sub sqlt_deploy_hook { + my $class = shift; + + $hook_cb->($class, @_) if $hook_cb; + $class->next::method(@_) if $class->next::can; +} + 1;