def _delete_release_problems(self, db, opsysrelease_id): self.log_info("Removing problems") (db.session.query(st.ProblemOpSysRelease).filter( st.ProblemOpSysRelease.opsysrelease_id == opsysrelease_id).delete( False)) yield_num = 1000 problems_found = 0 empty_problems = get_empty_problems(db, yield_num) count = 0 for problem in empty_problems: count += 1 self.log_debug("Removing empty problem #%d", problem.id) db.session.delete(problem) if count > yield_num: problems_found += count db.session.flush() count = 0 if count != 0: problems_found += count db.session.flush() self.log_info("Empty problems found: {0}".format(problems_found))
def _delete_release_problems(self, db, opsysrelease_id): self.log_info("Removing problems") (db.session.query(st.ProblemOpSysRelease) .filter(st.ProblemOpSysRelease.opsysrelease_id == opsysrelease_id) .delete(False)) yield_num = 1000 problems_found = 0 empty_problems = get_empty_problems(db, yield_num) count = 0 for problem in empty_problems: count += 1 self.log_debug("Removing empty problem #%d", problem.id) db.session.delete(problem) if count > yield_num: problems_found += count db.session.flush() count = 0 if count != 0: problems_found += count db.session.flush() self.log_info("Empty problems found: {0}".format(problems_found))
def _remove_empty_problems(self, db): self.log_info("Removing empty problems") empty_problems = get_empty_problems(db) self.log_info("Found {0} empty problems".format(len(empty_problems))) for db_problem in empty_problems: self.log_debug("Removing empty problem #{0}".format(db_problem.id)) db.session.delete(db_problem) db.session.flush()
def _remove_empty_problems(self, db): self.log_info("Removing empty problems") empty_problems = get_empty_problems(db) self.log_info("Found {0} empty problems".format(len(empty_problems))) for db_problem in empty_problems: self.log_debug("Removing empty problem #{0}" .format(db_problem.id)) db.session.delete(db_problem) db.session.flush()