db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak" <tom...@gmail.com>
Subject Re: Additions to generated XML
Date Tue, 19 Feb 2008 16:42:59 GMT
Hi Daniel,

On Feb 18, 2008 12:42 AM, Daniel López <D.Lopez@uib.es> 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

Mime
View raw message