db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ramesh Sabeti" ...@reazon.com>
Subject RE: How to update multiple rows
Date Tue, 11 Nov 2003 21:10:01 GMT
I like the version of doUpdate(Criteria, Criteria) that Amit suggested.
I've tested it and it works.  But I'd really like to understand Bill's
suggestion.  I still don't understand why BasePeer.doUpdate is called
and not BookPeer.doUpdate...

> -----Original Message-----
> From: Tulsi Das [mailto:quixote_arg@yahoo.com]
> Sent: Tuesday, November 11, 2003 1:03 PM
> To: Apache Torque Users List
> Subject: RE: How to update multiple rows
> 
> If I´m not mistaken (haven´t used update much), the clauses that go in
> the WHERE part are those that take a SqlEnum argument
> 
> so in your example, the code generates:
> 
> UPDATE PRICE = 0, AUTHOR = 'ME' WHERE ID>100
> 
> please correct me if I´m wrong
> 
> Tulsi
> 
>  --- "Cloves Carneiro Jr." <CCarneiro@EXTEND.COM> escribió:
> > Hey
> >
> > I am also new to Torque and have a simple question. From what you
> > described, using the book example, would the criteria objects for
> > those two UPDATE statements be the same?
> >
> > UPDATE PRICE = 0, AUTHOR = 'ME' WHERE ID>100
> > and
> > UPDATE PRICE = 0 WHERE AUTHOR = 'ME' AND ID > 100
> >
> > Criteria c = new Criteria();
> > c.add(BookPeer.BOOK_PRICE, 0);
> > c.add(BookPeer.AUTHOR, "ME");
> > c.add(BookPeer.BOOK_ID, 100, Criteria.LESS_THAN);
> > BasePeer.doUpdate(c);
> >
> > Thx
> >
> > -----Original Message-----
> > From: Tulsi Das [mailto:quixote_arg@yahoo.com]
> > Sent: Tuesday, November 11, 2003 3:53 PM
> > To: Apache Torque Users List
> > Subject: RE: How to update multiple rows
> >
> >
> > The criteria is just a hashtable extension to store all the
mappings,
> > later on, when calling the methods, the SQL generator knows where to
> > insert them ( if you are lucky ;) )
> >
> > tulsi
> >
> >  --- Ramesh Sabeti <rs@reazon.com> escribió:
> > > I meant in the example provided by Bill.  If you set the criteria
> > as
> > > suggested, Torque would use it in the WHERE clause and not in the
> > SET
> > > clause, right?
> > >
> > > > -----Original Message-----
> > > > From: Tulsi Das [mailto:quixote_arg@yahoo.com]
> > > > Sent: Tuesday, November 11, 2003 12:45 PM
> > > > To: Apache Torque Users List
> > > > Subject: RE: How to update multiple rows
> > > >
> > > > It doesn´t know untill you call
> > > >
> > > > doSelect()
> > > > or
> > > > doUpdate()
> > > > or even
> > > > doDelete() methods
> > > >
> > > > that´s why it´s only called "Criteria"
> > > >
> > > > regards
> > > >
> > > > Tulsi
> > > >
> > > >  --- Ramesh Sabeti <rs@reazon.com> escribió:
> > > > > How does torque know that c.add(BookPeer.BOOK_PRICE, 0) is to
> > SET
> > > a
> > > > > value and not for comparison purposes?
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Bill Leng [mailto:wleng@metatomix.com]
> > > > > > Sent: Tuesday, November 11, 2003 6:18 AM
> > > > > > To: Apache Torque Users List
> > > > > > Subject: Re: How to update multiple rows
> > > > > >
> > > > > > You can do something like this
> > > > > > Criteria c = new Criteria();
> > > > > > c.add(BookPeer.BOOK_PRICE, 0);
> > > > > > c.add(BookPeer.BOOK_ID, 100, Criteria.LESS_THAN);
> > > > > > BasePeer.doUpdate(c);
> > > > > >
> > > > > > Ramesh Sabeti wrote:
> > > > > >
> > > > > > >I have a very simple question: How do you do something like
> > > this
> > > > > with
> > > > > > >Torque?
> > > > > > >
> > > > > > >	Update book set book_price = 0 where book_id < 100
> > > > > > >
> > > > > > >Wish there were more online resources.
> > > > > > >
> > > > > > >Thanks,
> > > > > > >
> > > > > > >Ramesh.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> >---------------------------------------------------------------------
> > > > > > >To unsubscribe, e-mail:
> > torque-user-unsubscribe@db.apache.org
> > > > > > >For additional commands, e-mail:
> > > torque-user-help@db.apache.org
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > > --
> > > > > > Bill Leng
> > > > > > Sr. Software Engineer
> > > > > > Metatomix, Inc.
> > > > > > Tel: (901)261-8911
> > > > > > Fax: (901)261-8901
> > > > > >
> > > > > >
> > > > > >
> >
> >
---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> >
> 
> ------------
> ¡Ayudá a los chicos navegando!
> En noviembre, Yahoo! dona un plato de comida por cada nuevo usuario
que
> nevegue gratis con Yahoo! Conexión.
> Conectate ya en http://conexion.yahoo.com.ar
> 
> ---------------------------------------------------------------------
> 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-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message