Re: Simple SQL generation based upon ECS

michel rodriguez <[email protected]> 07 May 2002 23:41:30 +0200
Newsgroups gmane.comp.jakarta.ecs.devel
Message-ID <1020807690.3966.2.camel@lamachine>
Le lun 06/05/2002 à 23:41, Jon Scott Stevens a écrit :
> on 5/6/02 2:35 PM, "michel rodriguez" <[email protected]> wrote:
> 
> > Hi
> > 
> > I coded a simple, Oracle orientated SQL subset of classes, upon ECS.
> > Very far from jdo. I needed for a dynamic SQL query tool project at
> > work. 
> > 
> > It looks like that
> > 
> > query = new SQLQuery()
> >            .addElement(new SQLSelectElement("field1",alias1")
> >            .addElement(new SQLFromElement("table1","tab1")
> > ...
> > ---> SELECT field1 AS alias1 FROM table1 tab1 ...
> > 
> > and so on
> > 
> > I could clean it up and make it Turbine Compliant if there is an
> > interest to commit it into ECS.
> > 
> > Tell me what do you think about it
> 
> Why not just use Torque?
> 
> -jon
> 
I didn't know Torque that's the reason :-)
After a (quick) look, Torque seems to be DDL orientated, my purpose was
to generate DML, specially Select queries