def spreadSheet_insert(t0,t1,t2,h,l):
KEY_FILENAME ='/home/pi/python_apps/hydroponics/auth.json'
SHEET_ID ='1nZhut2Sp8ZlijdCSqxCs4__dDsPXPXUYnu891RYcHqE'
APPEND_RANGE = 'sheet1!A1:D1'
APPEND_LENGTH = 5
sheet = SpreadSheet(KEY_FILENAME,SHEET_ID,APPEND_RANGE,APPEND_LENGTH)
sheet.append(["{0:%Y-%m-%d %H:%M:%S}".format(t0), t1, t2,h,l])
def spreadSheet_insert(keyFileName, sheetId, appendRange, appendLength, t0, t1,
t2, h, l):
sheet = SpreadSheet(keyFileName, sheetId, appendRange, appendLength)
sheet.append(["{0:%Y-%m-%d %H:%M:%S}".format(t0), t1, t2, h, l])
sensors['Magnetic'] = hex(payval(27))
magnetic = sensors['Magnetic']
sensors['Steps'] = payval(28, 2)
step_cnt = sensors['Steps']
if SEQ in [255, 0, 1] and step_cnt == 0:
start_seq += 1
start_time = datetime.now()
start_text = str(start_seq) + "回目を" + start_time.strftime(
'%H:%M:%S') + "にスタート。前回は" + last_time.strftime(
'%H:%M:%S') + "に" + str(last_cnt)
if last_cnt != 0:
line_message(start_text)
sheet.append([
last_time.strftime('%Y/%m/%d'),
last_time.strftime('%H:%M:%S'), last_cnt, last_dur,
last_cal, last_mv, cur_user
])
else:
last_time = start_time
last_cnt = step_cnt
cur_time = datetime.now()
time_text = cur_time.strftime('%Y/%m/%d(%a) %H:%M:%S')
print(time_text)
c.itemconfigure(c1, text=time_text)
if start_seq >= 1:
dur_time = cur_time - start_time
cur_cnt = round(step_cnt * 1.5)
cur_cal = round(cur_cnt / 4)
#!/usr/bin/python3
#coding: utf-8
import time
import datetime
from spreadsheet import SpreadSheet
import bme280
# シート固有のid
sheet = SpreadSheet('xxx')
# データ取得のインターバル[sec]
delay = 600
while (1):
start = time.time()
d_time = datetime.datetime.now().strftime("%Y/%m/%d %H:%M:%S")
sensor = bme280.readData()
sheet.append([d_time, sensor[0], sensor[1], sensor[2]])
lap = time.time() - start
#print("lap_time:{0}".format(end) + "[sec]")
neri = delay - lap
time.sleep(neri)
