[Amarok] improved filtering in the collection browsers, no
maximilian.kossick at googlemail.com
Wed Dec 23 08:43:39 CET 2009
On Wed, Dec 23, 2009 at 1:22 AM, Jeff Mitchell <mitchell at kde.org> wrote:
> 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.
FK constraints would not help here anyway as we are deleting rows from
the child table.
More information about the Amarok-devel