Database conversion tool

[Maximilian Kossick]

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?