On Thursday 15 November 2001 02:33 pm, you wrote: > 1) Database definition managment. It would be Really Great (TM) to > have a tool that took an XML representation of a group of tables > and views, and spat out the DB specific SQL commands to generate > the database. It would be even better if this tool could be > embedded in ANT! The other side of the tool would be the GUI that > you used to create the XML markup. Another Really Great (TM) thing > would be to handle the initial values that needed to be inserted > into the database to make it useable.
I have developed something akin to this for my current project. We have an object model to represent our business domain and we use a relational database for storage. There is an XML document that describes each object and which DB field/table it corresponds to. When the system starts up each object is turned into a Definition object, and I have a StorageIntegrityChecker that can take that Definition and verify that the table, pk, and all columns exist. I have a base class for all SQL statement generation and I've extended that for the bastardized SQL our current DB needs (pervasive. legacy). The StorageIntegrityChecker is currently implemented as phoenix Block. If the group wants, I'm willing to ask management here if they would consider donating the StorageIntegrityChecker piece to the ASF to use as a starting base for what you describe above. Naturally I would want to keep it compatible with what my needs are here so it can continue to be of use to me in addition to the rest of the community. Since the Definition that the block takes is just an interface, it won't be hard to create alternate implementations for different needs. -pete -- peter royal -> [EMAIL PROTECTED] -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
