def delete_crop(crop_id): crop = db.session.query(Crops).get(crop_id) del_crop_return = db.session.delete(crop) croplog.debug("Return value ", del_crop_return) db.session.commit() return jsonify(success=True)
def load_data(): crop_data = [] crops = Crops.query.all() for s in crops: next_crop = s.__dict__ del next_crop["_sa_instance_state"] crop_data.append(next_crop) croplog.debug("Crop Data... ") croplog.debug(crop_data) return crop_data
def insert_data(): croplog.debug("Insert Crop Request...") new_crop_data = request.json croplog.debug(new_crop_data) # Create the New Crop new_crop = Crops(crop_name=new_crop_data["crop_name"], ideal_kpa=new_crop_data["ideal_kpa"], dry_kpa=new_crop_data["dry_kpa"], saturated_kpa=new_crop_data["saturated_kpa"]) db.session.add(new_crop) db.session.commit() ret_crop = { "crop_id": new_crop.crop_id, "crop_name": new_crop.crop_name, "ideal_kpa": new_crop.ideal_kpa, "dry_kpa": new_crop.dry_kpa, "saturated_kpa": new_crop.saturated_kpa } return jsonify(ret_crop)
def update_crop(crop_id): croplog.debug("UPDATE VALVE:") #Find item to update jsonrequest = request.json croplog.debug("json request") croplog.debug(jsonrequest) crop = db.session.query(Crops).get(jsonrequest["crop_id"]) croplog.debug("Crop to be updated:") croplog.debug(crop) update = { "crop_name": jsonrequest["crop_name"], "ideal_kpa": jsonrequest["ideal_kpa"], "dry_kpa": jsonrequest["dry_kpa"], "saturated_kpa": jsonrequest["saturated_kpa"] } croplog.debug(update) db.session.query(Crops).filter_by( crop_id=jsonrequest["crop_id"]).update(update) db.session.commit() return jsonify(request.json)
def get_data(): croplog.debug("IN getData for crops") return jsonify(load_data())