"(SELECT tracks.id AS track_id, artist.name AS artist, title, count, source, tracks.album_id, length FROM "
"tracks JOIN artist ON tracks.artist_id = artist.id) "
"JOIN album ON album_id = album.id "
- "WHERE count = 0");
+ "WHERE count = 0 LIMIT 0, :max");
_get_recently_added_query = new QSqlQuery(db);
_get_recently_added_query->prepare("SELECT track_id as id, title, artist, album.name as album, source, count, length FROM "
QSqlQuery *query = _get_track_id_by_source_query;
query->bindValue(":source", track.source());
query->exec();
- if (query->next()) {
- int id = query->value(0).toInt();
- query = _insert_favorites_query;
- query->bindValue(":track_id", id);
+ if (!query->next()) {
+ addTrack(track);
query->exec();
+ query->next();
}
+ int id = query->value(0).toInt();
+ query = _insert_favorites_query;
+ query->bindValue(":track_id", id);
+ query->exec();
}
void DbStorage::updateTrackCount(Track track) {