[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