def add(session: FileOperator, name: str, device: str, hardware: str, quality: str, grade: str, grade_reference: str, type: str, customer: str, is_enabled=True): # existing_products = Product.get_all(session) # if name in existing_products: # raise KeyError(f"product '{name}' already exists") product = { "name": name, "device": device, "hardware": hardware, "is_enabled": is_enabled, "grade": grade, "quality": quality, "grade_reference": grade_reference, "type": type, "customer": customer } session.query(Types.Product()) session.add(product) session.commit()
def add_or_update_qualification_flow_data(session: FileOperator, quali_flow_data: DBObject): item = QualificationFlowDatum._get_by_name( session, quali_flow_data.read_attribute("name")) if item is not None: session.filter(lambda x: x.name == item.name).delete() session.add(quali_flow_data.to_dict()) session.commit()