You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
async def read_sql_async_asyncpg(self, sql, params=None):
t1 = timeit.default_timer()
try:
conn = await asyncpg.connect(self.cfg.asyncpg_connect_str)
stmt = await conn.prepare(sql)
columns = [a.name for a in stmt.get_attributes()]
data = await conn.fetch(sql, *params)
if not len(data): return None
df = pd.DataFrame(data, columns=columns)
self.log.debug(f'read_sql_async sql: {sql}, params:{params}')
self.log.info(f'perf: {timeit.default_timer() - t1}')
return df
except Exception as exc:
self.log.exception(exc)
finally:
await conn.close()
The error i am getting is complaining about my password (that is what its highlighting anyway)
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/home/jtson/.local/lib/python3.12/site-packages/asyncpg/connection.py", line 2329, in connect
return await connect_utils._connect(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/jtson/.local/lib/python3.12/site-packages/asyncpg/connect_utils.py", line 983, in _connect
addrs, params, config = _parse_connect_arguments(**kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/jtson/.local/lib/python3.12/site-packages/asyncpg/connect_utils.py", line 692, in _parse_connect_arguments
addrs, params = _parse_connect_dsn_and_args(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/jtson/.local/lib/python3.12/site-packages/asyncpg/connect_utils.py", line 294, in _parse_connect_dsn_and_args
host, port = _parse_hostlist(dsn_hostspec, port, unquote=True)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/jtson/.local/lib/python3.12/site-packages/asyncpg/connect_utils.py", line 229, in _parse_hostlist
hostlist_ports.append(int(hostspec_port))
^^^^^^^^^^^^^^^^^^
ValueError: invalid literal for int() with base 10: '<mypwd>'
My password has '!' and another non-ascii character in it in a few places - i wonder if that may be causing it or if its how i have created the connection string above?
Alternatively, the stack trace seems to indicate it wants a port - but I'm using an Azure Postgres Flexible Server - im not sure there is a port available for that...(with psycopg driver, it wasnt necessary to specify a port.)
Any help would be apricated
The text was updated successfully, but these errors were encountered:
the issue with a local PostgreSQL install?:
uvloop?:
My connection string looks like this:
Im connecting as follows:
The error i am getting is complaining about my password (that is what its highlighting anyway)
My password has '!' and another non-ascii character in it in a few places - i wonder if that may be causing it or if its how i have created the connection string above?
Alternatively, the stack trace seems to indicate it wants a port - but I'm using an Azure Postgres Flexible Server - im not sure there is a port available for that...(with psycopg driver, it wasnt necessary to specify a port.)
Any help would be apricated
The text was updated successfully, but these errors were encountered: