[sqlalchemy] Re: Deletion

2011-10-19 Thread Fabien Ribes
You're right ! Thanks On Oct 18, 7:32 pm, Mike Conley mconl...@gmail.com wrote: How are you doing the delete? This should delete both.     a = sess.query(Peripheral).filter(Peripheral.label=='some label').one()     sess.delete(a)     sess.commit() This will not work.     a =

[sqlalchemy] Re: Deletion

2011-10-19 Thread Fabien Ribes
On Oct 18, 8:01 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Oct 18, 2011, at 10:03 AM, fribes wrote: Hi all, Despite some doc and web digging, I didn't find how to tell sqa to behave the way I want : on deletion on Peripheral, also delete in Actuator. with the following

[sqlalchemy] Speed matters

2011-06-01 Thread Fabien Ribes
Hi, I have three tables (user, identifiers, groups) with 'many to one' and 'many to many' relationships. My code for deleting a user works correctly but I would like to have it run faster. What improvements do you suggest ? code def delete_list(self, user_ids): Delete a list of users