[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    extragear/multimedia/amarok/src
From:       Maximilian Kossick <maximilian.kossick () googlemail ! com>
Date:       2006-07-29 8:26:19
Message-ID: 1154161579.789288.7985.nullmailer () svn ! kde ! org
[Download RAW message or body]

SVN commit 567534 by mkossick:

fixed problem where embedded images where not correctly deleted from the database \
during  incremental scanning

 M  +5 -4      collectiondb.cpp  


--- trunk/extragear/multimedia/amarok/src/collectiondb.cpp #567533:567534
@@ -1522,10 +1522,11 @@
     //TODO refactor
     // do it the hard way, since a delete subquery wont work on MySQL
     QStringList orphaned = query( "SELECT embed.deviceid, embed.url FROM embed LEFT \
JOIN tags ON embed.url = tags.url AND embed.deviceid = tags.deviceid WHERE tags.url \
                IS NULL;" );
-    foreachType( QStringList, orphaned ) {
-        query( QString( "DELETE FROM embed WHERE embed.url = '%2' AND embed.deviceid \
                = %1;" )
-                .arg( (*it).toInt() )
-                .arg( escapeString( *++it ) ) );
+    foreach( orphaned ) {
+        QString deviceid = *it;
+        QString rpath = *(++it);
+        query( QString( "DELETE FROM embed WHERE embed.deviceid = %1 AND embed.url = \
'%2';" ) +                .arg( deviceid, escapeString( rpath ) ) );
     }
 }
 


[prev in list] [next in list] [prev in thread] [next in thread]