git clone https://@opensourceprojects.eu/git/p/sqlscreens/code sqlscreens-code
Read Me
sqlscreens: TCL/TK code to generate database screens
See the installation section in doc/sqlscreens.ascii or
doc/sqlscreens.html
For the very hurried (but this might not work the first time, this is
the first version with autoconf):
./configure
make
make install
- If you're using solaris, the dynamic load version will not work (the
install will fail because of undefined symbols like__umoddi3) . You
can use mysqlwish (static link) to test, there are explanations in the
documentation to get the dynamic version to work.
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 should first create the database and 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 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