def send_to_googleSheets(name):
worksheet = None
if worksheet is None:
worksheet = login_open_sheet(GDOCS_OAUTH_JSON, GDOCS_SPREADSHEET_NAME)
dat = datetime.datetime.now()
cpu = psutil.cpu_percent()
tmp = get_temperature()
print(dat)
print('CPU Usage in %: '+str(cpu))
print('Temperature in C: ' +str(tmp))
print('Detect '+str(len(name))+' person')
if(len(name)==1):
try:
worksheet.append_row((str(dat), cpu, tmp,name[0]))
print('name is:'+name[0])
except:
print('Append error, logging in again')
worksheet = None
time.sleep(FREQUENCY_SECONDS)
if(len(name)==2):
try:
print('name is:'+name[0]+' and '+name[1])
worksheet.append_row((str(dat), cpu, tmp,name[0],name[1]))
except:
print('Append error, logging in again')
worksheet = None
time.sleep(FREQUENCY_SECONDS)
print('Wrote a row to {0}'.format(GDOCS_SPREADSHEET_NAME))
time.sleep(FREQUENCY_SECONDS)
def runController():
print 'Runcontroller is running'
tmp = get_temperature()
cpu_usage = psutil.cpu_percent()
now = datetime.datetime.now()
dt = datetime.datetime.now()
dt = dt.strftime("%Y-%m-%d %H:%M:%S")
#dt = now.replace(microsecond=0)
print(dt)
print('Temperature: {0:0.1f} C'.format(tmp))
print('Cpu usage: {0:0.1f} %'.format(cpu_usage))
setDtState(dt)
setTmpState(tmp)
setHmdState(cpu_usage)
import time
import datetime
from system_info import get_temperature
import psutil
import paho.mqtt.client as mqtt
mqttc = mqtt.Client()
mqttc.connect("mqtt.eclipse.org", 1883, 60)
mqttc.loop_start()
while True:
try:
cpu = psutil.cpu_percent()
tmp = get_temperature()
if cpu is None or tmp is None:
time.sleep(2)
continue
now = datetime.datetime.now()
dt = now.replace(microsecond=0)
print(dt)
print('Temperature: {0:0.1f} C'.format(tmp))
print('CPU Usage: {0:0.1f} %'.format(cpu))
mqttc.publish("Raspberry Pi", "%s" % dt)
mqttc.publish("Raspberry Pi", "Temperature: %.1f C" % tmp)
mqttc.publish("Raspberry Pi", "CPU Usage: %.1f %%" % cpu)
time.sleep(10)
except KeyboardInterrupt:
exit()
while True:
if temperature_sheet is None:
temperature_sheet = open_google_sheet(GDOCS_OAUTH_JSON,
GDOCS_SPREADSHEET_NAME,
'temperature')
if humidity_sheet is None:
humidity_sheet = open_google_sheet(GDOCS_OAUTH_JSON,
GDOCS_SPREADSHEET_NAME, 'humidity')
if pressure_sheet is None:
pressure_sheet = open_google_sheet(GDOCS_OAUTH_JSON,
GDOCS_SPREADSHEET_NAME, 'pressure')
#get the data to be written onto the google sheet
system_datetime = datetime.datetime.now()
system_cpu = psutil.cpu_percent()
system_temp = get_temperature()
#env_temp = round(sense.get_temperature(), 1)
env_temp = sense.get_temperature()
env_temp = round(env_temp, 1)
env_humidity = sense.get_humidity()
env_humidity = round(env_humidity, 1)
env_pressure = sense.get_pressure()
env_pressure = round(env_pressure, 1)
print(system_datetime)
print('CPU Usage in %: ' + str(system_cpu))
print('Temperature in C: ' + str(system_temp))
print("Pressure:", env_pressure)
print("Temperature C", env_temp)
print("Humidity :", env_humidity)
parser.add_argument("-r", "--ca_file", help="Certificate Authority file", default='rootCA.pem')
parser.add_argument("-c", "--client_cert_file", help="Client certificate file", default='certificate.pem')
parser.add_argument("-k", "--client_key_file", help="Client Key File", default='private.pem')
parser.add_argument("-p", "--port", help="MQTT port", type=int, default=8883)
parser.add_argument("-q", "--qos", help="MQTT QoS", type=int, default=1)
parser.add_argument("-o", "--topic2", help="Additional MQTT topic")
parser.add_argument("-t", "--topic", help="MQTT topic", required=True)
parser.add_argument("-g", "--log_level", help="log level", type=int, default=logging.INFO)
args = parser.parse_args()
# setup payload
data = dict()
data["state"] = {}
data["state"]["reported"] = {}
data["state"]["reported"]["cpuTemp"] = system_info.get_temperature()
try:
data["state"]["reported"]["wlan0IpAddress"] = system_info.get_ip_address('wlan0')
except:
pass
try:
data["state"]["reported"]["eth0IpAddress"] = system_info.get_ip_address('eth0')
except:
pass
data["state"]["reported"]["totalDiskSpaceRoot"] = system_info.getDiskSpace('/')[0]
data["state"]["reported"]["usedDiskSpaceRoot"] = system_info.getDiskSpace('/')[1]
data["state"]["reported"]["networkConnections"] = system_info.get_connections()
data["state"]["reported"]["ramTotal"] = system_info.get_ram()[0]
data["state"]["reported"]["ramAvailable"] = system_info.get_ram()[1]
data["state"]["reported"]["processCount"] = system_info.get_process_count()
data["state"]["reported"]["upTime"] = system_info.get_up_stats()[0]
