Database conversion tool

[Jeff Mitchell]

Maximilian Kossick wrote:
> On Sat, Mar 29, 2008 at 1:33 PM, Seb Ruiz <ruiz at kde.org> wrote:
>> On 29/03/2008, Maximilian Kossick <mkossick at gmx.de> wrote:
>>  > On Saturday 29 March 2008, Maximilian Kossick wrote:
>>  >  > On Saturday 29 March 2008, Seb Ruiz wrote:
>>  >  > > Hi All,
>>  >  > > I'd like to get back in A2 development by writing a tool that will let
>>  >  > > users convert their Amarok 1.4 database into one which is readable by
>>  >  > > Amarok 2.
>>  >  > >
>>  >  > > This means extracting from sqlite/mysql/pgsql and inserting it into
>>  >  > > the sqlite (or other, if we decide) of Amarok 2.
>>  >  > >
>>  >  > > Is there any documentation on the schema of the A2 database, aside
>>  >  > > from viewing the database or source code directly?
>>  >  >
>>  >  > Unfortunately not as far as I know. I think somebody generated a diagram of
>>  >  > either the A1 or A2 database once, and sent it to one of our lists. That's
>>  >  > not proper documentation, but at least you would not have to figure out the
>>  >  > schema by reading the source code.
>>
>>  Hm, I'd rather have direct access to the database and read it from
>>  there, than use the A2 source-code.
>>
>>
>>  > How about simply copying the statistics table from A1 into the A2 database?
>>  >  That table did not change all that much. A2 could fill the other tables by
>>  >  simply scanning the collection. It might be a good idea to run some sanity
>>  >  checks on the rows of A1's statistics table. There's probably some stuff in
>>  >  there which does not belong in the A2 SqlCollection statistics table, because
>>  >  that one only handles statistics for files in the local collection.
>>
>>  Yes, perhaps this will work more reliably than having to bother with
>>  dynamic collections and all that database mess.
>>
> Should I try and enable Dynamic Collection for A2? I have no idea if
> it's possible to make it work on Windows. Jeff, is it possible to get
> uuids for volumes in win32 with solid? do they stay the same?

Not yet.  I got distracted from the Solid backend (which doesn't 
actually exist yet other than that the solid command-line utilities have 
been fixed) by Dolphin issues, trying to iron out some issues that are 
making it unusable on Windows.  Keep in mind that there's no Solid on OS 
X either.

However, once Solid is up and running on Windows it *should* be possible 
to get volume UUIDs that stay the same.  I can't imagine any OS doesn't 
have some identifier for them (and I think I know what they are in any 
case).

--Jeff