Audio-DB
view release on metacpan or search on metacpan
DB/Reports.pm view on Meta::CPAN
artists are contained on the album, the placeholder "Various Artists"
or "Various Years" will be used as the search key.
In the interests of memory consumption, the album_list() method
returns only the album name, artist, year, and bitrates for each album
by default. If you also need access to the song list for each
individual album, pass a true value with the -include_songs option.
=cut
# The internal data strcuture for album reports looks like this
#
# $self = [ {
# album => album name,
# album_id => album id,
# artists => [ all contributing artists ],
# songs => [ all contributing songs ],
# bitrates => [ bitrates seen for the album ],
# years => [ years seen for the album ],
# Also included in the hash ref but not necessarily accurate because of compilation CDs
# year => year released
DB/Util/SystemConfig.pm view on Meta::CPAN
my @vals;
foreach (@fields) {
push (@vals,$_ . "=" . $dbh->quote($params->{$_}[$count]));
}
$result = $dbh->do("update users set "
. join(",",@vals)
. " where user_id=$id");
$count++;
}
# This is kind of bogus - only looks at the last record updated.
if ($result) {
print div({-class=>'success'},"The users have been succesfully updated.");
} else {
$self->print_sql_error($dbh->errstr);
}
}
sub user_summary {
my $self = shift;
( run in 0.799 second using v1.01-cache-2.11-cpan-607d282f910 )