def testActionedNodes(self): self.createData() query = Session().query(model.SurveyTreeItem)\ .filter(model.SurveyTreeItem.session == self.survey_session)\ .order_by(model.SurveyTreeItem.path) nodes = query.all() self.assertEqual(len(utils.get_actioned_nodes(nodes)), 0)
def get_unanswered_nodes(session): query = Session().query(model.SurveyTreeItem)\ .filter( sql.and_( model.SurveyTreeItem.session == session, sql.or_( oiramodel.MODULE_WITH_UNANSWERED_RISKS_FILTER, oiramodel.UNANSWERED_RISKS_FILTER), sql.not_(model.SKIPPED_PARENTS)))\ .order_by(model.SurveyTreeItem.path) return query.all()
def get_italian_risk_not_present_nodes(session): query = Session().query(model.SurveyTreeItem)\ .filter( sql.and_( model.SurveyTreeItem.session == session, sql.or_( model.SKIPPED_PARENTS, oiramodel.MODULE_WITH_RISKS_NOT_PRESENT_FILTER, oiramodel.SKIPPED_MODULE, oiramodel.UNANSWERED_RISKS_FILTER, )))\ .order_by(model.SurveyTreeItem.path) return query.all()