ZDatabaseTool first code release
This is the first ZDatabaseTool source code release.
Two new Zope objects are provided.
ZDatabaseDiagram shows the structure and relations between tables of your database based on referential integrity definitions. So you get a quick view over tables views and column definitions.
A ZDatabaseExplore shows all entities of your database.
Features:
- supports ZPyGreSQLDA and ZPoPyDA
- show available databases
- show database owners and users
- show all database tables
- show all database views
- show all columns of a table
- show column type length default values modifiers ...
- show index definitions
- show rule definitions
- show constraint definitions
- show trigger definitions
- show reference integrity definitions
- perform more powerful test queries then ZSQLMethod (no SQL skills needed)
The Query Wizards you can see at the online demo are NOT included but it is on the TODO list for this week :-)
Get it at Easyleading.org