- $db->prepare_cached('DELETE FROM songs WHERE generation <> ?')
- ->execute($db_generation);
- $db->prepare_cached('DELETE FROM albums WHERE generation <> ?')
- ->execute($db_generation);
- $db->prepare_cached('DELETE FROM artists WHERE generation <> ?')
- ->execute($db_generation);
+ my $sth =
+ $db->prepare_cached('DELETE FROM songs WHERE generation <> ?');
+ $sth->execute($db_generation);
+ $log->debug( sprintf( "Deleted %d stale songs", $sth->rows ) );
+
+ $sth = $db->prepare_cached('DELETE FROM albums WHERE generation <> ?');
+ $sth->execute($db_generation);
+ $log->debug( sprintf( "Deleted %d stale albums", $sth->rows ) );
+
+ $sth =
+ $db->prepare_cached('DELETE FROM artists WHERE generation <> ?');
+ $sth->execute($db_generation);
+ $log->debug( sprintf( "Deleted %d stale artists", $sth->rows ) );