时间戳

首页 > 解决方案 > Google 表格身份验证每隔几个小时左右过期一次

flask - Google 表格身份验证每隔几个小时左右过期一次

问题描述

我目前正在使用gspread在网络服务器上连续访问 Google 表格文档。

它托管在 Flask 网络服务器 (apache WSGI) 上，因此与 Google 的连接必须是连续的并且不断地经过身份验证。

我遇到了一个问题，几个小时后，我需要重新生成图书对象（重新验证），否则我会遇到这个问题（见下文）。

以下是我为尝试解决该问题所做的工作，但我仍然遇到同样的问题，想知道您是否有任何想法。

有 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"
   }
 }

几乎每次都可以通过重新启动服务器来解决此问题。

重新生成 book 对象似乎并不能解决问题，我检查id了 book 是否每 40 分钟更改一次。

标签： flaskgoogle-apps-scriptgoogle-sheetsgoogle-sheets-apigspread

解决方案

如果我理解正确，在我的使用中，当你需要数据时，我会坚持gc并打电话。book = gc.open_by_key(SHEET_KEY)

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

推荐阅读