Hi Aaron, I have a written a product to do what you describe - unfortunately it isn't quite finished yet and is currently just designed to work with Postgres and Oracle. Called sqlizer - when added as a it gives you a an object that has a data dictionary interface with more details than the standard DCConnection browse and the ability to edit column comments. However the main features are that it has methods for edit tables that don't require sql specification. ie. sqlizer.table(self,table,REQUEST,action, args*) where table is the table to be acted upon and action= update or insert. args* is optional listing of fields if you don't want all form fields that are in the table updated (and obviously REQUEST could be subsitituted by any dictionary of data against fieldname keys). There is also a multiedit function which includes a foreign_key_name argument for bulk updates of related data. The inputs are all validated against what is allowable according to the data description of the tables fields. For simple db work it doesn't give you many advantages but when you are dealing with tables that often have more than thirty fields, and db schemas that are liable to changes (as they all are!) it is invaluable. Extra features that I will probably include (since I already have them as external methods) are date time drop down generator / input handler functions, basic ZPT web form generation from a tablename. I am afraid I cannot say when I may get this done but since I have one Postgres and one Oracle project that could do with this being implemented as a product, and both projects with deadlines of early summer. I would hope that I can at least move sqlizer to external CVS by then. Ed __________________________________________________________________ Ed Crewe ( Web Developer - ID Group ) ed.crewe@bris.ac.uk Institute for Learning and Research Technology ILRT University of Bristol Information Services +44 117 9287083 8-10 Berkeley Square, Bristol, BS8 1HH http://www.ilrt.bris.ac.uk On Thu, 22 Apr 2004, Dominic Hiles wrote:
---------- Forwarded Message ---------- Date: 22 April 2004 08:39 -0700 From: Aaron Freeman <afreeman@emprise.net> To: zope@zope.org Subject: [Zope] Any Ad Hoc Query Tools
Anyone know of a framework or tool for dealing with ad hoc queries against a star-schema database for zope?
After scratching around the zope and plone sites, I wasn't able to find anything; any leads would be great.
-Aaron
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
---------- End Forwarded Message ----------
---------------------------------------------------------------- Dominic Hiles Web Developer Internet Development Group Institute for Learning and Research Technology University of Bristol 8-10 Berkeley Square Bristol BS8 1HH
Tel: +44 (0)117 331 4280 Email: dominic.hiles@bristol.ac.uk WWW: <http://www.ilrt.bris.ac.uk/aboutus/staff?search=bzdnh>