Hi all,
I would like to use the DCOP feature "query" from whitin scripts to access songs in the collection via SQL.

But I don't find any hint about the datamodel...  Could somebody give me a ER-model or textual description of the data-model inside amaroK 1.4.4

Thanks a lot
  Achim

Easiest way would be to just to dump the structure of your database.
For postgresql you can do that with pg_dump like this:

Code: Select all

pgdump -U USER -W --schema-only DBNAME


mysqldump works kinda similar and for sqlite you can just open the file with "sqlite" and use the ".dump" command. The information you get should be sufficient to do what you wanna do (the schema is not complex anyways).

You could try schemaspy

This helps reverse engineer databases.
[url=http://schemaspy.sourceforge.net/]http://schemaspy.sourceforge.net/
[/url]
Phil