Requests após consulta SQL

[Victor Costa]

Boa tarde a todos!

Estou enfrentando um problema que está quebrando minha cabeça.

Preciso fazer um SELECT em minha base de dados SQL Server e posteriormente acessar um site dos correios, logar e baixar arquivos.

Ocorre que quando eu realizo o SELECT e coloco as informações em um dataframe ou lista (como no exemplo abaixo) e depois tento realizar ocorre um erro.
Se eu fizer apenas o request funciona sem maiores problemas, mas em conjunto (na mesma função ou em funções separadas, ocorre esse erro).

Segue código simplificado:

import requests

import pyodbc

# DADOS DE CONEXÃO SQL #

     driver='{ODBC Driver 17 for SQL Server}'

     server='xxxxxxxx.database.windows.net'

     database='xxxx'

     username='xxxxxxx'

     password = 'xxxxxxxx'

     # STRING DE CONEXÃO #

     strCon = 'DRIVER='+driver+';PORT=1433;SERVER='+server+';PORT=1443;DATABASE='+database+';UID='+username+';PWD='+password+';Authentication=ActiveDirectoryPassword'

     sql = '''

             SELECT [CodigoRastreio]

             FROM [dbo].[Correios_Acompanhamento]

             WHERE [DataListaPostagem] >= Getdate()-180 AND [Arquivo] Is null

             '''

     conn = pyodbc.connect(strCon)

     

     cursor = conn.cursor()

     cursor.execute(sql)

     rows = cursor.fetchall()

     conn.close

     result = [row[0] for row in rows]

     print(result)

     

     r = requests.get('https://cas.correios.com.br/login?service=http%3A%2F%2Fapps2.correios.com.br%2Fsgd%2Fcore%2Fseguranca%2Fservice.php')

     print(r.text)

O ERRO AO EXECUTAR AS OPERAÇÕES EM SEQUÊNCIA:

Traceback (most recent call last):

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\connectionpool.py", line 699, in urlopen

    httplib_response = self._make_request(

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\connectionpool.py", line 382, in _make_request

    self._validate_conn(conn)

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\connectionpool.py", line 1010, in _validate_conn

    conn.connect()

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\connection.py", line 411, in connect

    self.sock = ssl_wrap_socket(

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\util\ssl_.py", line 428, in ssl_wrap_socket

    ssl_sock = _ssl_wrap_socket_impl(

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\util\ssl_.py", line 472, in _ssl_wrap_socket_impl

    return ssl_context.wrap_socket(sock, server_hostname=server_hostname)

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\ssl.py", line 500, in wrap_socket

    return self.sslsocket_class._create(

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\ssl.py", line 1040, in _create

    self.do_handshake()

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\ssl.py", line 1309, in do_handshake

    self._sslobj.do_handshake()

ConnectionResetError: [WinError 10054] Foi forçado o cancelamento de uma conexão existente pelo host remoto

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\requests-2.25.1-py3.9.egg\requests\adapters.py", line 439, in send

    resp = conn.urlopen(

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\connectionpool.py", line 755, in urlopen

    retries = retries.increment(

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\util\retry.py", line 531, in increment

    raise six.reraise(type(error), error, _stacktrace)

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\packages\six.py", line 734, in reraise

    raise value.with_traceback(tb)

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\connectionpool.py", line 699, in urlopen

    httplib_response = self._make_request(

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\connectionpool.py", line 382, in _make_request

    self._validate_conn(conn)

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\connectionpool.py", line 1010, in _validate_conn

    conn.connect()

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\connection.py", line 411, in connect

    self.sock = ssl_wrap_socket(

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\util\ssl_.py", line 428, in ssl_wrap_socket

    ssl_sock = _ssl_wrap_socket_impl(

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3-1.26.2-py3.9.egg\urllib3\util\ssl_.py", line 472, in _ssl_wrap_socket_impl

    return ssl_context.wrap_socket(sock, server_hostname=server_hostname)

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\ssl.py", line 500, in wrap_socket

    return self.sslsocket_class._create(

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\ssl.py", line 1040, in _create

    self.do_handshake()

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\ssl.py", line 1309, in do_handshake

    self._sslobj.do_handshake()

urllib3.exceptions.ProtocolError: ('Connection aborted.', ConnectionResetError(10054, 'Foi forçado o cancelamento de uma conexão existente pelo host remoto', None, 10054, None))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

  File "D:\OneDrive\OneDrive - EDP\Aplicacoes\Consumo Irregular\Python\DownloadARCorreios.py", line 219, in <module>

    maintest()

  File "D:\OneDrive\OneDrive - EDP\Aplicacoes\Consumo Irregular\Python\DownloadARCorreios.py", line 217, in maintest

    r = requests.get('https://cas.correios.com.br/login?service=http%3A%2F%2Fapps2.correios.com.br%2Fsgd%2Fcore%2Fseguranca%2Fservice.php')

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\requests-2.25.1-py3.9.egg\requests\api.py", line 76, in get

    return request('get', url, params=params, **kwargs)

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\requests-2.25.1-py3.9.egg\requests\api.py", line 61, in request

    return session.request(method=method, url=url, **kwargs)

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\requests-2.25.1-py3.9.egg\requests\sessions.py", line 542, in request

    resp = self.send(prep, **send_kwargs)

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\requests-2.25.1-py3.9.egg\requests\sessions.py", line 655, in send

    r = adapter.send(request, **kwargs)

  File "C:\Users\ec204238\AppData\Local\Programs\Python\Python39\lib\site-packages\requests-2.25.1-py3.9.egg\requests\adapters.py", line 498, in send

    raise ConnectionError(err, request=request)

requests.exceptions.ConnectionError: ('Connection aborted.', ConnectionResetError(10054, 'Foi forçado o cancelamento de uma conexão existente pelo host remoto', None, 10054, None))

LEMBRANDO QUE CONSIGO EXECUTAR O REQUEST DE FORMA SEPARADA SEM MAIORES PROBLEMAS.