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
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 )
Tom Deprez wrote:
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?
Unfortunately Zope 1.10.2 didn't have enough, IMO, abstractions for doing this without Python. Zope 1.11 adds two extremely important ideas for really unleashing the power of the database: Classes and Property Sheets. Classes let you create "your kinds of things" to store in the database, such as Expenses, Time Sheets, etc. Z Classes tap into the usual suspects needed for an object system, supporting things such as inheritance, class data, methods, constructors, etc. Property Sheets, part of Z Classes, allow you to organize the information about "your kinds of things" into logical sets. Our hope over time is to leverage this to let Zope be thought of as "storage of forms". That is, you just think of attaching forms to "your kinds of things" and Zope will handle the messy details. With some usability enhancements, including your wizard suggestion, I think Zope would have an extremely powerful story for storing things. The addition of something like XQL as a query language would be icing on the cake.
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...
Understood. This is definately an area the the community can keep chipping in to help, along the lines of these wizards from Paulo. --Paul
participants (3)
-
Paul Everitt -
Paulo Eduardo Neves -
Tom Deprez