Ich versuche, das Python-Modul gspread zu verwenden, um die Google-Tabelle zu lesen. Aber ich erhalte eine Fehlermeldung von SSL. Ich habe versucht, das zu untersuchen, konnte es aber nicht zum Laufen bringen. Das gspread-Modul verwendet intern eine Python-Anfrage, die offenbar das SSL-Paket von Python verwendet. Der Code (den ich geschrieben habe) und der Stack-Trace werden unten mit Umgebungsdetails bereitgestellt. Env:
File "", line 1, in
File "/home/nikhil/.venv/nikhil/src/gspread/gspread/models.py", line 344, in get_all_values
cells = self._fetch_cells()
File "/home/nikhil/.venv/nikhil/src/gspread/gspread/models.py", line 231, in _fetch_cells
feed = self.client.get_cells_feed(self)
File "/home/nikhil/.venv/nikhil/src/gspread/gspread/client.py", line 186, in get_cells_feed
r = self.session.get(url)
File "/home/nikhil/.venv/nikhil/src/gspread/gspread/httpsession.py", line 76, in get
return self.request('GET', url, **kwargs)
File "/home/nikhil/.venv/nikhil/src/gspread/gspread/httpsession.py", line 68, in request
response = func(url, data=data, headers=request_headers, verify=False)
File "/home/nikhil/.venv/nikhil/lib/python2.7/site-packages/requests/sessions.py", line 469, in get
return self.request('GET', url, **kwargs)
File "/home/nikhil/.venv/nikhil/lib/python2.7/site-packages/requests/sessions.py", line 457, in request
resp = self.send(prep, **send_kwargs)
File "/home/nikhil/.venv/nikhil/lib/python2.7/site-packages/requests/sessions.py", line 606, in send
r.content
File "/home/nikhil/.venv/nikhil/lib/python2.7/site-packages/requests/models.py", line 724, in content
self._content = bytes().join(self.iter_content(CONTENT_CHUNK_SIZE)) or bytes()
File "/home/nikhil/.venv/nikhil/lib/python2.7/site-packages/requests/models.py", line 653, in generate
for chunk in self.raw.stream(chunk_size, decode_content=True):
File "/home/nikhil/.venv/nikhil/lib/python2.7/site-packages/requests/packages/urllib3/response.py", line 256, in stream
data = self.read(amt=amt, decode_content=decode_content)
File "/home/nikhil/.venv/nikhil/lib/python2.7/site-packages/requests/packages/urllib3/response.py", line 186, in read
data = self._fp.read(amt)
File "/usr/local/lib/python2.7.13/lib/python2.7/httplib.py", line 573, in read
return self._read_chunked(amt)
File "/usr/local/lib/python2.7.13/lib/python2.7/httplib.py", line 642, in _read_chunked
value.append(self._safe_read(chunk_left))
File "/usr/local/lib/python2.7.13/lib/python2.7/httplib.py", line 688, in _safe_read
chunk = self.fp.read(min(amt, MAXAMOUNT))
File "/usr/local/lib/python2.7.13/lib/python2.7/socket.py", line 384, in read
data = self._sock.recv(left)
File "/usr/local/lib/python2.7.13/lib/python2.7/ssl.py", line 766, in recv
return self.read(buflen)
File "/usr/local/lib/python2.7.13/lib/python2.7/ssl.py", line 653, in read
v = self._sslobj.read(len)
SSLError: [SSL: DECRYPTION_FAILED_OR_BAD_RECORD_MAC] decryption failed or bad record mac (_ssl.c:1864)
UPDATE:
Ich habe alles von Grund auf auf einem neuen Computer eingerichtet und auch den OAuth-Client aktualisiert, um die neue API-Version zu nutzen. Ich konnte die obige Umgebung nicht zum Laufen bringen, daher lasse ich diese Frage vorerst offen.
Ich versuche, das Python-Modul gspread zu verwenden, um die Google-Tabelle zu lesen. Aber ich erhalte eine Fehlermeldung von SSL. Ich habe versucht, das zu untersuchen, konnte es aber nicht zum Laufen bringen. Das gspread-Modul verwendet intern eine Python-Anfrage, die offenbar das SSL-Paket von Python verwendet. Der Code (den ich geschrieben habe) und der Stack-Trace werden unten mit Umgebungsdetails bereitgestellt. [b]Env:[/b] [list] [*]Python: 2.7.13 [*]Ubuntu: 14.04 [*]openssl: 1.0.1f 6. Januar 2014 [/list] [b]Code:[/b] [code]import gspread from oauth2client.client import SignedJwtAssertionCredentials
print list_of_rows [/code] [b]Stack-Trace:[/b] [code]File "", line 1, in File "/home/nikhil/.venv/nikhil/src/gspread/gspread/models.py", line 344, in get_all_values cells = self._fetch_cells() File "/home/nikhil/.venv/nikhil/src/gspread/gspread/models.py", line 231, in _fetch_cells feed = self.client.get_cells_feed(self) File "/home/nikhil/.venv/nikhil/src/gspread/gspread/client.py", line 186, in get_cells_feed r = self.session.get(url) File "/home/nikhil/.venv/nikhil/src/gspread/gspread/httpsession.py", line 76, in get return self.request('GET', url, **kwargs) File "/home/nikhil/.venv/nikhil/src/gspread/gspread/httpsession.py", line 68, in request response = func(url, data=data, headers=request_headers, verify=False) File "/home/nikhil/.venv/nikhil/lib/python2.7/site-packages/requests/sessions.py", line 469, in get return self.request('GET', url, **kwargs) File "/home/nikhil/.venv/nikhil/lib/python2.7/site-packages/requests/sessions.py", line 457, in request resp = self.send(prep, **send_kwargs) File "/home/nikhil/.venv/nikhil/lib/python2.7/site-packages/requests/sessions.py", line 606, in send r.content File "/home/nikhil/.venv/nikhil/lib/python2.7/site-packages/requests/models.py", line 724, in content self._content = bytes().join(self.iter_content(CONTENT_CHUNK_SIZE)) or bytes() File "/home/nikhil/.venv/nikhil/lib/python2.7/site-packages/requests/models.py", line 653, in generate for chunk in self.raw.stream(chunk_size, decode_content=True): File "/home/nikhil/.venv/nikhil/lib/python2.7/site-packages/requests/packages/urllib3/response.py", line 256, in stream data = self.read(amt=amt, decode_content=decode_content) File "/home/nikhil/.venv/nikhil/lib/python2.7/site-packages/requests/packages/urllib3/response.py", line 186, in read data = self._fp.read(amt) File "/usr/local/lib/python2.7.13/lib/python2.7/httplib.py", line 573, in read return self._read_chunked(amt) File "/usr/local/lib/python2.7.13/lib/python2.7/httplib.py", line 642, in _read_chunked value.append(self._safe_read(chunk_left)) File "/usr/local/lib/python2.7.13/lib/python2.7/httplib.py", line 688, in _safe_read chunk = self.fp.read(min(amt, MAXAMOUNT)) File "/usr/local/lib/python2.7.13/lib/python2.7/socket.py", line 384, in read data = self._sock.recv(left) File "/usr/local/lib/python2.7.13/lib/python2.7/ssl.py", line 766, in recv return self.read(buflen) File "/usr/local/lib/python2.7.13/lib/python2.7/ssl.py", line 653, in read v = self._sslobj.read(len) SSLError: [SSL: DECRYPTION_FAILED_OR_BAD_RECORD_MAC] decryption failed or bad record mac (_ssl.c:1864) [/code] [b]UPDATE:[/b] Ich habe alles von Grund auf auf einem neuen Computer eingerichtet und auch den OAuth-Client aktualisiert, um die neue API-Version zu nutzen. Ich konnte die obige Umgebung nicht zum Laufen bringen, daher lasse ich diese Frage vorerst offen.
INSERT -Anweisung:
let db = Database.openDatabase()
let insertStatementString = INSERT INTO SignupDetails VALUES (\((self.txtUsername.text!.trimmingCharacters(in: .whitespaces))),...