Google Sheets身份验证大约每隔几个小时到期一次

Question

我目前正在使用gspread在web服务器上连续访问Google Sheets文档。

它托管在Flask web服务器(apache WSGI)上，因此与Google的连接必须是连续的和持续的身份验证。

我遇到了一个问题，几个小时后，我需要重新生成book对象(重新进行身份验证)，否则我会遇到这个问题(见下文)。

下面是我为解决这个问题所做的工作，但我仍然遇到同样的问题，我想知道你是否有任何想法。

有5-6个不同的工作表，我正在创建一个类，用不同的方法访问每个工作表(都是从Access继承的)。

book = authorise()
employee, shift, clock, client, payment = Employee(book), Shift(book), 
Clock(book), Client(book), Payment(book)

def refresh_google_access(self): #CALLED EVERY 40 MINUTES
   book = authorise()
   employee._refresh(book)
   shift._refresh(book)
   clock._refresh(book)
   client._refresh(book)
   payment._refresh(book)

def authorise():
   scope = ['https://spreadsheets.google.com/feeds']
   credentials = ServiceAccountCredentials.from_json_keyfile_name('clocker/access.json', scope)
   gc = gspread.authorize(credentials)
   book = gc.open_by_key(SHEET_KEY)

   return book

class Access:
   def _refresh(self, book):
       self.__init__(book)

class Employee(Access):

   def __init__(self, book):
       self.sheet = book.worksheet("Employee List")

   ...

class Clock(Access):

   def __init__(self, book):
       self.sheet = book.worksheet("Time Log")

   ...

class Shift(Access):

   def __init__(self, book):
       self.sheet = book.worksheet("Shift List")
   ...

class Client(Access):

   def __init__(self, book):
       self.sheet = book.worksheet("Client List")

   ...

class Payment(Access):

   def __init__(self, book):
       self.sheet = book.worksheet("Payments")

   ...

几个小时后( 4-24小时之间的任何时间)，我会得到这个错误：

Traceback (most recent call last):
   File "/home/ve/lib/python3.4/site-packages/flask/app.py", line 2292, in wsgi_app
     response = self.full_dispatch_request()
   File "/home/ve/lib/python3.4/site-packages/flask/app.py", line 1815, in full_dispatch_request
     rv = self.handle_user_exception(e)
   File "/home/ve/lib/python3.4/site-packages/flask/app.py", line 1718, in handle_user_exception
     reraise(exc_type, exc_value, tb)
   File "/home/ve/lib/python3.4/site-packages/flask/_compat.py", line 35, in reraise
     raise value
   File "/home/ve/lib/python3.4/site-packages/flask/app.py", line 1813, in full_dispatch_request
     rv = self.dispatch_request()
   File "/home/ve/lib/python3.4/site-packages/flask/app.py", line 1799, in dispatch_request
     return self.view_functions[rule.endpoint](**req.view_args)
   File "/var/www/clocker/clocker/routes.py", line 43, in voice
     clocked_in = clock.is_clocked_in(id)
   File "/var/www/clocker/clocker/sheet_access.py", line 115, in is_clocked_in
     latest_clock_in = self.get_latest_clock_in(id)
   File "/var/www/clocker/clocker/sheet_access.py", line 107, in get_latest_clock_in
     result = self.sheet.findall(str(id))
   File "/home/ve/lib/python3.4/site-packages/gspread/models.py", line 814, in findall
     return list(self._finder(filter, query))
   File "/home/ve/lib/python3.4/site-packages/gspread/models.py", line 779, in _finder
     data = self.spreadsheet.values_get(self.title)
   File "/home/ve/lib/python3.4/site-packages/gspread/models.py", line 110, in values_get
     r = self.client.request('get', url, params=params)
   File "/home/ve/lib/python3.4/site-packages/gspread/client.py", line 79, in request
     raise APIError(response)
 gspread.exceptions.APIError: {
   "error": {
     "code": 401,
     "message": "Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.",
     "status": "UNAUTHENTICATED"
   }
 }

这几乎每次都可以通过重新启动服务器来修复。

重新生成图书对象似乎无法解决这个问题，我检查了图书的id是否每40分钟更改一次。

Answer 1

如果我理解正确，在我的使用中，当您需要数据时，我会保留gc并调用book = gc.open_by_key(SHEET_KEY)。

基本上，不是将book保存为全局变量，而是保存gc，以便保留以前通过身份验证的会话，并用于进一步的请求。