[storm] Freeze while dropping multiple rows spanning multiple tables

akira nhytro-python at web.de
Tue Oct 2 17:53:40 BST 2007


I have to delete several rows of data at once, I am doing something like 
this:

store.find(JobseekerApplication, JobseekerApplication.user_id == 
session["user_id"]).remove()
store.find(JobseekerAcademicRecord, JobseekerAcademicRecord.user_id == 
session["user_id"]).remove()
store.find(JobseekerIntendedBranch, JobseekerIntendedBranch.user_id == 
session["user_id"]).remove()
store.find(JobseekerIntendedCountry, JobseekerIntendedCountry.user_id == 
session["user_id"]).remove()
store.find(JobseekerIntendedPostcode, JobseekerIntendedPostcode.user_id 
== session["user_id"]).remove()
store.find(JobseekerProfessionalRecord, 
JobseekerProfessionalRecord.user_id == session["user_id"]).remove()
store.find(JobseekerProfile, JobseekerProfile.user_id == 
session["user_id"]).remove()

the problem is, this freezes or crashes once in a while, what would be 
the best way to take care of this?


thanks





More information about the storm mailing list