I need to preserve the database state by keeping the changes to the tables in a consistent state. If I insert a group of records, I need to make sure they all succeed or fail. I can't commit them one at a time in this case.
-- Joe On Friday, August 9, 2013 1:55:12 PM UTC-7, Niphlod wrote: > > offtopic1: I don't own a mac but it seems that there are binaries for mac > ready (instead of being forced to build from source ) > offtopic2: the choice to use a setpoint is entirely up to you: the same > exact functionality (although a little bit slower, depending on the amount > of data) can very well be replicated with a tailored insert (i.e. before > loading data that may be there already, checking what data is already > there) or - unless you need nested transactions - with a > > db.commit() > try: > your insert statement > db.commit() > except: > db.rollback() > > block, without any hassle in discerning db dialects. > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
