Papercount

#!/usr/bin/env python
# -*- coding: utf-8 -*-
from time import sleep
import RPi.GPIO as GPIO

def reading(sensor):
import time
import RPi.GPIO as GPIO
GPIO.setwarnings(False)

GPIO.setmode(GPIO.BOARD)
TRIG = 11
ECHO = 13

if sensor == 0:
GPIO.setup(TRIG,GPIO.OUT)
GPIO.setup(ECHO,GPIO.IN)
GPIO.output(TRIG, GPIO.LOW)
time.sleep(0.3)

GPIO.output(TRIG, True)
time.sleep(0.00001)
GPIO.output(TRIG, False)

while GPIO.input(ECHO) == 0:
signaloff = time.time()

while GPIO.input(ECHO) == 1:
signalon = time.time()

timepassed = signalon - signaloff
distance = timepassed * 17000
return distance
GPIO.cleanup()
else:
print "Incorrect usonic() function varible."

def sheetwrite(p_distance):
import json
import gspread
from oauth2client.service_account import ServiceAccountCredentials

scope=['https://spreadsheets.google.com/feeds']
credentials=ServiceAccountCredentials.from_json_keyfile_name('project-7766a0463656.json',scope)
gc=gspread.authorize(credentials)
wks=gc.open_by_key('1h41dJKqEmbHdZvM5zvM8MS4RJj7DxEicldyaa4ndC3E').sheet1

#各セルにアクセス
#print (wks.acell('A1'))
#print (wks.acell('B2'))

#書き換え
wks.update_acell('C4',p_distance)
print (wks.acell('C4'))

try:
p_count="false"
p_distance_before=0
while True:
p_distance_now=reading(0)
if p_count != "false":
p_distance_before=p_distance_now
p_count="true"
sheetwrite(p_distance_now)
else:
if abs(p_distance_before-p_distance_now)>2:
#print p_distance_now
p_distance_before=p_distance_now
sheetwrite(p_distance_now)
sleep(10)
except KeyboardInterrupt:
pass
GPIO.cleanup()