|
Automating MySQL - Linux terminal program?
I have a bit of experience with MySQL and *nix, but have never attempted something like this before.
I have a MySQL database of information filled in from paper forms. It includes three fields: checked, needsSignature, needsChanges.
One of two administrators goes over the forms, sets checked=1 once the form is checked, and if it needs a signature or changes, sets the appropriate field to 1.
What I want is a simple command-line program that iterates through the rows in a table where checked=0, and one at a time shows some of the information and options to change the other two fields mentioned.
So, what I need, is a suggestion for a programming language to do this in. Specs are as follows:
1) Nothing too heavy-weight, this is a one-time thing, but I'm always willing to learn a new language.
2) Only needs to run on SuSE Linux, but needs to be non-graphical (will be running through an SSH session via PuTTY on a Win machine.)
3) I'd like something menu-based (like SuSE's YAST, a blue screen with menus scrolled through with Tab key, text input boxes, etc.).
4) I'd also like to be able to make use of the F keys in certain places to expediate some tasks.
Thanks.
|