X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2FDBICTest%2FSchema%2FArtist.pm;h=a5425765d1147da41989ed7ba44d515a2a6cb78d;hb=a085381e61284d46d374ada169f52ae6e35fc9bb;hp=37aa0b273437d4474af8513214241bf3480a2265;hpb=a02675cd9a11e1f354220319da9f5d573a2e484a;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/t/lib/DBICTest/Schema/Artist.pm b/t/lib/DBICTest/Schema/Artist.pm index 37aa0b2..a542576 100644 --- a/t/lib/DBICTest/Schema/Artist.pm +++ b/t/lib/DBICTest/Schema/Artist.pm @@ -1,22 +1,61 @@ -package DBICTest::Artist; +package # hide from PAUSE + DBICTest::Schema::Artist; use base 'DBIx::Class::Core'; -DBICTest::Artist->table('artist'); -DBICTest::Artist->add_columns(qw/artistid name/); -DBICTest::Artist->set_primary_key('artistid'); -DBICTest::Artist->add_relationship( - cds => 'DBICTest::CD', - { 'foreign.artist' => 'self.artistid' }, - { order_by => 'year' } +__PACKAGE__->table('artist'); +__PACKAGE__->source_info({ + "source_info_key_A" => "source_info_value_A", + "source_info_key_B" => "source_info_value_B", + "source_info_key_C" => "source_info_value_C", +}); +__PACKAGE__->add_columns( + 'artistid' => { + data_type => 'integer', + is_auto_increment => 1, + }, + 'name' => { + data_type => 'varchar', + size => 100, + is_nullable => 1, + }, + rank => { + data_type => 'integer', + default_value => 13, + }, ); -DBICTest::Artist->add_relationship( - twokeys => 'DBICTest::TwoKeys', - { 'foreign.artist' => 'self.artistid' } +__PACKAGE__->set_primary_key('artistid'); + +__PACKAGE__->mk_classdata('field_name_for', { + artistid => 'primary key', + name => 'artist name', +}); + +__PACKAGE__->has_many( + cds => 'DBICTest::Schema::CD', undef, + { order_by => 'year' }, ); -DBICTest::Artist->add_relationship( - onekeys => 'DBICTest::OneKey', - { 'foreign.artist' => 'self.artistid' } +__PACKAGE__->has_many( + cds_unordered => 'DBICTest::Schema::CD' +); + +__PACKAGE__->has_many( twokeys => 'DBICTest::Schema::TwoKeys' ); +__PACKAGE__->has_many( onekeys => 'DBICTest::Schema::OneKey' ); + +__PACKAGE__->has_many( + artist_undirected_maps => 'DBICTest::Schema::ArtistUndirectedMap', + [ {'foreign.id1' => 'self.artistid'}, {'foreign.id2' => 'self.artistid'} ], + { cascade_copy => 0 } # this would *so* not make sense ); +sub sqlt_deploy_hook { + my ($self, $sqlt_table) = @_; + + + if ($sqlt_table->schema->translator->producer_type =~ /SQLite$/ ) { + $sqlt_table->add_index( name => 'artist_name', fields => ['name'] ) + or die $sqlt_table->error; + } +} + 1;