view release on metacpan or  search on metacpan

t/lib/MyApp/Schema/Result/Artist.pm  view on Meta::CPAN

package MyApp::Schema::Result::Artist;

use warnings;
use strict;

use base qw( DBIx::Class::Core );

__PACKAGE__->load_components(qw/ Events /);

__PACKAGE__->table('artist');

__PACKAGE__->add_columns(
  artistid => {
    data_type => 'integer',
    is_auto_increment => 1
  },
  name => {
    data_type => 'text',
  },
);

__PACKAGE__->set_primary_key('artistid');

__PACKAGE__->add_unique_constraint([qw( name )]);

__PACKAGE__->has_many('cds' => 'MyApp::Schema::Result::Cd', 'artistid');

__PACKAGE__->has_many(
    'events' => ( 'MyApp::Schema::Result::ArtistEvent', 'artistid' ),
    { cascade_delete => 0 },
);

__PACKAGE__->add_column(
    previousid => { data_type => 'integer' } );

__PACKAGE__->has_one(
    'previously' => 'MyApp::Schema::Result::Artist',
    { 'foreign.artistid' => 'self.previousid' },
    { cascade_delete     => 0 },
);

__PACKAGE__->add_column(
    last_name_change_id => { data_type => 'integer' } );

__PACKAGE__->has_one(
    'last_name_change'        => 'MyApp::Schema::Result::ArtistEvent',
    { 'foreign.artisteventid' => 'self.last_name_change_id' },
    { cascade_delete          => 0 },
);

sub change_name {
    my ( $self, $new_name ) = @_;

    my $event = $self->event( name_change =>
            { details => { new => $new_name, old => $self->name } } );
    $self->last_name_change( $event );

    $self->name( $new_name );
}

1;