db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Garcia" <SGar...@qrs.com>
Subject RE: Diffing XML Schemas
Date Wed, 19 Nov 2003 04:56:53 GMT
> Greetings,
> 
> Yes, please. This is good. I suppose you are providing an ANT 
> task for this to be executed, right ?

Yes, I do plan on providing an ANT task for executing this feature.
 
> Yes, again, I would like to ask for the proper 
> procedure/criteria for us to give our contribution to the 
> project. As it seems no feedbacks were given to the ideas contributed.
> 
> Thanks.
> 
> Chiu Yee Weay
> Systems Engineer
> Paradigm Systems Sdn Bhd
> 
> -----Original Message-----
> From: Steve Garcia [mailto:SGarcia@qrs.com] 
> Sent: Wednesday, November 19, 2003 12:29 PM
> To: 'torque-dev@db.apache.org'
> Subject: RE: Diffing XML Schemas
> 
> Hello!  About a month ago I asked (the question below) about 
> the ability to "incrementally" update a database schema given 
> an XML schema.  Torque didn't offer this feature, and I 
> couldn't find any java-based solutions on the web after 
> searching for some time (there are some Embarcadero tools 
> that do this but they are expensive and do not have a Java API).
> 
> So I've decided to download the Torque Generator source (3.1) 
> and code in this feature myself.  After some considerable 
> headway I realized that this might be useful to other 
> individuals as well, and I subsequently thought about 
> contributing my work to the Torque Generator Project.  
> Accordingly I want to ping the Torque-Dev group on their 
> interest in incorporating these features.  Here is a summary 
> of what I have added (or will complete within the next month):
> 
> 1.  Given a source Torque XML schema and a target RDBMS, 
> create only the "sql upgrade file" and upgrade the target 
> RDBMS to conform to the source XML schema file.
> 
> This is a nice feature because it allows users to alter 
> specific schema objects without dropping the entire schema.  
> This is especially useful when you have multiple version of 
> your schema that you are releasing to the public, and you 
> have to upgrade the database.  A simple use case is you 
> release your v1.0 product, and when you release v2.0 you just 
> want to upgrade the schema, export/drop/build/import the data.
> 
> Right now I'm planning on supporting changes to 
>   tables
>   columns
>   indexes
>   foreignkeys
>   unique constraints
> 
> I am (obviously) going to do this in a database-independent 
> way as that is the real power of Torque.  I have also written 
> numerous unit tests to confirm that all of this stuff that I 
> have done works.  This whole project essentially entails 
> using the ALTER statement to modify database schemas.
> 
> Is this feature something that people here would be 
> interested in?  I would appreciate your comments.  If you 
> wish, I will explain in more detail what I've done, what 
> classes I've modified, etc.
> 
> Thanks, Steve Garcia
> 
> > -----Original Message-----
> > From: Scott Eade [mailto:seade@backstagetech.com.au]
> > Sent: Tuesday, October 14, 2003 6:39 PM
> > To: Apache Torque Users List
> > Subject: Re: Diffing XML Schemas
> > 
> > 
> > Steve Garcia wrote:
> > 
> > >I would like to use Torque to generate our SQL from an XML
> > schema.  One
> > >of our requirements is to upgrade existing schemas to the current 
> > >schema definition.  Does Torque have any tools to diff two
> > Torque XML
> > >Schemas and produce the resulting upgrade SQL script?  If not, are 
> > >there other tools that you know of that can help do this?
> > >  
> > >
> > Torque doesn't provide for this.  I myself am unaware of 
> other tools 
> > that do.
> > 
> > Scott
> > 
> > --
> > Scott Eade
> > Backstage Technologies Pty. Ltd. http://www.backstagetech.com.au
> > 
> > 
> > 
> > 
> > 
> > 
> ---------------------------------------------------------------------
> > 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
> 
> 
> [ Scanned by JARING E-Mail Virus Scanner ( http://www.jaring.my ) ]
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-dev-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


Mime
View raw message