# In order to make this as fast as possible, I'm going to avoid the generic DB::Item::Album class and create a custom class.
# That way we can join album and label in a single query, and avoid a lot of overhead.
#
package RPS::DB::Item::AlbumListData;

use strict;
use warnings;

use lib '/app/tools/common/lib';
use lib '/app/tools/rps/lib';
use Common::Assert;

use base 'Common::DB::Item';

use constant kDB => Common::DB::Item::kClientDB();


# We'll return the same columns for both types of license reports.
# 
sub _config
{
    my ($class) = @_;

    return
    {
        'album_title'       => {},
        'artist_name'       => {},
        'label_id'        => {},
        'catalog_number'    => {},
        'status'            => {},
        'album_id'          => {},
    };
}


sub GetList
{
    my ($class, $label_id) = @_;

    my $sql = "SELECT album.title as album_title, album.album_id as album_id, album.catalog_number as catalog_number, artist.name as artist_name,"
    . "album.status as status, album.label_id as label_id"
    . " FROM album LEFT JOIN artist USING (artist_id)";

    if ($label_id)
    {
        $sql .= " WHERE album.label_id=".$class->quote($label_id);
    }

    $sql .= ' ORDER BY title,artist_id';

    return $class->GetAll($sql);
}



1;