sqlite3 doesn't have a describe command. You have to use ".schema
table" from
the sqlite3 prompt.
Perhaps I'll add a little more help to the docs.
Here is how you might set up gnugo:
sqlite> insert into registry values( "gnugo_10",
...> "gnugo --mode gtp --score aftermath --capture-all-dead
--chinese-rules",
...> "GnuGo playing at level 10",
...> 2000.0 );
sqlite>
Here is the schema for everything:
sqlite> .schema
CREATE TABLE anchor(name, rating real);
CREATE TABLE gameid(gid int);
CREATE TABLE info( boardsize, komi );
CREATE TABLE moves(gid int, moves, primary key(gid));
CREATE TABLE registry( name, invoke, desc, rating real, primary
key(name) );
CREATE TABLE res(gid int, b, w, res);
CREATE TABLE sgf(gid int, gme, primary key(gid));
CREATE TABLE times(gid int, times, primary key(gid));
You also want to set up info like this:
insert into info values( 9, 7.5 );
... to set boardsize and komi.
And you can set up an anchor player too:
insert into anchor values( "gnugo_10", 2000.0 );
- Don
On Mon, 2007-06-25 at 21:57 +0200, Heikki Levanto wrote:
> On Mon, Jun 25, 2007 at 03:17:06PM -0400, Don Dailey wrote:
> > However I'm releasing my testing system to the public if anyone is
> > interested.
> > It may have some features in it that you will be interested in.
>
> Thanks. Looks promising.
>
> > It DOES require having sqlite3 and a little bit (but not much) sql
> > knowledge. You DO have to manually insert registry records into the
> > database to specify who the players are and how they should be invoked,
> > but no other sql knoweldge is required beyond this - a report is
> > furnished by the program or if you want you can manually query the
> > database to find out anything you want about the games.
>
> I have it running, but at the moment I have no idea how to specify my
> program for it. sqlite3 seems not to understand the describe command
> that I normally use to sort out the table layouts before inserting
> anything. Maybe you could add a one-line example to the README, on how
> to add a program (say GNU Go) as a player.
>
>
> Regards
>
> Heikki
>
_______________________________________________
computer-go mailing list
[email protected]
http://www.computer-go.org/mailman/listinfo/computer-go/
