Version bump
[someplayer] / src / dbstorage.cpp
index 71f1a36..171f2ae 100644 (file)
@@ -72,7 +72,7 @@ void DbStorage::_prepare_queries() {
                                                                "(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 "
@@ -461,12 +461,15 @@ void DbStorage::addToFavorites(Track track) {
        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) {