def pump_override(identifier,gpio_pins): water_levelRead_new.readLevel() if globalVals.waterLevel != -1 and globalVals.waterLevel < globalVals.waterLevelThreshold: GPIO.output(gpio_pins[0], GPIO.LOW) GPIO.output(gpio_pins[1], GPIO.HIGH) GPIO.output(gpio_pins[2], GPIO.HIGH) GPIO.output(gpio_pins[3], GPIO.HIGH) if not(globalVals.isSent): message = client.messages.create(to="+16177635155", from_="+18572541957", body="pGnome Alert: please refill the water in the rain barrel.") globalVals.isSent = True globalVals.pumpOn = False print "turning pump off" print "pump_override"
def data_water_collect(identifier, txt=''):
unlock_db("myDBfile.sqlite3")
#connect to the local database#
myDatabase = sqlite3.connect("myDBfile.sqlite3", check_same_thread=False)
cur = myDatabase.cursor()
water = water_levelRead_new.readLevel()
print "current water level reading: ", water
if water != -1:
while True:
try:
if row_water_count(cur)[0] == 0:
insert_water_db(cur, water)
else:
update_water_db(cur, water)
break
except Exception:
unlock_db("myDBfile.sqlite3")
try:
myDatabase.commit()
myDatabase.close()
except Exception:
myDatabase.rollback()
print "data_water_collect"
