[Amarok] improved filtering in the collection browsers, no

[Jeff Mitchell]

On 12/22/2009 5:13 PM, Casey Link wrote:
>> Both the view and querymaker work correctly from what I can see. What
>> is not working correctly is that SqlCollectionLocation::remove() a)
>> removes the wrong row from the tracks table(it should be WHERE url =
>> %1 instead of WHERE id = %1 ... again) and b) does not clear all the
>> other tables (e.g. artists, albums, ...) when necessary.
> 
> Thanks for the quick response!
> 
> Just to be clear the query should be:
> "DELETE FROM tracks where url = %1;"   where %1 is the id?
> 
> Also, aren't there foreign key constraints to remove artists/albums
> when tracks are deleted?

I'm pretty sure there are no FK constraints in all of Amarok.

--Jeff

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 196 bytes
Desc: OpenPGP digital signature
Url : http://mail.kde.org/pipermail/amarok-devel/attachments/20091222/bf3b046f/attachment.sig