Strange .csv files from Amarok in my $HOME (Mark Kretschmann)

[Mark Kretschmann]

On Sun, Dec 5, 2010 at 7:36 PM, Ralf Engels <ralf-engels at gmx.de> wrote:
>
>> Message: 1
>> Date: Fri, 3 Dec 2010 12:31:09 +0100
>> From: Mark Kretschmann <kretschmann at kde.org>
>> Subject: Re: Strange .csv files from Amarok in my $HOME
>> To: amarok-devel <amarok-devel at kde.org>
>> Message-ID:
>>       <AANLkTinzPO9fMhd6pk3=CNNaqW8Uvdfq8r2xqO=s+Vp7 at mail.gmail.com>
>> Content-Type: text/plain; charset=ISO-8859-1
>>
>> On Fri, Dec 3, 2010 at 12:24 PM, Mark Kretschmann <kretschmann at kde.org> wrote:
>> > Hey all,
>> >
>> > I'm having a bizarre issue here that I can't wrap my head around:
>> >
>> > In my $HOME, there are hundreds of "*.csv" files, apparently from
>> > Amarok (see attached screenshot). What they contain is a bunch of tags
>> > and labels:
>> >
>> >
>> > mark at serenity:~$ cat composers-2010-10-20T15\:05\:47.csv
>> > id;name;
>> > 1;;
>> > 2;Bach;
>> > 3;Buxtehude, Dietrich;
>> > 4;Bic Runga;
>> > 5;Antony;
>> > 6;B. Zetlitz;
>> > 7;Jamie Catto/Maxi Jazz/Rollo/Sister Bliss;
>> > 8;Dido/Maxi Jazz/Rollo/Sister Bliss;
>> > 9;Maxi Jazz/Rollo/Sister Bliss;
>> > 10;Rollo/Sister Bliss;
>> > 11;Rollo/Sister Bliss/Zoe Johnston;
>> > 12;Sister Bliss;
>> > 13;Maxi Jazz/Rollo/Sister Bliss/Zoe Johnston;
>> > 14;Faithless/Maxi Jazz/Rollo/Sister Bliss;
>> > 15;Dido/Faithless/Maxi Jazz/Rollo/Sister Bliss;
>> >
>> >
>> > What on earth could generate these files? :)
>>
>> Just found this here:
>>
>> mark at serenity:~/kde/src/amarok$ ack-grep ".csv"
>> src/core-impl/collections/db/sql/SqlCollection.cpp
>> 493:            QDir::home().absoluteFilePath( table + '-' +
>> QDateTime::currentDateTime().toString( Qt::ISODate ) + ".csv" );
>>
>> --
>> Mark Kretschmann
>> Amarok Developer, Software Engineer at KO GmbH
>> Fellow of the Free Software Foundation Europe
>> http://amarok.kde.org - http://fsfe.org - http://kogmbh.com
>
>
> The .csv files are produced by the function dumpDatabaseContent and are
> the whole contents of the sql database.
> Very useful to debug which is why I have the function numerous time in
> the past to help me finding bugs.
>
> They should all be removed by now and a quick grep in our sources agree.
> You can delete those files without a second thought.

Thanks Ralf :)

-- 
Mark Kretschmann
Amarok Developer, Software Engineer at KO GmbH
Fellow of the Free Software Foundation Europe
http://amarok.kde.org - http://fsfe.org - http://kogmbh.com