def _get_by_name(session: FileOperator, name: str) -> DBObject: return session.query(Types.Qualification())\ .filter(lambda QualificationFlowDatum: QualificationFlowDatum.name == name)\ .one_or_none()
def remove(session: FileOperator, quali_flow_data: DBObject): session.query(Types.Qualification()) \ .filter(lambda QualificationFlowDatum: (QualificationFlowDatum.name == quali_flow_data.name and QualificationFlowDatum.type == quali_flow_data.type and QualificationFlowDatum.product == quali_flow_data.product))\ .delete() session.commit()
def get_data_for_flow(session: FileOperator, flow_type: str, product: str) -> DBObject: return session.query(Types.Qualification())\ .filter(lambda QualificationFlowDatum: (QualificationFlowDatum.type == flow_type and QualificationFlowDatum.product == product))\ .all()