2011-01-24, 21:37
@castortray
Can't really help you that much other then to try to point you in the right direction, I don't know how much python you know but if you know a little programming it shouldn't be that hard.
Maybe you can have a look at some other addons for xbmc that handles mysql databases and see how they do it.
But the things in the default.py file you probably are interested in are these...
If you figure out the equivalent ones for mysql then I think you should be done.
Can't really help you that much other then to try to point you in the right direction, I don't know how much python you know but if you know a little programming it shouldn't be that hard.
Maybe you can have a look at some other addons for xbmc that handles mysql databases and see how they do it.
But the things in the default.py file you probably are interested in are these...
Code:
#this one enables connections to sqlite
from pysqlite2 import dbapi2 as sqlite
#this is the path to the file (db-server in the mysql case)
videoDB = xbmc.translatePath("special://profile/Database/MyVideos34.db")
#this creates the actual connection
dbCon = sqlite.connect(videoDB)If you figure out the equivalent ones for mysql then I think you should be done.
