I started messing around with the code to see if I can get a stand-alone version working that connects to the myqsl database instead of using the sqllite stuff - it's been a while since I've done any programming and I've never used python before so it's somewhat slow going!
I was hoping that I could just swap the sqllite apis for mysql ones and everything else would just work but it seems that the database schema's are not the same so I have more to do. I'll try to keep chipping away at it in spare moments (or until someone more competent steps in).
So far I have a Python connecting to the database but get the below error:
Traceback (most recent call last):
File "imdb.py", line 85, in <module>
c.execute('SELECT c09, c00, idMovie FROM movie WHERE idMovie > ?',(lastid,))
File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 151, in execute
query = query % db.literal(args)
TypeError: not all arguments converted during string formatting
So looks like I will need to work on the database stuff a bit