Adding track in to library when it has been added to favorites

[someplayer] / src / dbstorage.cpp

diff --git a/src/dbstorage.cpp b/src/dbstorage.cpp
index b6e26bd..03755dd 100644 (file)
--- a/src/dbstorage.cpp
+++ b/src/dbstorage.cpp
@@ -88,9 +88,7 @@ void DbStorage::_prepare_queries() {
        _get_tracks_by_pattern_query = new QSqlQuery(db);
        _get_tracks_by_pattern_query->prepare("SELECT id, title, artist, album, source, count, length, year FROM "
                                              "entire WHERE "
-                                             "utitle LIKE (SELECT '%' || :ptitle || '%') OR "
-                                             "album_uname LIKE (SELECT '%' || :palbum || '%') OR "
-                                             "artist_uname LIKE (SELECT '%' || :partist || '%') "
+                                             "utitle LIKE (SELECT '%' || :ptitle || '%') "
                                              "ORDER BY artist_uname, year");
 
        _get_track_id_by_source_query = new QSqlQuery(db);
@@ -120,6 +118,9 @@ void DbStorage::_prepare_queries() {
        _check_directory_query = new QSqlQuery(db);
        _check_directory_query->prepare("SELECT id from directories WHERE path = :path");
 
+       _check_favorite_query = new QSqlQuery(db);
+       _check_favorite_query->prepare("SELECT 'yes' from favorites WHERE track_id in (SELECT id from tracks WHERE source = :source)");
+
        _insert_artist_query = new QSqlQuery(db);
        _insert_artist_query->prepare("INSERT INTO artist (name, uname) values (:name, :uname)");
 
@@ -163,6 +164,9 @@ void DbStorage::_prepare_queries() {
 
        _remove_directory_query = new QSqlQuery(db);
        _remove_directory_query->prepare("DELETE FROM directories WHERE path = :path");
+
+       _remove_track_from_favorites_query = new QSqlQuery(db);
+       _remove_track_from_favorites_query->prepare("DELETE FROM favorites WHERE track_id in (SELECT id FROM tracks WHERE source = :source)");
 }
 
 void DbStorage::_create_database_structure() {
@@ -245,6 +249,7 @@ DbStorage::~DbStorage() {
        delete _remove_track_query;
        delete _remove_directory_query;
        delete _remove_tracks_from_query;
+       delete _remove_track_from_favorites_query;
        db.close();
 }
 
@@ -456,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) {
@@ -541,12 +549,10 @@ int DbStorage::_check_add_album(QString album, int artist_id, int year) {
        }
 }
 
-QList<Track> DbStorage::search(QString pattern) {
+QList<Track> DbStorage::searchTracks(QString pattern) {
        QList <Track> found;
        QSqlQuery *query = _get_tracks_by_pattern_query;
        query->bindValue(":ptitle", pattern.toUpper()); // with :pattern only doesn't work
-       query->bindValue(":palbum", pattern.toUpper());
-       query->bindValue(":partist", pattern.toUpper());
        query->exec();
        // id, title, artist, album, source, count, length, year
        while (query->next()) {
@@ -657,3 +663,20 @@ void DbStorage::checkTracksFrom(QString path) {
                _cleanup();
        }
 }
+
+void DbStorage::removeFromFavorites(Track track) {
+       QSqlQuery *query = _remove_track_from_favorites_query;
+       query->bindValue(":source", track.source());
+       query->exec();
+}
+
+bool DbStorage::isFavorite(Track track) {
+       QSqlQuery *query = _check_favorite_query;
+       query->bindValue(":source", track.source());
+       query->exec();
+       if (query->next()) {
+               QString ans = query->value(0).toString();
+               return ans == "yes";
+       }
+       return false;
+}