Forum OpenACS Development: Response to A query writing tool.

Collapse
Posted by Tom Jackson on

The current version of the package is at http://multi.zmbh.com:8300/query-writer-0.5.3.apm It has been tested on a large datamodel, but only works with PostgreSQL. There are fewer advantages to using it with Oracle. Currently you can input your datamodel and it will generate pg functions for create/update/delete and object_p. It handles overloaded pg functions, and also works with any table with a single attribute primary key without the pg functions being needed.