Zope Database Tool

This folder has no visible items. To add content, press the 'Add New Item' button, or paste content from another location.

ZDatabaseTool takes advantage of the amazing features of Zope. It extends it's built-in objects so you can manage databases more comfortable. At the moment only PostgreSQL RDBMS is supported. The code is not yet released I want you to have a look at it.

Database administration

show database connection settings
show available databases
show database owners
show database users
show database diagram
show tables with it's owner, indexes, rules, triggers and constraints
show fields with it's type, lenght, modifier and references
show database views with it's owner and definition
do test queries (no SQL skills needed)

Database Query Wizard

create komplex database queries (no SQL skills needed)
object methods for query input forms, query results (HTML and PDF), single records, insert update and delete records
multi language support
much more ... see screen shots and online demo

Requirements

Zope 2.1.6+
ZPyGreSQLDA or ZPoPyDA
PostgreSQL 7+
ReportLab suggested for PDF database reports
Python Imaging Library (PIL) suggested for full PDF imaging functionality
Browser (NS,IE JavaScript enabled)

There is a 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