Netflix / security_monkey / 709

68%

Pull #522

travis-ci

Optimize SQL for account delete

Type: generic-bugfix

Why is this change necessary?
We were getting intermittent integrity errors and timeouts when
deleting accounts with many items and issues. This appears to be
caused by SQL Alchemy's method of handling cascading deletes,
which is inefficient and does not appear to handle transactional
locks well, allowing for race conditions.

This change addresses the need by:
Deleting accounts and related records with a raw sql query

39 of 39 new or added lines in 2 files covered. (100.0%)

4841 of 9056 relevant lines covered (53.46%)

0.53 hits per line