Ok - I will try to determine if there is a "standard" way to do this. Can you tell me whether the drivers for the current supported databases conform to any particular specification? Python Database API Specification v2.0 seems the appropriate one but I'd like it confirmed.
On Dec 15, 7:17 pm, mdipierro <[email protected]> wrote: > I would very much like to include this but this has to work on all > supported databases. Can you send me a patch? It will be included. > > On Dec 15, 2:26 am, billf <[email protected]> wrote: > > > I would like access to the rowcount returned from update and delete > > actions. There are a couple of reasons: > > > a) it could be used to detect rare errors, e.g. expect 1 row to be > > updated and zero returned. > > > b) if the update/delete affects several rows, I'd like to know how > > many rows were updated without running a separate select, e.g. > > rowcount=db(db.employee.role==request.vars.role).update(request.vars) > > > I believe that this can be achieved quite simply by a patch to sql.py > > update() and delete() methods. > > > Change "self._db._execute(query)" to "return self._db._execute(query)" > > > If you wanted to access "rowcount" with SQLFORM then other changes > > would be required. > > > My questions are: > > > 1) can anyone see a problem with the suggestion? > > > 2) does anyone object to including the proposed patch? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
