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 )