[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

[sqlalchemy] Can't adapt type on a Foreign key

2010-10-28 Thread Fabien
) can't adapt type 'EventParameters' 'INSERT INTO event (. Here, my code : http://nopaste.info/d3d74b436e.html And my database schema : http://nopaste.info/8798dcf247.html What's wrong ? :/ Thank you in advance Fabien -- You received this message because you are subscribed to the Google Groups