我正在嘗試Postgres使用腳本中的requests庫(kù)測(cè)試存儲(chǔ)在數(shù)據(jù)庫(kù)中的 URL 的有效性Python 3.x,但出現(xiàn)以下錯(cuò)誤:$ python3 test_urlvalid.pyTraceback (most recent call last): File "test_urlvalid.py", line 55, in <module> response = requests.get(row) File "...python3.7/site-packages/requests/api.py", line 75, in get return request('get', url, params=params, **kwargs) File "...python3.7/site-packages/requests/api.py", line 60, in request return session.request(method=method, url=url, **kwargs) File "...python3.7/site-packages/requests/sessions.py", line 533, in request resp = self.send(prep, **send_kwargs) File "...python3.7/site-packages/requests/sessions.py", line 640, in send adapter = self.get_adapter(url=request.url) File "...python3.7/site-packages/requests/sessions.py", line 731, in get_adapter raise InvalidSchema("No connection adapters were found for '%s'" % url)requests.exceptions.InvalidSchema: No connection adapters were found for '('http://sampleurl.com',)'這是我的腳本的一個(gè)片段:dbconn = create_engine('postgresql+psycopg2://' + user + ':' + password + '@' + host + ':' + str(port) + '/' + database , echo=False)dbconnraw = dbconn.raw_connection()cur = dbconnraw.cursor()cur.execute('SELECT email_domain_url FROM testurlsource')rows = cur.fetchall()for row in rows: response = requests.get(row) urlstat = response.status_code if urlstat<400: print('valid') else: print('invalid')錯(cuò)誤代碼所指的行是:response = requests.get(row)由于錯(cuò)誤代碼的最后一行%s在 url 中引用,'('http://sampleurl.com',)'因此它可能與將每個(gè)表?xiàng)l目轉(zhuǎn)換為字符串有關(guān)。也許我需要更改一些內(nèi)容,以便在"(),'"將行輸入腳本時(shí)刪除字符。我嘗試使用regex后者,但出現(xiàn)錯(cuò)誤:AttributeError: 'list' object has no attribute 'encode'有什么建議嗎?
嘗試從 Postgres 表提供 url 時(shí),使用請(qǐng)求庫(kù)的腳本會(huì)拋出“未找到連接適配器”錯(cuò)誤
www說(shuō)
2021-11-02 16:24:20