[Bug-gnubg] Gnubg and sqlite

[Jim Segrave]

I;ve been trying to help out someone in getting sqlite set up with
gnubg. Since I don't have Windows myself, it's kind of hard to be too
useful.

Here was my original advice and the results - gathered by googling for
Python, db2api and sqlite:

> 1. dl & inst. the last gnubg setup
> 2. dl & inst. sqlite-2_8_15.zip
> 3. dl & inst. Python 234 for windows
> 4. dl & inst. pysqlite-2.0.3.win32-py2.3.exe

change database.py to have:

DB_TYPE = DB_SQLITE

and
    if DB_TYPE == DB_SQLITE:
            DBFILE = "data.db"
            import sqlite
changed to
    if DB_TYPE == DB_SQLITE:
            DBFILE = "data.db"
            from pysqlite2 import dbapi2 as sqlite

In a DOS window run the command:

C:\gnubg> sqlite data.db < gnubg.sql

After doing this, the report is that the relational database test runs
successfully, but that when he attempts to add a match to the database
nothing appears to happen and, as far as he can tell, no data has been
actually added to the database (data.db hasn't changed size). When he
closes gnubg he gets a popyp with an message something like 'error
query'

Is anyone using gnubg and sqlite under windows?  Any advice for him?
He reads the mailing list but felt reluctant to query any further
since he realises how much work the Windows developers are already
doing. 

-- 
Jim Segrave           address@hidden