On Thu, 4 Feb 2021 at 16:17, Christophe Pettus <[email protected]> wrote:
> Having a single convenience method on the connection object that does the
> equivalent of a .execute() and a .fetchall() might be useful, though.
You can already do it (in psycopg3):
for record in conn.execute("query"):
# do stuff
or
records = conn.execute("query").fetchall()
or
record = conn.execute("query").fetchone()
The latter examples are two methods, not one, but I think they compose
nicely enough, no? They are pretty orthogonal.
-- Daniele
