File	Date	Author	Commit
doc	1997-07-31	dockes	[0242a8] .
samples	1997-06-25	dockes	[cbfe9c] The real 0.2
CHANGES	1997-10-23	dockes	[806c5d] ->0.3
LICENSE	1997-04-25	dockes	[88f404] 1st version
Makefile	1997-05-15	dockes	[24a3fc] typo in mysqlwish link
README	1997-05-21	dockes	[0dbce6] 0.2
VERSION	1997-10-23	dockes	[806c5d] ->0.3
excludefile	1997-07-29	dockes	[63f855] use sun's tar : the exclude file does not work ...
makedist.sh	1997-07-29	dockes	[d213db] typo
mysqltcl.c	1997-10-21	dockes	[cb7d00] only declare extern gethostname on suns. Others...
sqlscreens.tcl	1997-10-23	dockes	[89237e] Improve statement logging. Allow logging to a f...
tcsq.tcl	1997-10-27	dockes	[1fcfe2] Would endlessly loop if the cduniqueid service ...
tkAppInit.c	1997-04-25	dockes	[e1a6fd] 1st version

Read Me

sqlscreens: TCL/TK code to generate database screens

See the installation section in doc/sqlscreens.ascii or
doc/sqlscreens.html

The sample applications wines.tcl and tablescreen.tcl are set up to
run from the "samples" directory (because they expect to find the
library code in "..", you can change this).

See samples/tablescreen.tcl for a minimal example application:
==============================================================
 This is the very minimum possible program, it just generates a
default screen for the table you point it to.

See samples/wines.tcl for a more complete application:
======================================================
 This is a small app to manage a wine cellar. It's not supposed to be
a good wine-cellar managing application, just an exemple of what you
can easily do with sqlscreens, and I happened to have the data
available.

If you want to try this, you should create the tables and load the
data first. 
 wines.tcl will try to connect to the "test" database. You should load
the data from samples/winesload.sql by doing:
    cd samples
    mysql test < winesload.sql

 You can then start wines.tcl. It has two possible options: -query or
-input, which start slightly different screens for querying the
database or adding data into it.
 
There are 4 tables in the wines db. "wines" lists the wines,
"producers" lists who made them, "providers" lists where you bought
them, and "origins" lists the official wine denominations.

"origins" would normally be a closed list, created once and very
seldom updated, here it is far from complete and limited to the wines
that are actually there. Still, it is handled as not updateable (that
is, you would use another application, maybe tablescreen, to update
it). 

The application has 4 subscreens. The subscreens are linked so that
querying or inserting in "providers", "producers" or "origins" will
set the corresponding join column in "wines".

Because this is TCL, it would be easy to add more code, for example to
handle tasting comments, generate lists, statistics, etc... The goal
was not to make a complete application.