X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2FDBICTest%2FSchema%2FTrack.pm;h=7a738a1b13ff3bc7ad57daaa2e93b6a083d3493e;hb=123df5269e2a19f93ff072bbf92832fb23d19f4c;hp=691974ae4c6acfb7fe2ca8852b4c3d8f43d9cdf8;hpb=ff657a4317312f9fc858e128affaf97aa46c336b;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/t/lib/DBICTest/Schema/Track.pm b/t/lib/DBICTest/Schema/Track.pm index 691974a..7a738a1 100644 --- a/t/lib/DBICTest/Schema/Track.pm +++ b/t/lib/DBICTest/Schema/Track.pm @@ -1,7 +1,8 @@ package # hide from PAUSE DBICTest::Schema::Track; -use base 'DBIx::Class::Core'; +use base qw/DBICTest::BaseResult/; +__PACKAGE__->load_components(qw/InflateColumn::DateTime Ordered/); __PACKAGE__->table('track'); __PACKAGE__->add_columns( @@ -13,17 +14,53 @@ __PACKAGE__->add_columns( data_type => 'integer', }, 'position' => { - data_type => 'integer', + data_type => 'int', accessor => 'pos', }, 'title' => { data_type => 'varchar', size => 100, }, + last_updated_on => { + data_type => 'datetime', + accessor => 'updated_date', + is_nullable => 1 + }, + last_updated_at => { + data_type => 'datetime', + is_nullable => 1 + }, ); __PACKAGE__->set_primary_key('trackid'); -__PACKAGE__->belongs_to( cd => 'DBICTest::Schema::CD' ); -__PACKAGE__->belongs_to( disc => 'DBICTest::Schema::CD' => 'cd'); +__PACKAGE__->add_unique_constraint([ qw/cd position/ ]); +__PACKAGE__->add_unique_constraint([ qw/cd title/ ]); + +__PACKAGE__->position_column ('position'); +__PACKAGE__->grouping_column ('cd'); + + +__PACKAGE__->belongs_to( cd => 'DBICTest::Schema::CD', undef, { + proxy => { cd_title => 'title' }, +}); +__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' ); + +__PACKAGE__->belongs_to( + "year1999cd", + "DBICTest::Schema::Year1999CDs", + { "foreign.cdid" => "self.cd" }, + { join_type => 'left' }, # the relationship is of course optional +); +__PACKAGE__->belongs_to( + "year2000cd", + "DBICTest::Schema::Year2000CDs", + { "foreign.cdid" => "self.cd" }, + { join_type => 'left' }, +); 1;