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())