Hi Daniel, On Feb 18, 2008 12:42 AM, Daniel López <[EMAIL PROTECTED]> wrote:
> On one hand, we were using Torque ant tasks to generate the XML from the > DB schema and generate automatically some code from the XML, and as we > needed some extra info, we did some modifications to the generator code. > > I just recently found out about ddlutils when I was trying to find a > lighter approach, so we've changed to ddlutils and I thought we might > try to contribute back our changes, if people find them useful. That would be great ! As for how, it is probably easiest if you create individual issues in JIRA for each of your enhancements (if not already present, see below), and if you could attach a patch, even better :-) > Basically what we did was: > .- Add a parameter(regexp) so we can filter the tables that are exported > to XML as we sometimes have different sets of tables in the same user > and we just need/want to export some of them. This is already filed as http://issues.apache.org/jira/browse/DDLUTILS-87, but not yet implemented. > .- Include the name and information of the constraints, so it is not > lost. We usually put explicit names in our constraints and those names > can be used to identify errors more easily, so we need them in the XML > so we can generate exception handling code from there. Moreover, we > don't want to lose that information. I'm not quite sure what this means ? Could you give an example of how this looks in SQL and XML ? > .- Added Unique constraints and indexes Unique indexes are already implemented. Unique constraints are filed as http://issues.apache.org/jira/browse/DDLUTILS-85, but not yet implemented. > .- Added also the active rule (NoAction , Cascade, Restrict, SetDefault, > SetNull) for foreign keys. This is covered by http://issues.apache.org/jira/browse/DDLUTILS-75 and already partly implemented in trunk (creation of foreign keys with these works, but not alteration, e.g. adding/removing/changing such a rule). > .- Added RADIX por numerical columns Not quite sure what you refer to ? (DdlUtils has full support for precision & scale for NUMERIC/DECIMAL datatypes if that's what you mean by radix.) > .- Added some code to handle the new definition of TIMESTAMP/DATE > parameters for Oracle version > 8. Could you give an example of this ? > Are these already implemented in ddlUtils? If not we'll probably add the > modifications to our generator, but we'd like to contribute them to the > community, if you find they could be of use. All improvements/fixes that you have are quite welcome ! cheers, Tom
