#------------------------------------------------------------
# Copyright (C) 2006 RoyaltyShare, Inc.   All Rights Reserved
#------------------------------------------------------------
package RPS::DB::Item::ArtistRole;
use strict;
use warnings;

use lib '/app/tools/rps/lib';

use lib '/app/tools/common/lib';
use Common::DB::Item;
use Common::RSApp;
use base 'Common::DB::Item';

use constant kTable => 'artist_role';
use constant kDB    => Common::DB::Item::kCommonDB();

sub LookupWithMap {
    my $class = shift;
    my %args  = @_;

    my $name      = $args{service_role};
    my $serviceID = $args{service_id};

    my $dbo = Common::RSApp::GetCommonDB();
    my $sql =
        "SELECT artist_role.*, service_role, service_id " . "FROM "
      . kTable . " "
      . " LEFT JOIN artist_role_service_map "
      . " ON ( artist_role.artist_role_id = artist_role_service_map.artist_role_id AND "
      . "service_id = "
      . $dbo->DBQuote($serviceID) . " ) "
      . "WHERE artist_role.role = "
      . $dbo->DBQuote($name);

    Common::Log::Debug("QUERY: $sql");
    my $list = $class->SUPER::GetAll($sql);

    return $list->hasNext ? $list->next : undef;
}

1;