[Zope] ANN: P SQL Input Wizard 1.0.1
Paulo Eduardo Neves
neves@inf.puc-rio.br
Mon, 26 Apr 1999 23:20:56 -0300
Since people asked for it, here is a new version of the input wizard.
You can download from the usual place:
http://www.zope.org/Download/Contrib/sqlinputwiz1.0.tar.gz
New Features (from WHAT's NEW):
1 - Thanks to Anthony Baxter <anthony@interlink.com.au> now the
Wizard supports Oracle and Sybase databases;
2 - You can make a column optional. If the column id isn't
acessible by the insert sql method, then it doesn't take part in
it. This way the row will have the database default value;
3 - If a string type can be null in the database then the sqlvar
type is nb, instead of string;
4 - A quit button in every page for leaving the wizard before
finishing. This way you won't leave garbage in the object
database.
Here a quick description from the README file:
P MySQL Input Wizard will help you to create database insert
interactions. Just select the tables and columns where you want to
insert data and the wizard will create:
1. A form where you can fill your data
2. A SQL method with the correct command
3. A result page that calls the SQL method
...
Advantages of using the wizard:
o You won't have to learn Zope syntax to insert data in your
DB:-)
o No need to remember all your database tables and columns
names
o No more typos when writing your database insert forms and
methods
o Have consistent naming in forms and SQL variables
o Waste your time building a usable interface, instead of
writing repetitive code and looking for DB info
The Wizard is reported to work with MySQL, Oracle 8.0.5 and Sysbase/MS
SQL Server 6.5. It's very easy to adapt to other DBs. To do it take a
look at comments in file DBInfo/InfoBase.py, and use the implemented
DBs as examples.
I welcome feedback.
regards,
--
Paulo Eduardo Neves
mailto:neves@inf.puc-rio.br
PUC-Rio de Janeiro