sqlite db doesn't work

[GoogleCodeExporter]

Using an sqlite db instead of the mysql setting for storing stuff doesn't seem 
to work and gives errors on my end. I went ahead and messed around with the 
code a little, got it working (for me at least).
Here are the exact changes I did to get it working: 
https://gist.github.com/larrybolt/84c7531352a1772b5220/revisions (see top 
revision)

In short, {{{utils.getSetting("db_format") == 0}}} seems never to return true, 
and sqlite doesn't support UNIX_TIMESTAMP, but {{{strftime('%s', ...)}}} works.

Not perfect, I write very very very little python, but it works for me! Awesome 
addon btw, thanks!

Original issue reported on code.google.com by Larry.B...@gmail.com on 9 Dec 2014 at 11:45

[GoogleCodeExporter]

Okay it seems I cannot edit what I submitted 10 seconds ago, dumb me, just 
extra info, this is running on bleeding edge Kodi (14.0-RC3 compiled Dec 8th 
2014) on mac, and same results on Kodi (14.0-RC1 Git:ffad6b8). Platform: Linux 
ARM 32-bit OpenELEC (official) - Version: 4.97.1 5.0 on a Raspberry Pi revB

Original comment by Larry.B...@gmail.com on 9 Dec 2014 at 11:51

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Sorry for the late reply. I fixed the problem with version 1.0.2, which you can 
find in the testing branch.
To make the changes work, you have to reset your addon settings.
I think the part with UNIX_TIMESTAMP is not a problem to the addon as I 
understand it.

Original comment by msahad...@gmail.com on 11 Jan 2015 at 6:22

• Changed state: Fixed
• Added labels: ****
• Removed labels: ****