[Zope] ANN: P SQL Input Wizard 1.0.1

[Tom Deprez]

I'm not a wizard at Zope and Python (although I hope, one they I can help
people with it). But what about extending this wizard to the database of Zope?
Is it possible?

A suggestion: why not creating an interface so people can easely create an
object-oriented database into Zope? At this moment, it is only possible
with a knowledge of Python. Maybe a sort of Create Wizard and Input Wizard
for Zope's OO will be a great benefit... just a thought. 
I'm thinking this, because at the moment, I would use relational databases,
because of its ease in using it...

Tom.


At 23:20 26/04/99 -0300, you wrote:
>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
>
>_______________________________________________
>Zope maillist  -  Zope@zope.org
>http://www.zope.org/mailman/listinfo/zope
>
>(For developer-specific issues, use the companion list,
>zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )
>