[defunkt]

Hi, have long wondered if it's possible to execute SQL statements on the database from with a python addon? If it is a link to an example would be appreciated.

What I'm hoping to do with it right now is batch revise zoom and pixel ratio for a whole class of library item (Music Videos).

I had thought JSON RPC would be the avenue but I see no way to amend these properties through the published methods.

If it's not possible to execute SQL from a python script is there any way to setup RPC access to the built-in SQLite database?

Thank you.

[Roman_V_M]

http://lmgtfy.com/?q=python+sqlite

However, direct access to Kodi database is strongly discouraged and such addons are not admitted to the official repo.