You are not logged in Log in Join
You are here: Home » Members » Andreas Heckel » Zope Database Tool

Log in
Name

Password

 
 

Folder icon 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