X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2FDBICTest%2FSchema%2FArtist.pm;h=be46d16c54f8e4e27df1ffc3055370bb7fcdd3f5;hb=494674a52f9976f723d838cdfa96ab9b394b1c6e;hp=87991885a25e009c70925f53196b4985d216bf29;hpb=6e399b4faae26e6661c8bd734a31e619c97b78b8;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/t/lib/DBICTest/Schema/Artist.pm b/t/lib/DBICTest/Schema/Artist.pm index 8799188..be46d16 100644 --- a/t/lib/DBICTest/Schema/Artist.pm +++ b/t/lib/DBICTest/Schema/Artist.pm @@ -1,7 +1,7 @@ package # hide from PAUSE DBICTest::Schema::Artist; -use base 'DBIx::Class::Core'; +use base qw/DBICTest::BaseResult/; __PACKAGE__->table('artist'); __PACKAGE__->source_info({ @@ -13,13 +13,20 @@ __PACKAGE__->add_columns( 'artistid' => { data_type => 'integer', is_auto_increment => 1, - bind_attributes => { testkey1 => 1}, }, 'name' => { data_type => 'varchar', size => 100, is_nullable => 1, - bind_attributes => {testkey2 =>2}, + }, + rank => { + data_type => 'integer', + default_value => 13, + }, + charfield => { + data_type => 'char', + size => 10, + is_nullable => 1, }, ); __PACKAGE__->set_primary_key('artistid'); @@ -33,6 +40,9 @@ __PACKAGE__->has_many( cds => 'DBICTest::Schema::CD', undef, { order_by => 'year' }, ); +__PACKAGE__->has_many( + cds_unordered => 'DBICTest::Schema::CD' +); __PACKAGE__->has_many( twokeys => 'DBICTest::Schema::TwoKeys' ); __PACKAGE__->has_many( onekeys => 'DBICTest::Schema::OneKey' ); @@ -43,4 +53,19 @@ __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) = @_; + + if ($sqlt_table->schema->translator->producer_type =~ /SQLite$/ ) { + $sqlt_table->add_index( name => 'artist_name_hookidx', fields => ['name'] ) + or die $sqlt_table->error; + } +} + 1;