X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2FDBICTest%2FSchema%2FTrack.pm;h=496680035532f40105187337b8901f84ec895ed8;hb=0e533cb1b88cd52f4e7ed900a7b6d40cbb1117fa;hp=97cb6f4e989ca1d499cd571b34a5c97ba316b7c8;hpb=11b78bd6f6d77f58d9c5ae301e94ca57e892f592;p=dbsrgits%2FDBIx-Class.git diff --git a/t/lib/DBICTest/Schema/Track.pm b/t/lib/DBICTest/Schema/Track.pm index 97cb6f4..4966800 100644 --- a/t/lib/DBICTest/Schema/Track.pm +++ b/t/lib/DBICTest/Schema/Track.pm @@ -1,13 +1,49 @@ -package DBICTest::Schema::Track; +package # hide from PAUSE + DBICTest::Schema::Track; -use base 'DBIx::Class::Core'; +use base qw/DBICTest::BaseResult/; +__PACKAGE__->load_components(qw/InflateColumn::DateTime Ordered/); -DBICTest::Schema::Track->table('track'); -DBICTest::Schema::Track->add_columns(qw/trackid cd position title/); -DBICTest::Schema::Track->set_primary_key('trackid'); -DBICTest::Schema::Track->add_relationship( - cd => 'DBICTest::Schema::CD', - { 'foreign.cdid' => 'self.cd' } +__PACKAGE__->table('track'); +__PACKAGE__->add_columns( + 'trackid' => { + data_type => 'integer', + is_auto_increment => 1, + }, + 'cd' => { + data_type => 'integer', + }, + 'position' => { + data_type => 'integer', + 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__->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' ); +__PACKAGE__->belongs_to( disc => 'DBICTest::Schema::CD' => 'cd'); + +__PACKAGE__->might_have( cd_single => 'DBICTest::Schema::CD', 'single_track' ); +__PACKAGE__->might_have( lyrics => 'DBICTest::Schema::Lyrics', 'track_id' ); 1;