Re: create-db.sql & schema.sql

[Thomas Fischer <tf...@apache.org>]

If I understand you correctly, you would like to introduce extra ant /
maven tasks for dropping databases and schemata.

In the process of releasing Torque 3.2, I would strongly object to change 
the behaviour of the existing target torque:create-db between release 
candidates. However, in my opinion, splitting the torque:insert-sql into 
two targets, e.g.  drop-schema.sql, and create-schema.sql, is fine.

If this is done, it should be done for each database Torque supports :-)

    Thomas



On Wed, 9 Nov 2005, Hilco Wijbenga wrote:

> Currently, 'create-db.sql' contains both the 'drop database' and 'create
> database' statements. The same applies to the 'schema.sql': both the
> 'drop table/sequence/...' and the corresponding 'create
> table/sequence/...' statements are in the same file.
>
> I would like to suggest the drop and create statements be stored in
> separate files: drop-db.sql, create-db.sql, drop-schema.sql, and
> create-schema.sql (or something similar).
>
> The problem I'm having is that the 'drop table/sequence/...' statements
> fail because I've already executed 'drop database'. Naturally, I can
> tell Ant to ignore all those errors but that hides any 'real' errors
> (which I encounter every now and then :-) ).
>
> This doesn't sound too difficult so I think I could create a patch for
> this if there is not a lot of opposition. Thoughts?
>
> Thanks,
> Hilco
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org