NAME

Music::DB::Query - query methods of a Music::DB database

SYNOPSIS

Music::DB::Query objects are used internally by Music::DB::Reports and Music::DB::Web. You will not normally interact with Music::DB::Query objects. The documentation contained here is listed for completeness as well as for those looking to extend the functionality of Music::DB.

METHODS

$report->fetch_class(@options);

Provided with a table name, fetch_class returns an array reference of appropriate objects. For example, passing the -class=>'artists' option results in an array reference of Music::DB::DataTypes::Artist objects.

 Options:

Some classes accept additional parameters.

 Class: albums

 TODO: COMPLETE
   By default, album objects will not be populated with songs. To retreive populated Album objects, try using ...

   If provided, Album objects will be populated with Song
   objects. These can be accessed by calling the songs() method on
   each album object.

   @albums = $music->fetch_class(-class=>'artist');
   foreach my $album_obj (@albums) {
     print $album_obj->album,"\n";
     print join("\n",map {$_->title} $album_obj->songs);
   }

   If not provided, summaries that require touching each song (ie to
   see if it is a compilation album) will still be created, but the
   individual songs will not be returned.  This can be useful ina
   situation requiring greater speed and less memory consumption.

count()

 Usage: count('type');

     Where type is one of artists, albums, songs, genres
 Status: internal

Generate a simple count of the number of $type entries in the database