git clone https://@opensourceprojects.eu/git/p/sqlscreens/code sqlscreens-code
Read Me
Sqlscreens: TCL/TK code to generate database screens
Author: Jean-Francois Dockes <jf@dockes.org> (CDKIT, SAINT CLOUD, FRANCE, Circa 1996).
This is very old (close to 20 years), but can still be useful. See the doc here:
http://lesbonscomptes.com/sqlscreens/
PLEASE read the installation section in doc/sqlscreens.txt or
doc/sqlscreens.html. Especially if you get messages about undefined
symbols during compilation.
For the very hurried (but this might not work the first time):
./configure
make
make install
SQLSCHOST=yourhost SQLSCUSER=you SQLSCPASSWORD=yourpass \
samples/tablescreen.tcl yourdb yourtable
Note: setting the password in the environment is NOT required by
sqlscreens. It is just done this way in the sample scripts.
- In some cases, the version that loads the extension modules
dynamically may not work (with problems like the install failing
because of undefined symbols like__umoddi3 or with other
miscellaneous error messages). You can use mysqlwish (static link)
to test, and there are explanations in the documentation to get the
dynamic version to work (and see README-DYNAMIC).
There are sample applications in the "samples" directory. You can copy
them in another place
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 (You may first need to change the top of the script to add the
suitable -h, -u, etc... options):
cd samples
sh createloadwines.sh
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 5 tables in the wines db.
- "wines" lists the wines,
- "producers" lists who made them,
- "providers" lists where you bought them,
- "origins" lists the official wine denominations
- tastings is for your tasting comments
"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 5 subscreens. The subscreens are linked so that
querying or inserting in "providers", "producers", "origins" or
tastings will set the corresponding join column in "wines".
Because this is TCL, it would be easy to add more code, for example to
generate lists, statistics, etc... The goal was not to make a complete
application.
dockes
Jean-Francois Dockes