types-psycopg2 changelog and release notes | PyPI

NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →

2.9.2017 Aug 20222 sources agree

Additional return types for psycopg2 connections

Additional return types for psycopg2 connections (#8528)

Return types for psycopg2 dict connections

DB connection and cursor methods that deal with dict-style results now indicate the expected return types as implemented.

Return types for psycopg2 namedtuple connections

DB connection and cursor methods that deal with namedtuple results now indicate the expected return types as implemented.

Use ABC iterator

As required by flake8, the Iterator referenced in psycopg2's extras module has been switched to the collections.abc.Iterator[T] variant.

Fix base psycopg2 cursor iter return type

The previous return type of Self is wrong; cursor's __iter__ method returns an Iterator.

Correct return type for cursor iter and next methods

The previous attempt to fix the return type of cursor's (and subclasses) __iter__ method was misguided; they should indeed return Self. It's the __next__ methods that had to be updated to return the correct record/row instance type.

Comprehensive overloads for psycopg2 extra connections

Provides full method signatures for the cursor methods of the DictConnection, RealDictConnection and NamedTupleConnection types. Notably this includes a default value for cursor_factory in each case, while preserving the option to override the parameter manually.

Have mypy ignore incompatible psycopg2 return types

The return types of the fetch* and __next__ methods of DictCursor, RealDictCursor and NamedTupleCursor are incompatible with the base cursor class's corresponding methods' return types. However, this does accurately reflect reality, so ignore the mypy errors in those cases.

Use ABC callable for psycopg2 extras module

As required by flake8, the Callable referenced in psycopg2's extras module has been switched to the Callable variant.

Remove superfluous psycopg2 member overrides

Several members in the DictCursorBase type definition were entirely unnecessary, so they have been removed. In addition, adds a type to the size param of the cursor's fetchmany method.

Open source →

2.9.1421 May 20222 sources agree

Annotations for psycopg2.ConnectionInfo

Annotations for psycopg2.ConnectionInfo (#7834)

Annotations for psycopg2.ConnectionInfo

These annotations come from the documentation here:

https://www.psycopg.org/docs/extensions.html#psycopg2.extensions.ConnectionInfo If there was doubt, I referred to the libpq documentation cited by psycopg2's docs.

I wasn't completely sure about dsn_parameters. Psycopg2's docs list it as an dict, and the example suggests it's a dict[str, str] at that. From psycopg2's source I found

https://github.com/psycopg/psycopg2/blob/1d3a89a0bba621dc1cc9b32db6d241bd2da85ad1/psycopg/conninfo_type.c#L183-L206

which is implemented here:

https://github.com/psycopg/psycopg2/blob/1d3a89a0bba621dc1cc9b32db6d241bd2da85ad1/psycopg/utils.c#L251-L279

I'm no expert in CPython's API, but this looks to me like it's building a dict[str, str].

Additionally, the libpq docs

https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PQCONNINFO https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PQCONNDEFAULTS

show that the underlying data just consists of strings.

Additionally, I'm pretty sure from this chunk of source

https://github.com/psycopg/psycopg2/blob/1d3a89a0bba621dc1cc9b32db6d241bd2da85ad1/psycopg/conninfo_type.c#L581-L598

That ConnectionInfo.__init__ takes one positional-only argument, which must be a psycopg2.connection. But I don't think users are intended to be constructing this type, so I've not added that annotation.

Annotate connection.info and related attributes
Make ConnectionInfo attributes properties

According to https://github.com/psycopg/psycopg2/blob/1d3a89a0bba621dc1cc9b32db6d241bd2da85ad1/psycopg/conninfo_type.c#L534-L563

Mark connection attributes as readonly

according to https://github.com/psycopg/psycopg2/blob/8ef195f2ff187454cc709d7857235676bb4176ee/psycopg/connection_type.c#L1244

Explain why some properties aren't T | None

Open source →