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)