def close_all_valves():
valves = Valves.query.all()
for v in valves:
valve_Instance = valve.valve(v.valve_id, v.relay_controller)
valvelog.debug("ValveItem: ")
valvelog.debug(valve_Instance)
close_valve_status = valve_Instance.close_valve()
def delete_valve(valve_id):
valve = db.session.query(Valves).get(valve_id)
del_valve_return = db.session.delete(valve)
valvelog.debug("Return value ", del_valve_return)
db.session.commit()
return jsonify(success=True)
def load_data():
valve_data = []
valves = Valves.query.all()
for s in valves:
next_valve = s.__dict__
del next_valve["_sa_instance_state"]
valve_data.append(next_valve)
valvelog.debug("Valve Data... ")
valvelog.debug(valve_data)
return valve_data
def insert_data():
valvelog.debug("Insert Valve Request...")
new_valve_data = request.json
valvelog.debug(new_valve_data)
# Create the New Valve
new_valve = Valves(valve_name=new_valve_data["valve_name"],
relay_controller=new_valve_data["relay_controller"])
db.session.add(new_valve)
db.session.commit()
ret_valve = {
"valve_id": new_valve.valve_id,
"valve_name": new_valve.valve_name,
"relay_controller": new_valve.relay_controller
}
return jsonify(ret_valve)
def open_valve(valve_id):
valvelog.debug("IN OPEN valve:")
valvelog.debug(valve_id)
open_valve_status = open_valve(valve_id, False, 0)
valvelog.debug(open_valve_status)
return jsonify(open_valve_status)
def update_valve(valve_id):
valvelog.debug("UPDATE VALVE:")
#Find item to update
jsonrequest = request.json
valvelog.debug("json request")
valvelog.debug(jsonrequest)
valve = db.session.query(Valves).get(jsonrequest["valve_id"])
valvelog.debug("Valve to be updated:")
valvelog.debug(valve)
update = {
"relay_controller": jsonrequest["relay_controller"],
"valve_name": jsonrequest["valve_name"]
}
valvelog.debug(update)
db.session.query(Valves).filter_by(
valve_id=jsonrequest["valve_id"]).update(update)
db.session.commit()
return jsonify(request.json)
def get_data():
valvelog.debug("IN getData for valves")
return jsonify(load_data())
def close_valve(valve_id, record_event, event_id):
Valve = Valves.query.get(valve_id)
s_data = Valve.__dict__
valvelog.debug(s_data)
valvelog.debug("Next Valve: {} {} {}".format(Valve.valve_id,
Valve.valve_name,
Valve.relay_controller))
valve_Instance = valve.valve(Valve.valve_id, Valve.relay_controller)
valvelog.debug("ValveItem: ")
valvelog.debug(valve_Instance)
close_valve_status = valve_Instance.close_valve()
valvelog.debug(close_valve_status)
if (record_event):
watering_event = WateringEvent.query.get(event_id)
watering_event.state = "COMPLETE"
watering_event.water_stop = datetime.now()
delta_time = (watering_event.water_stop - watering_event.water_start)
watering_event.open_time = delta_time.total_seconds()
valvelog.debug("Close Valve, Update Watering Event:")
valvelog.debug(watering_event.__dict__)
db.session.commit()
return close_valve_status
def open_valve(valve_id, record_event, trigger_kpa):
Valve = Valves.query.get(valve_id)
s_data = Valve.__dict__
valvelog.debug(s_data)
valvelog.debug("Next Valve: {} {} {}".format(Valve.valve_id,
Valve.valve_name,
Valve.relay_controller))
valve_Instance = valve.valve(Valve.valve_id, Valve.relay_controller)
valvelog.debug("ValveItem: ")
valvelog.debug(valve_Instance)
open_valve_status = valve_Instance.open_valve()
def __init__(self, valve_id, water_start, trigger_kpa):
self.valve_id = valve_id
self.water_start = water_start
self.trigger_kpa = trigger_kpa
watering_event_id = 0
if (record_event):
watering_event = WateringEvent(Valve.valve_id, datetime.now(),
trigger_kpa)
db.session.add(watering_event)
db.session.commit()
watering_event_id = watering_event.p_key
valvelog.debug("Record watering event:")
valvelog.debug(watering_event.__dict__)
valvelog.debug(watering_event_id)
ret_status = {}
ret_status["open_status"] = open_valve_status
ret_status["event_id"] = watering_event_id
return ret_status
def close_valve(valve_id):
valvelog.debug("IN CLOSE valve:")
valvelog.debug(valve_id)
close_valve_status = close_valve(valve_id, False, 0)
return jsonify(close_valve_status)
def get_valve_status(valve_id):
valvelog.debug("IN get status for valve:")
valvelog.debug(valve_id)
Valve = Valves.query.get(valve_id)
s_data = Valve.__dict__
valvelog.debug(s_data)
valvelog.debug("Next Valve: {} {} {}".format(Valve.valve_id,
Valve.valve_name,
Valve.relay_controller))
valve_Instance = valve.valve(Valve.valve_id, Valve.relay_controller)
valvelog.debug("ValveItem: ")
valvelog.debug(valve_Instance)
valve_status = valve_Instance.valve_status()
ret_data = {}
ret_data["status"] = valve_status
valvelog.debug(ret_data)
return jsonify(ret_data)
def valve_status(self):
valvelog.debug("Get Valve Status")
valvelog.debug(self)
# returns the current valve status open, closed, error
relayStates = RELAY.relaySTATE(self.relayAddress)
valvelog.debug("Relay States:")
valvelog.debug(relayStates)
valvelog.debug("Relay Mask:")
valvelog.debug("{0:b}".format(self.relayMask))
valvelog.debug(self.relayMask)
valvelog.debug((relayStates & self.relayMask))
valveStatus = "CLOSED"
if ((relayStates & self.relayMask) != 0):
valvelog.debug("Valve is open!")
valveStatus = "OPEN"
return valveStatus
def __del__(self):
valvelog.debug("Valve Destructor called for Relay: ")
valvelog.debug(self.relayID)
