asyncpg

asyncpg copied to clipboard

Fixes #448 This change adds a `fetchmany` method to `Pool`, `Connection`, and `PreparedStatement` which allows you execute `INSERT ... RETURNING` with a list of values and get the result.

rossmacarthur

* **asyncpg version**: 0.29.0 * **PostgreSQL version**: 15.7 * **Python version**: 3.11 * **Platform**: macOS 13.6 * **Do you use pgbouncer?**: no * **Did you install asyncpg with pip?**: no...

ccrvlh

No rows returned by fetch() when for DELETE rewritten to UPDATE using rule

2

* **asyncpg version**: 0.29.0 * **PostgreSQL version**: 16.2 (`postgres:latest` Docker image) * **Python version**: 3.12.3 * **Platform**: Tested on macOS and Linux * **Do you use pgbouncer?**: No * **Did...

DvdGiessen

Does asyncpg support using `pg_service.conf` for connection parameters?

1

* **asyncpg version**: 0.29.0 * **PostgreSQL version**: 16.2 * **Do you use a PostgreSQL SaaS? If so, which? Can you reproduce the issue with a local PostgreSQL install?**: local *...

CodeBardian

This relates to [an issue](https://github.com/MagicStack/asyncpg/issues/1148) I created a few months back and then updated last week. GCP's [cloud-sql-python-connector](https://github.com/GoogleCloudPlatform/cloud-sql-python-connector/tree/main) offers asyncpg as one of its drivers - see logic [here](https://github.com/GoogleCloudPlatform/cloud-sql-python-connector/blob/f4ba6bba1ef004002fa934a72ad15048be220d98/google/cloud/sql/connector/connector.py#L317) -...

d1manson

Not accepting str as value for interval/date columns

2

* **asyncpg version**: 0.29.0 * **PostgreSQL version**: 15.7 * **Do you use a PostgreSQL SaaS? If so, which? Can you reproduce the issue with a local PostgreSQL install?**: local *...

riwu

Remove extra line in config

ArtemIsmagilov

Add equivalent to psycopg2 `register_adapter`

2

In psycopg2, `register_adapter` along with utility functions provides a useful way to map custom Python classes into valid representations, often by relatively simple behaviors such as casting to `str`. There...

dgilman-hrp

You've got: - `fetchval` for scalars - `fetchrow` for a horizontal list of values - `fetch` for a list of list of values But I don't see a convenience method...

ofer-pd

[BUG] Bare connections cannot be used as context managers

2

* **asyncpg version**: 0.20.1 * **PostgreSQL version**: 10.3 * **Python version**: 3.8.2 * **Platform**: Windows * **Do you use pgbouncer?**: No * **Did you install asyncpg with pip?**: Yes While...

sm-Fifteen