[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Bug-gnubg] python/db issues + minor comment
From: |
Christian Anthon |
Subject: |
Re: [Bug-gnubg] python/db issues + minor comment |
Date: |
Wed, 29 Mar 2006 08:41:29 +0200 |
User-agent: |
Mutt/1.5.10i |
On Wed, Mar 29, 2006 at 09:15:23AM +0200, address@hidden wrote:
> I tried my python-enabled distribs with respect to sql db interface and
> almost everything works fine. I installed SQLite and its python module
> (as explained by Jon). Just a few details :
>
>
> 1) I had to edit the file "database" in order to set "gnubg*type sqlite"
> (and comment out postgres-only stuff). Also, set "gnubg*database gnubg.db"
> (.db extension is recognized by SQLiteAnalyzer and make it clear what the
> file contains).
>
Could you post the output of
cvs.exe diff python/database.py
to make it clearer what you needed to change. You probably need to open
a command prompt to do so and update your path to include
c:\gnu\mingw\bin
>
> 2) I added a couple of analyzed .sgf file to the database using
> command-line gnubg and everything went ok : I can run queries
> like "select * from nick;" and I see the expected result (I
> also tried to run queries via an external tool, SQLiteAnalyzer,
> and it works fine). I can also run queries via gnubg gui, but the
> thing I cannot do is to add a match to the db via gnubg gui :
> it does nothing (no confirmation message in the "status bar" in the
> bottom of the window) ... something must be failing ...
>
>
> 3) If I set "gnubg*games yes", then :
The game database works on postgres/linux. You should probably remove the
entire db before creating the match+game db. Could you please update to
latest cvs before doing so, as there is a bug in the .sql files.
If you can make the windows version work with games, I think it makes
sense to remove the non-games version and update database.py
accordingly.
Christian.