def convertArduinoEntry01ToText(entry0,entry1): entryName = "UNKNOWN %i %s " % (entry0, entry1) if (entry0 == 0): entryName ="LOGNoEvent" if (entry0 == 1): entryName ="LOGPiShutdown" if (entry0 == 2): entryName ="LOGPiStartup" if (entry0 == 3): entryName ="LOGPiOff" if (entry0 == 4): entryName ="LOGPiOn" if (entry0 == 5): # LOGPiPower has voltage as entryData1 entryName ="LOGPiPower: %s" % entry1 if (entry0 == 6): # LOGPiInterrupt has reason as entryData1 entryName ="LOGPiInterrupt: %s" % entry1 if (entry0 == 7): entryName ="LOGThresholdsSet" if (entry0 == 8): # LOGSensorFail has sensor # (i2c address) as entryData1 entryName ="LOGSensorFail: %s" % entry1 if (entry0 == 9): # LOGAlarmTriggered has alarm # (as in the check alarm routine) as entryData1 entryAlarm = util.convertAlarmToText(entry1) entryName ="LOGAlarmTriggered: %s" % entryAlarm if (entry0 == 10): entryName ="LOGDeadManSwitchTriggered" if (entry0 == 11): entryName ="LOGArduinoReboot" if (entry0 == 12): entryName ="LOGWatchDogTriggered" if (entry0 == 13): # LOGAlarmTriggered has alarm # (as in the check alarm routine) as entryData1 entryName ="LOGAlarmDisabled: %s" % entry1 if (entry0 == 14): entryName ="LOGPiOnOverruledUnderVoltage" if (entry0 == 15): entryName ="LOGPiOffLowVoltage" if (entry0 == 16): entryName ="LOGPiOnLowVoltageRecovery" if (entry0 == 17): entryName ="LOGSolarSelect" if (entry0 == 18): entryName ="LOGWindSelect" if (entry0 == 19): entryName ="LOGVoltageCancelledRecovery" return entryName
def convertArduinoEntry01ToText(entry0,entry1): entryName = "UNKNOWN %i %s " % (entry0, entry1) if (entry0 == 0): entryName ="LOGNoEvent" if (entry0 == 1): entryName ="LOGPiShutdown" if (entry0 == 2): entryName ="LOGPiStartup" if (entry0 == 3): entryName ="LOGPiOff" if (entry0 == 4): entryName ="LOGPiOn" if (entry0 == 5): # LOGPiPower has voltage as entryData1 entryName ="LOGPiPower: %s" % entry1 if (entry0 == 6): # LOGPiInterrupt has reason as entryData1 myentry1 = entry1 if (entry1 == "0"): myentry1 = "NOINTERRUPT" if (entry1 == "1"): myentry1 = "NOREASON" if (entry1 == "2"): myentry1 = "SHUTDOWN" if (entry1 == "3"): myentry1 = "GETLOG" if (entry1 == "4"): myentry1 = "ALARM1" if (entry1 == "5"): myentry1 = "ALARM2" if (entry1 == "6"): myentry1 = "ALARM3" if (entry1 == "7"): myentry1 = "REBOOT" entryName ="LOGPiInterrupt: %s" % myentry1 if (entry0 == 7): entryName ="LOGThresholdsSet" if (entry0 == 8): # LOGSensorFail has sensor # (i2c address) as entryData1 entryName ="LOGSensorFail: %s" % entry1 if (entry0 == 9): # LOGAlarmTriggered has alarm # (as in the check alarm routine) as entryData1 entryAlarm = util.convertAlarmToText(entry1) entryName ="LOGAlarmTriggered: %s" % entryAlarm if (entry0 == 10): entryName ="LOGDeadManSwitchTriggered" if (entry0 == 11): entryName ="LOGArduinoReboot" if (entry0 == 12): entryName ="LOGWatchDogTriggered" if (entry0 == 13): # LOGAlarmTriggered has alarm # (as in the check alarm routine) as entryData1 entryName ="LOGAlarmDisabled: %s" % entry1 if (entry0 == 14): entryName ="LOGPiOnOverruledUnderVoltage" if (entry0 == 15): entryName ="LOGPiOffLowVoltage" if (entry0 == 16): entryName ="LOGPiOnLowVoltageRecovery" if (entry0 == 17): entryName ="LOGSolarSelect" if (entry0 == 18): entryName ="LOGWindSelect" if (entry0 == 19): entryName ="LOGVoltageCancelledRecovery" if (entry0 == 20): entryName ="LOGBad5RTCRead" return entryName
def watchdogdatacollect(source, delay):
print("watchdogdatacollect source:%s" % source)
time.sleep(delay)
# blink GPIO LED when it's run
GPIO.setmode(GPIO.BOARD)
GPIO.setup(22, GPIO.OUT)
GPIO.output(22, False)
time.sleep(0.5)
GPIO.output(22, True)
time.sleep(0.5)
GPIO.output(22, False)
time.sleep(0.5)
GPIO.output(22, True)
time.sleep(0.5)
GPIO.output(22, False)
time.sleep(0.5)
GPIO.output(22, True)
# setup serial port to Arduino
# interrupt Arduino to start listening
GPIO.setmode(GPIO.BOARD)
GPIO.setup(7, GPIO.OUT, pull_up_down=GPIO.PUD_DOWN)
GPIO.output(7, False)
GPIO.output(7, True)
GPIO.output(7, False)
ser = serial.Serial('/dev/ttyAMA0', 9600, timeout=1)
#ser.open()
#time.sleep(7.0)
time.sleep(9.0)
# send the first "are you there? command - RD - return from Arduino OK"
response = util.sendCommandAndRecieve(ser, "RD")
print("response=", response);
if (response == "OK\n"):
print "Good RD Response"
else:
print "bad response from RD"
pclogging.log(pclogging.ERROR, __name__, "RD failed from Pi to BatteryWatchDog")
ser.close()
return
# Read the value
# send the watchdog timer first
sendWatchDogTimer.sendWatchDogTimer("watchdogdatacollect", 0,ser)
# Send the GD (Get Data) Command
response = util.sendCommandAndRecieve(ser, "GD")
print("response=", response);
# stuff the values into variables
splitList = response.split(',')
print(splitList)
for item in range(len(splitList)):
splitList[item] = splitList[item].replace('NAN', "0.0")
print(splitList)
if (len(splitList) == 15):
ArInputVoltage = float(splitList[0])
ArInputCurrent = float(splitList[1])
SolarCellVoltage = float(splitList[2])
SolarCellCurrent = float(splitList[3])
BatteryVoltage = float(splitList[4])
BatteryCurrent = float(splitList[5])
OutsideHumidity = float(splitList[6])
OutsideTemperature = float(splitList[7])
LastReboot = splitList[8]
BatteryTemperature = float(splitList[9])
FreeMemory = float(splitList[10])
UnregulatedWindVoltage = float(splitList[11])
RegulatedWindVoltage = float(splitList[12])
SolarWind = int(splitList[13])
ArduinoPiBatteryVoltage = float(splitList[14])
else:
print "bad response from GD"
# system setup
pclogging.log(pclogging.ERROR, __name__, "GD failed from Pi to BatteryWatchDog")
# say goodby
response = util.sendCommandAndRecieve(ser, "GB")
print("response=", response);
ser.close()
return
print("ArInputCurrent =", ArInputCurrent)
# power efficiency
if ( (SolarCellCurrent*SolarCellVoltage+BatteryCurrent*BatteryVoltage) == 0):
powerEfficiency = 10000.0;
else:
powerEfficiency = (ArInputCurrent*ArInputVoltage/(SolarCellCurrent*SolarCellVoltage+BatteryCurrent*BatteryVoltage))*100
# if power Efficiency < 0, then must be plugged in so add 500ma @ 5V
if (powerEfficiency < 0.0):
if ((SolarCellCurrent*SolarCellVoltage+BatteryCurrent*BatteryVoltage+5.0*500.0) == 0.0):
powerEfficiency = 10000.0;
else:
powerEfficiency = (ArInputCurrent*ArInputVoltage/(SolarCellCurrent*SolarCellVoltage+BatteryCurrent*BatteryVoltage+5.0*500.0))*100
# get the unread log from the Arduino
response = util.sendCommandAndRecieve(ser, "SL")
print("response=", response)
try:
countEntry = int(response)
except ValueError:
countEntry = 0
if (countEntry > 0):
# read all unread entries
for i in range(countEntry):
logEntry = util.recieveLine(ser)
print("recievedLogEntry =", logEntry)
# parse and then stuff in log database
# stuff the values into variables
splitList = logEntry.split(',')
print(splitList)
if (len(splitList) == 4):
ArduinoTime = splitList[0]
ArduinoLevel = int(splitList[1])
ArduinoData0 = int(splitList[2])
ArduinoData1 = splitList[3]
# now we have the data, stuff it in the database
entryValue = util.convertArduinoEntry01ToText(ArduinoData0, ArduinoData1)
if (ArduinoData0 == 9):
# LOGAlarmTriggered
entryValue = util.convertAlarmToText(int(ArduinoData1))
try:
print("trying database")
con = mdb.connect('localhost', 'root', conf.databasePassword, 'ProjectCuracao');
cur = con.cursor()
print "before query"
query = "INSERT INTO systemlog(TimeStamp, Level, Source, Message) VALUES('%s', '%s', '%s', '%s')" % (ArduinoTime, ArduinoLevel, 'Ardinuo BatteryWatchDog', entryValue)
print("query=%s" % query)
cur.execute(query)
con.commit()
except mdb.Error, e:
print "Error %d: %s" % (e.args[0],e.args[1])
con.rollback()
#sys.exit(1)
finally:
cur.close()
con.close()
del cur
del con
def getArduinoLog(source, delay):
print("watchdogdatacollect source:%s" % source)
time.sleep(delay)
# blink GPIO LED when it's run
GPIO.setmode(GPIO.BOARD)
GPIO.setup(22, GPIO.OUT)
GPIO.output(22, False)
time.sleep(0.5)
GPIO.output(22, True)
time.sleep(0.5)
GPIO.output(22, False)
time.sleep(0.5)
GPIO.output(22, True)
time.sleep(0.5)
GPIO.output(22, False)
time.sleep(0.5)
GPIO.output(22, True)
# setup serial port to Arduino
# interrupt Arduino to start listening
GPIO.setmode(GPIO.BOARD)
GPIO.setup(7, GPIO.OUT, pull_up_down=GPIO.PUD_DOWN)
GPIO.output(7, False)
GPIO.output(7, True)
GPIO.output(7, False)
ser = serial.Serial('/dev/ttyAMA0', 9600, timeout=1)
#ser.open()
ser.flushInput()
ser.flushOutput()
time.sleep(7.0)
# send the first "are you there? command - RD - return from Arduino OK"
response = util.sendCommandAndRecieve(ser, "RD")
print("response=", response);
if (response == "OK\n"):
print "Good RD Response"
else:
print "bad response from RD"
pclogging.log(pclogging.ERROR, __name__, "RD failed from Pi to BatteryWatchDog")
ser.close()
return
# Read the value
# send the watchdog timer first
sendWatchDogTimer.sendWatchDogTimer("watchdogdatacollect", 0,ser)
# get the unread log from the Arduino
response = util.sendCommandAndRecieve(ser, "SL")
print("response=", response)
try:
countEntry = int(response)
except ValueError:
countEntry = 0
if (countEntry > 0):
# read all unread entries
for i in range(countEntry):
logEntry = util.recieveLine(ser)
print("recievedLogEntry =", logEntry)
# parse and then stuff in log database
# stuff the values into variables
splitList = logEntry.split(',')
print(splitList)
if (len(splitList) == 4):
ArduinoTime = splitList[0]
ArduinoLevel = int(splitList[1])
ArduinoData0 = int(splitList[2])
ArduinoData1 = splitList[3]
# now we have the data, stuff it in the database
entryValue = util.convertArduinoEntry01ToText(ArduinoData0, ArduinoData1)
if (ArduinoData0 == 9):
# LOGAlarmTriggered
entryValue = util.convertAlarmToText(int(ArduinoData1))
try:
print("trying database")
con = mdb.connect('localhost', 'root', conf.databasePassword, 'ProjectCuracao');
cur = con.cursor()
print "before query"
query = "INSERT INTO systemlog(TimeStamp, Level, Source, Message) VALUES('%s', '%s', '%s', '%s')" % (ArduinoTime, ArduinoLevel, 'Ardinuo BatteryWatchDog', entryValue)
print("query=%s" % query)
cur.execute(query)
con.commit()
except mdb.Error, e:
print "Error %d: %s" % (e.args[0],e.args[1])
con.rollback()
#sys.exit(1)
finally:
cur.close()
con.close()
del cur
del con
def watchdogdatacollect(source, delay):
print("watchdogdatacollect source:%s" % source)
time.sleep(delay)
# blink GPIO LED when it's run
GPIO.setmode(GPIO.BOARD)
GPIO.setup(22, GPIO.OUT)
GPIO.output(22, False)
time.sleep(0.5)
GPIO.output(22, True)
time.sleep(0.5)
GPIO.output(22, False)
time.sleep(0.5)
GPIO.output(22, True)
time.sleep(0.5)
GPIO.output(22, False)
time.sleep(0.5)
GPIO.output(22, True)
# setup serial port to Arduino
# interrupt Arduino to start listening
GPIO.setmode(GPIO.BOARD)
GPIO.setup(7, GPIO.OUT, pull_up_down=GPIO.PUD_DOWN)
GPIO.output(7, False)
GPIO.output(7, True)
GPIO.output(7, False)
ser = serial.Serial('/dev/ttyAMA0', 9600, timeout=1)
#ser.open()
#time.sleep(7.0)
time.sleep(9.0)
# send the first "are you there? command - RD - return from Arduino OK"
response = util.sendCommandAndRecieve(ser, "RD")
print("response=", response)
if (response == "OK\n"):
print "Good RD Response"
else:
print "bad response from RD"
pclogging.log(pclogging.ERROR, __name__,
"RD failed from Pi to BatteryWatchDog")
ser.close()
return
# Read the value
# send the watchdog timer first
sendWatchDogTimer.sendWatchDogTimer("watchdogdatacollect", 0, ser)
# Send the GD (Get Data) Command
response = util.sendCommandAndRecieve(ser, "GD")
print("response=", response)
# stuff the values into variables
splitList = response.split(',')
print(splitList)
for item in range(len(splitList)):
splitList[item] = splitList[item].replace('NAN', "0.0")
print(splitList)
if (len(splitList) == 15):
ArInputVoltage = float(splitList[0])
ArInputCurrent = float(splitList[1])
SolarCellVoltage = float(splitList[2])
SolarCellCurrent = float(splitList[3])
BatteryVoltage = float(splitList[4])
BatteryCurrent = float(splitList[5])
OutsideHumidity = float(splitList[6])
OutsideTemperature = float(splitList[7])
LastReboot = splitList[8]
BatteryTemperature = float(splitList[9])
FreeMemory = float(splitList[10])
UnregulatedWindVoltage = float(splitList[11])
RegulatedWindVoltage = float(splitList[12])
SolarWind = int(splitList[13])
ArduinoPiBatteryVoltage = float(splitList[14])
else:
print "bad response from GD"
# system setup
pclogging.log(pclogging.ERROR, __name__,
"GD failed from Pi to BatteryWatchDog")
# say goodby
response = util.sendCommandAndRecieve(ser, "GB")
print("response=", response)
ser.close()
return
print("ArInputCurrent =", ArInputCurrent)
# power efficiency
if ((SolarCellCurrent * SolarCellVoltage +
BatteryCurrent * BatteryVoltage) == 0):
powerEfficiency = 10000.0
else:
powerEfficiency = (ArInputCurrent * ArInputVoltage /
(SolarCellCurrent * SolarCellVoltage +
BatteryCurrent * BatteryVoltage)) * 100
# if power Efficiency < 0, then must be plugged in so add 500ma @ 5V
if (powerEfficiency < 0.0):
if ((SolarCellCurrent * SolarCellVoltage +
BatteryCurrent * BatteryVoltage + 5.0 * 500.0) == 0.0):
powerEfficiency = 10000.0
else:
powerEfficiency = (
ArInputCurrent * ArInputVoltage /
(SolarCellCurrent * SolarCellVoltage +
BatteryCurrent * BatteryVoltage + 5.0 * 500.0)) * 100
# get the unread log from the Arduino
response = util.sendCommandAndRecieve(ser, "SL")
print("response=", response)
try:
countEntry = int(response)
except ValueError:
countEntry = 0
if (countEntry > 0):
# read all unread entries
for i in range(countEntry):
logEntry = util.recieveLine(ser)
print("recievedLogEntry =", logEntry)
# parse and then stuff in log database
# stuff the values into variables
splitList = logEntry.split(',')
print(splitList)
if (len(splitList) == 4):
ArduinoTime = splitList[0]
ArduinoLevel = int(splitList[1])
ArduinoData0 = int(splitList[2])
ArduinoData1 = splitList[3]
# now we have the data, stuff it in the database
entryValue = util.convertArduinoEntry01ToText(
ArduinoData0, ArduinoData1)
if (ArduinoData0 == 9):
# LOGAlarmTriggered
entryValue = util.convertAlarmToText(int(ArduinoData1))
try:
print("trying database")
con = mdb.connect('localhost', 'root',
conf.databasePassword, 'ProjectCuracao')
cur = con.cursor()
print "before query"
query = "INSERT INTO systemlog(TimeStamp, Level, Source, Message) VALUES('%s', '%s', '%s', '%s')" % (
ArduinoTime, ArduinoLevel, 'Ardinuo BatteryWatchDog',
entryValue)
print("query=%s" % query)
cur.execute(query)
con.commit()
except mdb.Error, e:
print "Error %d: %s" % (e.args[0], e.args[1])
con.rollback()
#sys.exit(1)
finally:
cur.close()
con.close()
del cur
del con
def convertArduinoEntry01ToText(entry0, entry1):
entryName = "UNKNOWN %i %s " % (entry0, entry1)
if (entry0 == 0):
entryName = "LOGNoEvent"
if (entry0 == 1):
entryName = "LOGPiShutdown"
if (entry0 == 2):
entryName = "LOGPiStartup"
if (entry0 == 3):
entryName = "LOGPiOff"
if (entry0 == 4):
entryName = "LOGPiOn"
if (entry0 == 5):
# LOGPiPower has voltage as entryData1
entryName = "LOGPiPower: %s" % entry1
if (entry0 == 6):
# LOGPiInterrupt has reason as entryData1
myentry1 = entry1
if (entry1 == "0"):
myentry1 = "NOINTERRUPT"
if (entry1 == "1"):
myentry1 = "NOREASON"
if (entry1 == "2"):
myentry1 = "SHUTDOWN"
if (entry1 == "3"):
myentry1 = "GETLOG"
if (entry1 == "4"):
myentry1 = "ALARM1"
if (entry1 == "5"):
myentry1 = "ALARM2"
if (entry1 == "6"):
myentry1 = "ALARM3"
if (entry1 == "7"):
myentry1 = "REBOOT"
entryName = "LOGPiInterrupt: %s" % myentry1
if (entry0 == 7):
entryName = "LOGThresholdsSet"
if (entry0 == 8):
# LOGSensorFail has sensor # (i2c address) as entryData1
entryName = "LOGSensorFail: %s" % entry1
if (entry0 == 9):
# LOGAlarmTriggered has alarm # (as in the check alarm routine) as entryData1
entryAlarm = util.convertAlarmToText(entry1)
entryName = "LOGAlarmTriggered: %s" % entryAlarm
if (entry0 == 10):
entryName = "LOGDeadManSwitchTriggered"
if (entry0 == 11):
entryName = "LOGArduinoReboot"
if (entry0 == 12):
entryName = "LOGWatchDogTriggered"
if (entry0 == 13):
# LOGAlarmTriggered has alarm # (as in the check alarm routine) as entryData1
entryName = "LOGAlarmDisabled: %s" % entry1
if (entry0 == 14):
entryName = "LOGPiOnOverruledUnderVoltage"
if (entry0 == 15):
entryName = "LOGPiOffLowVoltage"
if (entry0 == 16):
entryName = "LOGPiOnLowVoltageRecovery"
if (entry0 == 17):
entryName = "LOGSolarSelect"
if (entry0 == 18):
entryName = "LOGWindSelect"
if (entry0 == 19):
entryName = "LOGVoltageCancelledRecovery"
if (entry0 == 20):
entryName = "LOGBad5RTCRead"
return entryName