Database conversion tool

Seb Ruiz ruiz at kde.org
Sat Mar 29 13:33:11 CET 2008


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.


-- 
Seb Ruiz

http://www.sebruiz.net/


More information about the Amarok-devel mailing list