def add(session: FileOperator, name, hardware, maskset, quality, grade, grade_reference, type, customer, is_enabled): die = { "name": name, "hardware": hardware, "maskset": maskset, "quality": quality, "grade": grade, "grade_reference": grade_reference, "type": type, "customer": customer, "is_enabled": is_enabled } session.query(Types.Die()).add(die) session.commit()
def get_all_for_maskset(session: FileOperator, maskset: str) -> list: return session.query(Types.Die())\ .filter(lambda Die: Die.maskset == maskset)\ .all()
def get_all_for_hardware(session: FileOperator, hardware: str) -> list: return session.query(Types.Die())\ .filter(lambda Die: Die.hardware == hardware)\ .all()
def get_die(session: FileOperator, name: str) -> DBObject: return session.query(Types.Die())\ .filter(lambda Die: Die.name == name)\ .one()
def get_hardware(session: FileOperator, name: str) -> list: return session.query(Types.Die())\ .filter(lambda Die: Die.hardware == name and Die.is_enabled)\ .all()
def remove(session: FileOperator, name: str): session.query(Types.Die())\ .filter(lambda Die: Die.name == name)\ .delete() session.commit()
def get_all(session: FileOperator) -> list: return session.query(Types.Die()).all()